| Let's conclude this look at advanced Access features by looking at three properties that give you more control over how Access displays a report, particularly at the section level. Adding Page Breaks After Sections To make reports more readable, it's often a good idea to start a particular section (such as a grouping) on a new page. Rather than adding a Page Break control, you can force Access to add automatic page breaks by modifying a section's Force New Page property. Follow these steps: 1. | Open the report in Design view.
| 2. | Select the section you want to work with.
| 3. | Choose View, Properties to display the section's property sheet.
| 4. | Display the Format tab.
| 5. | Use the Force New Page list to choose one of the following values:
Before SectionChoose this option to force a page break before the section. This ensures that the section begins at the top of a new page.
After SectionChoose this option to force a page break after the section. This ensures that the next section begins at the top of a new page.
Before & AfterChoose this option to force page breaks before and after the section. This ensures that the section appears on a page by itself.
| 6. | Close the property sheet.
| 7. | Print preview the report to confirm that each section is formatted the way you want.
|
Starting Sections at the Top of a Row or Column You saw earlier that it's possible to configure a report to use multiple columns, where the fields are arranged down and then across (in columns) or across and then down (in rows). It's possible to force Access to start a section at the beginning of a column or row by modifying the section's New Row or Col property. Follow these steps: 1. | Open the report in Design view.
| 2. | Select the section you want to work with.
| 3. | Choose View, Properties to display the section's property sheet.
| 4. | Display the Format tab.
| 5. | Use the New Row or Col list to choose one of the following values:
Before SectionChoose this option to force the section to begin at the top of a new row or column.
After SectionChoose this option to force the next section to begin at the top of a new row or column.
Before & AfterChoose this option to force the section to appear in a new row or column by itself.
| 6. | Close the property sheet.
| 7. | Print preview the report to confirm that each section is formatted the way you want.
|
Avoiding Widowed Records A widow is a control or field that appears at the top of a new page by itself. In most cases, the report is more readable if you avoid widows and force all the elements of a section to appear together on the page. You can do this by modifying the section's Keep Together property, as shown in the following steps: 1. | Open the report in Design view.
| 2. | Select the section you want to work with.
| 3. | Choose View, Properties to display the section's property sheet.
| 4. | Display the Format tab.
| 5. | In the Keep Together property, choose Yes.
| 6. | Close the property sheet.
| 7. | Print preview the report to verify that each section is formatted the way you want.
|
From Here To learn how to export Access data to Excel for analysis, see the section titled "Analyzing Access Data in Excel" in Chapter 6. To learn how to export Access data to Word for publishing within a document, see the section titled "Publishing Access Data in Word" in Chapter 6. To learn how to export Access data to Word for a mail merge, see the section titled "Merging Data from Access, Excel, and Outlook" in Chapter 6. To learn how to import a Word table to Access, see the section titled "Exporting a Word Table to Access" in Chapter 6. To learn how to create Access macros, see Chapter 13, "Taking Advantage of Access Macros." For information on database security, see the section titled "Protecting Access Data with Passwords and Permissions" in Chapter 14.
|
