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 Relationship 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

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Define Join Properties