Access 2016 Intermediate

Access 2010

Lesson 12 – Using Advanced Report Design



Step-by-Step

From the Student Data directory, open ADVREP.ACCDB . Add report sections in Design view.

Open the Items report in Design view.

Steps

Practice Data

1. Right click in a blank area of the Detail section of the report. The Report submenu appears.

Right click in a blank area of the Detail section.

2. Select the Page Header/Footer or Report Header/Footer button.

Click

or

The Page Header and Page Footer or the Report Header and Report Footer sections appear.

If necessary, select the Design tab and add a label to the left side of the report header. Enter the text Order Entry Report . Preview the report. Notice the report header at the top of the page. Switch back to Design view.

Practice the Concept: Right click to add a page header and footer to the report. Add a label to the center of the page header. Enter the text Worldwide Sporting Goods .

Preview the report and change to a 2-page view. Notice that the report header only appears on the first page, but the page header appears at the top of each page. Switch to Design view.

Close the report without saving the changes.

C REATING A C ALCULATED C ONTROL



Discussion

Add a calculated control to a form or report. A calculated control is not bound to a field. It contains an expression that uses information from fields to calculate a result. The result is not stored in a table. It is calculated when the report or form is run.

OFFICEPRO, Inc.

Page 223