Microsoft Access 2007 reports provide tools for presenting and formatting data from a database. Often, reports in Access need to be multiple pages. When this occurs, it is useful to use the page break controls and grouping tools in Access to layout the report data.
- Skill level:
Other People Are Reading
Open the database file that includes the data to be reported in Access 2007.
Create a new report by selecting the report wizard from the Create menu or open an existing report.
Choose "Design View" from the View menu.
Format your report layout as desired and determine where you would like the pages to break in the report layout.
Select the "Controls" group from the Design tab and choose "Insert or Remove Page Break."
Select the section or text field In the property sheet where you would like to insert the page break. After adding the page break, Access creates a small line in the left margin of the report to indicate the break.
Insert Page Breaks Using Sections
Select the data in the report after which you would like to start a new page.
Select the "Group and Sort" option from the Design menu. A window apspear at the bottom of the screen with group and sort options.
Select "Add a Group" and choose the field that the page break should appear after. This group defines the page breaks and layout of the report.
Select the correct field from the group window at the bottom of the screen and choose the "More" option to open the group properties.
Insert a footer area to the group by selecting "Yes" in the Group Footer drop-down list. The group property inserts a footer area to the report directly after the grouped data. The group footer area provides options for controlling page breaks. Position your cursor in the newly created group footer area. Right-click and select "Properties."
Choose the property for Force New Page and select "After Section" to create a page break after the group footer.
Choose "Layout View" from the View menu to preview your report layout after setting your page breaks and formatting your text and data.
Insert Page Break Using Grouped Data
Tips and warnings
- Group headers can be used in place of the group footers in this article to achieve the same results. Instead of choosing a break "After Selection," use "Before Selection" if using a group header.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for