Learning About Database Design

You will not become a professional database designer by reading the next three chapters. Instead, you will gain an overall understanding of how relational databases work, which you can call upon when faced with database design issues. The chapters should help you use Access more effectively, enable you to ask the right questions of database professionals, and allow you to design some simple databases on your own.

I take you through the steps of creating a relational database that has data on classic television series such as I Love Lucy and All in the Family. I chose a somewhat frivolous topic for two reasons. Unlike most areas in this book, database design is not a subject that lends itself as much to hands-on, ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.