grpahic2
graphic1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.1 Create a Report: Create New Reports

The Overdue Letter

Let's walk through the Report Wizard to create the Overdue Letter. We will use rptOverdueSQ as the Record Source.

 

1. Try it: Use the Report Wizard

Go to Create ->Reports->Report Wizard.

 

Select a Record Source: rptOverdueSQ.

Select these available Fields:

FullName

Address1

CityStateZip

Movie

Description

DateRented

DaysRented

Rental

 

View the Report By: tblCustomers.

Group By: DateRented.

Sort By: Movie.

Orientation: Portrait.

 

Save this Report as rptOverdue.

Create ->Reports->Report Wizard