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: MovieRentedSQ

A new Query will calculate the total for each Receipt. So, Queries get their data from Tables. Please add them.

 

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

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