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