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® Office Access 2003 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.
