Office 2007 - Access

Lesson 48: Report Headers and Footers

48/72 Lessons 

“Page headers” and “Page footers”

First and foremost, if these sections are not visible in your form, click the “Page Header / Footer” button in the “Ribbon”. You can find this button under the “Arrange” tab.
The “Page Header / Footer” is a toggle button. If you do not know what a toggle button is, its a button that when you click once these sections are visible and when you click again, these sections disappear.


The “Page Headers” and “Page Footers” appear on every page of your “Report”.
An example for the use of “Page Headers” are the labels of the different fields in the report.
An example for the use of “Page Footer”, are the page numbers.
There is also a trick to place the labels of all the fields automatically in the “Page Header”.
1. Select all the fields you’ve added in the “Report”.
2. Click the ” Tabular” button in the “Ribbon” under the “Arrange” contextual tab.


When the labels and only the labels, need some formatting, select the labels in the “Page Header” section, click the “Font” button under the “Design” contextual tab and choose such as “Bold” and “Underline”.

To add “Page numbers” to the “Page Footer” section, select the “Design” tab in the “Ribbon” and click the “Insert page number” button.
This opens a dialog box where you can set the format, position, and alignment.
Click OK when this happens.
A text box will display the “Page numbers” added to the “Page Footer” section.
Place the mouse pointer over the edge of the “Details” section to adjust the white space between each record. Click and drag until you’ve reached the desired space.


Click the “Report View” button in the “Ribbon”.
Result:

Awesome!
You've completed Lesson 48
START NEXT LESSON