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

Create a Relationship

What Do You See? When you link two Tables by a common Field Microsoft Access will look for a relationship. Are these two Tables related? Yes, we want to link the Movies to the Rental Price.

 

If Microsoft Access does not detect a relationship between the Fields, you will be asked if you like to create one.

 

3. Try This: Create a Relationship

Click Yes.

Keep going...

 

Home ->Records->More->Subdatasheet->Subdatasheet

graphic2
graphic1