graphic2
graphic1

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

Create a Select Query:

rptMovieRentedSQ

Queries look up the Key and return the data: This new Query will list the movies for each Receipt.

 

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