graphic2
graphic1

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

rptOverdueSQ: Fields

3. Try it: Add Fields to the Query

Add the following Fields to the QBE Grid:

 

From tblMovieRented:

ReceiptID

CustomerID

DateRented

 

From tblMovies:

Movie

 

From tblRentalPrices:

Price

Description

 

Do This, Now: Save the Query

Go to File->Save.

Enter the name: rptOverdueSQ.

 

Keep going...

Query Tools ->Design