Introductory Relational Database Design for Business, with Microsoft Access

Front Cover
John Wiley & Sons, Nov 3, 2017 - Business & Economics - 328 pages

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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Chapter 1 Basic Definitions and Concepts
1
Chapter 2 Beginning Fundamentals of Relational Databases and MS Access
7
Chapter 3 Introduction to Data Management and Database Design
43
Chapter 4 Basic Relational Database Theory
53
Chapter 5 Multiple Tables in Access
95
Chapter 6 More about Forms and Navigation
127
Chapter 7 ManytoMany Relationships
139
Chapter 8 Multiple Relationships between the Same Pair of Tables
171
Chapter 9 Normalization
189
Chapter 10 Basic Structured Query Language SQL
215
Chapter 11 Advanced Query Techniques
253
Chapter 12 Unary Relationships
279
Further Reading
301
Index
303
EULA
310
Copyright

Other editions - View all

Common terms and phrases

About the author (2017)

Jonathan Eckstein is a Professor in the MSIS (Management Science and Information Systems) department at Rutgers Business School, Rutgers University, USA. He has taught at Harvard and Princeton Universities and has a strong profile on Google Scholar with over 9000 citations.

Bonnie R. Schultz is a freelance writer and editor based in Princeton, New Jersey. She has worked as a technical writer in the software industry as well as a freelance journalist for various news publications.

Bibliographic information