Office 2010 - Access

Lesson 58: Page by Group

58/76 Lessons 

Page by group

In “Access”, we have the opportunity to print each group in the “Report” on a separate page.

Open this “Report”, select “Layout View” or “Design View”, select the “Design” tab and click the “Properties Window” button.

Select the section, in this case the “Group Footer” in your “Report” to add a “Page break”.
In the “Properties window”, select “After Section” for the “Force New Page” option.

les58_image001_en
A second way is to select the “Group Header”, select “Before Section” in the “Force New Page” in the “Properties window”.

les58_image002_en
Whatever you choose does not matter. Click the “View” button in the “Ribbon” and select “Print Preview”. This is the result. Use the navigation buttons to navigate between different pages.

les58_image003_en

Hide Details

I can imagine that not everyone is interested in all details that are displayed in the “Reports”.
You can hide these details in “Layout View” or “Design View”. Select the “Design” tab and click the “Hide Details” button.

les58_image004_en
To display the details again , click the “Hide Details” button again.

Awesome!
You've completed Lesson 58
START NEXT LESSON