Chapter 6. Tapping the Power of Relationships

IN THIS CHAPTER

  • Learn how to add lookup fields to your tables

  • Run the Table Analyzer to get hints on making your design more efficient

  • Create and modify relationships between tables

  • Use referential integrity to protect your data

The average person might define the term relationship as a connection of blood or marriage. In the relational database world, the term relationship simply refers to an association between two records. That’s the good news—you don’t have to send your Access database flowers when you mess up. The bad news is that you might find Access relationships just as frustrating as your blood relations. An irate mother-in-law has nothing on an Access relationship run amuck.

The truth is that ...

Get Absolute Beginner’s Guide to Microsoft® Access 2002 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.