graphic2
graphic1

Exam 77-424: Microsoft Access 2013
1.0 Create and Manage a Database
1.2 Manage Relationships and Keys: Create and Modify Relationships

Join the Other Tables

9. Try it: Join the Other Tables

Drag the Keys to create the following Joins. For each link that is created the Edit Relationships window will prompt you to confirm that the Keys match. Click Enforce Referential Integrity and click Create.

 

From tblMovieRented to tblCustomer:

Link the CustomerID.

 

From tblMovieRented to tblMovies:

Link the MovieID.

 

Do This, Too: Close the Relationships

Go to Relationship Tools ->Design.

Go to Relationships->Close.

When you close the Relationships you will be asked to Save.

 

So....how are these Tables related, now?

Relationship Tools ->Design->Relationships->Close