Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Multi-Table Queries

Create a New Select Query: rptOverdueSQ

A new Query will calculate the difference between the DateRented and the current date. Please create a new Select Query and add the following Tables.

 

1. Try it: Create a Query

Go to Create ->Queries ->Query Design.

You will be prompted by the Show Table.

 

Select a Table: tblMovieRented.

Click Add.

 

Select a Table: tblMovies.

Click Add.

 

Select a Table: tblRentalPrices.

Click Add.

 

Close the Show Table Window.

Keep going...

Create ->Queries->Query Design

graphic1
graphic2