Edit the Layout

4. Try it: Edit the Layout

Reading from Left to Right, please move the Tables as show in this screen shot.

 

First Row:

tblReceipt

tblMovieRented

tblCustomers

 

Second Row:

tblMovies

tblRentalPrices

 
What is the Goal? The Tables are placed this way to group the Tables by function and create explicit links between them.

 

Keep going...

Relationship Tools ->Design

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Edit the Relationships