Chapter 8. Create Your Own Relationships
IN THIS CHAPTER:
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 ...
Get Microsoft Office Access 2003 in a Snap 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.
