O'Reilly logo

Microsoft Office Access 2003 in a Snap by Alison Balter

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 8. Create Your Own Relationships

IN THIS CHAPTER:

  • 45 About the Types of Relationships

  • 46 Establish Relationships

  • 47 Establish Referential Integrity

A relationship exists between two tables when one or more key fields from one table are matched to one or more key fields in another table. The fields in both tables usually have the same name, data type, and size. Relationships are a necessary by-product of the data normalization process. Data normalization, introduced in Chapter 7, “Design and Create Your Own Tables,” is the process of eliminating duplicate information from a system by splitting information into several tables, each containing a unique value (that is, a primary key). Although data normalization brings many benefits, it means ...

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