Introductory Relational Database Design for Business, with Microsoft Access

Introductory Relational Database Design for Business, with Microsoft Access
ISBN-10
1119329418
ISBN-13
9781119329411
Category
Business & Economics
Pages
328
Language
English
Published
2018-01-16
Publisher
John Wiley & Sons
Authors
Jonathan Eckstein, Bonnie R. Schultz

Description

A hands-on beginner’s guide to designing relational databases and managing data using Microsoft Access Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein’s twenty years’ experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience. Relational Database Design for Business, with Microsoft Access helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text: Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access Moves swiftly from conceptual fundamentals to advanced design techniques Leads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization Introductory Relational Database Design for Business, with MicrosoftAccess is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary “hands-on” learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.

Other editions

Similar books

  • Introductory Relational Database Design for Business, with Microsoft Access
    By Jonathan Eckstein, Bonnie R. Schultz

    "This book develops understanding of relational databases step-by-step, through numerous compact but realistic examples that build gradually in complexity.

  • Access Database Design & Programming
    By Steven Roman

    For programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.

  • Beginning Database Design Solutions
    By Rod Stephens

    This book provides readers with proven methods and tools for designing efficient, reliable, and secure databases. Author Rod Stephens explains how a database should be organized to ensure data integrity without sacrificing performance.

  • Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design
    By Terry Halpin

    Englewood Cliffs, NJ: Prentice Hall. Kennedy, P. 1993. Preparing for the Twenty-First Century. London: Harper Collins. Kent, W. 1977. “Entities and Relationships in Information”. Proc. 1977 IFIP Working Conf. on Modelling in Data Base ...

  • Absolute Beginner's Guide to Databases
    By John V. Petersen

    This book covers what databases are used for, why databases are important, why the design of the database is important, database normalization, keys to solid database design, differences in types of databases, and indexes--what they are, ...

  • Beginning Database Design
    By Gavin Powell

    This book provides you with an easy-to-understand explanation of designing and building relational database models to do just that.

  • Learning SQL: Master SQL Fundamentals
    By Alan Beaulieu

    With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

  • SQL for Microsoft Access
    By Cecelia L. Allison, Neal A. Berkowitz

    SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language.

  • Introduction to Database Systems
    By Itl Education Solutions Limited

    Introduction to Database Systems

  • The Language of SQL
    By Larry Rockoff

    This is that book. A number of features make The Language of SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text.