MS Access 2007 - Lesson 8: Establish relationships between tables

TipsMake.com - The relationship between tables is the data link between tables. By defining table relationships , you can drag records from related tables based on relational fields.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 1

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.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 2
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.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 3
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

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 4

- Click on the Design tab

- Select Show Table

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 5

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.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 6

- Choose the school you want to create a relationship from

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

- Click OK.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 7

Print table relationships

- Click the Database Tools tab.

- Click on Relationships button.

- Click the Relationship Report button on the Design tab.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 8

- Click the Print button.

MS Access 2007 - Lesson 8: Establish relationships between tables Picture 9