Joined Tables

2. What Do You See? The Relationships Window has opened. The Relationship Tools are available.


What Else Do You See? Our database has a pair of Tables that are joined by a common Key field: RentalPriceID.


The relationship, or join, is represented by the line from RentalPriceID in the Movie Table to RentalPriceID in the Rental Prices Table.


This relationship was created when we added tblRentalPrices as a Subdatasheet to tblMovies and linked the Parent and Child by RentalPriceID.


Microsoft Access noticed the matching Keys and prompted us to create a relationship between the two Tables.


Keep going...

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Edit the Relationships

Database Tools ->Relationships->Relationships