MS Access 2007 - Lesson 8: Establish Relationships Between Tables

Understanding Microsoft access 2007 requires more than a headline. The overview below breaks down the key facts, changes, and user impact.

Microsoft Access 2007 Overview

One-to-one relationship

One-to-one relations are relations between two tables that are set when the relational field is both the primary key on both tables. Each record in Table A can only have one matching record in Table B.

One-to-one relationship

One-to-many relationship

One-to-many relationship is the relationship between two tables that the primary key in a table can be copied multiple times in another table or it can be understood that a record in table A can only have multiple records matching in table B, but a record in Table B has only one matching record in Table A.

One-to-many relationship

Create a table relationship

To create relationships between tables:

- Click on the Database Tools tab on the Ribbon

- Select Relationships button

- Click on the Design tab

- Select Show Table

Select the tables you want to create relationships with

- Click the Add button to add tables

- Click the Close button to turn off the Show Table window.

- Choose the school you want to create a relationship from

- Drag a merge field with the relational field in another table

- Click OK.

Print table relationships

- Click the Database Tools tab.

- Click on Relationships button.

- Click the Relationship Report button on the Design tab.

- Click the Print button.