graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Add New Fields

rptMovieRentedSQ: Fields

4. Try it: Add Fields to the Query

Add the following Fields to the QBE Grid:

From tblMovieRented:

ReceiptID

DateRented

 

From tblMovies:

Movie

 

From tblRentalPrices:

Price

Description

 

Do This, Now: Save the Query

Go to File->Save.

Enter the name: rptMovieRentedSQ.

 

Keep going...

Query Tools ->Design