Page per group

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

Open this “Report” and select “Layout View” or “Design View”.

Choose “Layout View”, then select the “Arrange” tab and click the “Property Sheet” button.
If you choose “Design View”, then select the “Design” tab and click the “Property Sheet” button.

Select the box, in this case the “Group Footer” in your “Report” and if you want, you can add a “Page break”.
In the “Properties window”, select “After Section” in the “Force New Page”.

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

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.

“Hide Details”

I can imagine that not everyone is interested in all details that are displayed in the “Reports”.
For example, the Minister of Education, wants to know how much the school spends annually on wages, per subject.
But the indivdual salaries do not interest him.
So we need not bother him with all these ‘details’.

You can hide these details in “Layout View” or “Design View”.
Choose “Layout View”, then select the “Format” tab and click on “Hide details”.
If you choose “Design View”, then select the “Design” tab and click that same button.

The form is displayed in more compact form:

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

When you get the details again, it shows the totals above the groups.
You can change this by clicking on the “Grouping and Sorting” button in the “Ribbon” and select the fourth option “With total wages” in the “Show in group footer”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats