Create Table Relationships

Normalized databases use the Primary Key to create relationships between Tables. The relationship can be ad hoc, such as creating a Join between two Tables in a Query, or it can be explicit as part of the database definitions.


Microsoft Access defines relationships with the Database Tools.


1. Try it: Create the Table Relationships

Go to Database Tools ->Relationships.

Click on: Relationships.


Keep going...

Database Tools ->Relationships->Relationships

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Edit the Relationships