Add More Tables

Documenting the Table Relationships is quite similar to creating a Query.

 

3. Try it: Add More Tables

Go to Relationship Tools ->Design.

Click on: Show Table

 

What Do You See? The Show Table window will prompt you to choose a Table or Query for the Record Source.

Select a Table: tblReceipt. Click Add.

Select a Table: tblMovieRented. Click Add.

Select a Table: tblCustomers. Click Add.

 

There will be Tables all over the page.

Click Close to close the Show Table window. Keep going...

Relationship Tools ->Design->Show Table

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Edit the Relationships