graphic2
graphic1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.2 Set Report Controls: Group Data by Fields

Review the Grouping

In the Report Wizard, we selected one Grouping Level: Genre. Let's find that Group now.

 

Before You Begin: Change the View

Close the Print Preview.

When you close the Print Preview, the Report should be open in Design View, as shown on this page.

 

1. Try it: Review the Grouping Levels

The Report, Movies by Genre, is open in Design View and the Report Design Tools are available.


What Do You See? This Report has Sections:

Report Header: There is a label.

 

Page Header: The labels repeat on top of each page.

 

Genre Header: Only the Genre Field.

This is the One in the One-to-Many.

 

Detail: The Movie and Rating Records.

This is the Many in the One-to-Many.

 

Page Footer: The Date and Page Number repeat at the bottom of every page.

Home->View->Views->Design View