graphic2
graphic1

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

Review the Join

7. Try it: Review the Join

There should be a line between:

ReceiptID, the Primary Key in tblReceipt.

to ReceiptID, the Foreign Key in tblMovieRented.

 

Try This, Too: Edit the Join

The Join is more than just a line. It is a Relationship. Select the Join

Go to Relationship Tools ->Design->Tools.

Click on Edit Relationship.

 

The Edit Relationship Window will pop up.

Click on Join Type.

Keep going...

Relationship Tools ->Design