Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

Create a Report

Try it: Create a Report

Go to Create->Report Wizard.

Query: rptCustomerReceiptSQ

Select these available fields:

ReceiptID

Last Name

Name

Movie

DateRented

Description

Price

 

Group by: Last Name

Then by: Name

 

Sort by: Movie

 

Report Layout: Portrait.

Report Title: Current Rentals.

Create ->Report Wizard
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.6. Create reports   2.6.2. Create reports using the Report Wizard