O'Reilly logo

Absolute Beginner’s Guide to Microsoft® Access 2002 by Mike Gunderloy, Susan Sales Harkins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required