Access 2007
Building Table Relationships
Introduction
By now, you have set up the tables you need for your database and created fields for those different tables. Relationships provide Access 2007 with the means to bring that information together for you when you need it.
This lesson explains how to establish relationships between the tables in an Access 2007 database. You will learn how to read and manipulate the relationship map. You will also learn about primary and foreign keys, relationship types, and referential integrity.