Office 2007 - Access

Lesson 49: Page Breaks

49/72 Lessons 

“Report Header” and “Report Footer”

Another section of the “Report” is, the “Report header” and “Report footer”.
“Report Header” is displayed only at the top of the first page of the “Report”.
“Report Footer” is placed only on the last page of the “Report”.
To add a “Report Header” or “Report footer” to a “Report”, first open these sections.
Just click the “Report Header / Footer” button in the “Ribbon”, under the “Arrange” contextual tab.

This opens both sections in the “Report”. In this example I’m going to add a logo and a title to the “Report Header” section.
To add a logo, select the “Design” tab in the “Ribbon” and click the “Logo”. In the dialog that appears, navigate to the location on your computer where this logo is, select it and click the “OK” button.
The logo will be automatically added to the “Report Header” section.
You may adjust its size by clicking and dragging the corners of the image.
Then I add a title by clicking on the “Title”.
Type the title and click the “Font” button in the “Ribbon” to change the format.

In “Report Footer” section, you may also want to display something. I do not know what to display at this time, so I drag it to the edge of the “Page Footer” section.

Save the “Report” and see the result by clicking the “Report View” button in the “Ribbon”.

“Insert Page Break”

You can insert a “Page break” at any point in the “Report”, where a new page within a section needs to begin.   In this example I want each album to be displayed on its own page.
That aside:
The logo and title I have in the “Page Header” can also to be repeated on every page.
To do this, that is add the logo and a title, as you saw in the previous section of this lesson, drag them to the “Page Header” section.
Click on the “Report Header / Footer” toggle button to remove these sections.
OK, we go further by, first selecting the “Design” contextual tab and clicking the “Insert Page Break” button.
Click the location in the section, in this case the “Details” section, where you want to insert the “Page break”. The “Page break” appears as a short dotted line in your “Report”.

You can always move it by selecting it and dragging it.
In order to view the “Page break”, you should switch to “Print Preview” display.
Just click the downward-pointing arrow below the “View” button in the “Ribbon” and select “Print Preview”.
Use the navigation buttons to navigate between records.

Click the “Print Preview” button to return to “Design view”.
To remove a “Page break”, select it and click the “Delete” key on your keyboard.

Click the “Save” button in the “Quick Access” toolbar, to save your “Report”.
Do this regularly to avoid unnecessary frustration and believe me, I can testify to it.

 

Awesome!
You've completed Lesson 49
START NEXT LESSON