Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Use the Show Table Options

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.

 

2. 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