- Learning How to Create Reports
- The Asia Database
- Begin the Report by Creating a Query
- Beginning a Report in Design View
- Detail Section
- Page Header and Footer
- Using Concatenation
- Report Header and Footer
- Creating a Report Using the Report Wizard
- Comparing the From-Scratch and From-Wizard Reports
- Conclusion
- Case Example
This chapter is from the book
This chapter is from the book
This chapter is from the book
Case Example
As this chapter has demonstrated, report creation involves many techniques and methods. This case example exposes you to a few more by making some improvements to rptAdministation.
In the Database window, open rptAdministration in Design view. Choose File, Save As and save the report as rptAdminstrationCS.
Cover Pages
Report headers are commonly used to create cover pages, which tell readers what's in the report, who originated the information, who created the report, the date of the report, and so forth.
The current title of National Governments really doesn't do justice to the material within and certainly could stand some explanation. We could dump it entirely, but let's just add a subtitle below it, along with pertinent data about the report:
- Select the National Governments label and click after the letter s.
- Press Shift+Enter to move to the next line.
- Type Key Political Data and press Shift+Enter.
- Type CIA World Factbook. Press Shift+Enter.
- Type John Doe. Press Shift+Enter.
- Type January 1, 200X. Press Enter.
- Press F4 for the label's property sheet. On the Format tab, edit the Font Size to 12. Close the property sheet.
- Click View to see the report.
The title itself looks okay, but the data starts right after the last line of the title on the same page. Let's put things right.
- Click View to return to Design view. Right-click the Report Header bar and choose Properties.
- On the Format tab, edit the Force New Page property to After Section. This leaves the title by itself on the cover page.
- Edit the Height property to 6".
- Select the label in the header. Edit Top to 4". Close the property sheet. Figure 10.19 shows the label at the bottom of the report header section.
Figure 10.19 The report header section looks uncommonly long, but the extra space ensures that the report title will be on a separate page.
- Click View to see the report. Much better—now the only extraneous item remaining on the page is the page number at the bottom. You could edit the expression in the control in the page footer so that no page number would print on page 1. But it's a lot easier to simply delete the control and create a new one using the Page Number dialog box.
- Click View to return to Design view.
- In Page Footer, select the page number control and press delete.
- Choose Insert, Page Numbers.
- In the Page Number dialog box, select a format of Page N of M, a position of Bottom of Page, and an alignment of Right. Deselect Show Number on First Page. Click OK.
- Click View to see that there is no page number on the first page.
)
Separating Groups
If you don't mind lengthening your report somewhat, you can put the data for each group on separate pages. You use the same Force New Page property, except that the pertinent property sheet is that for the group header.
- Click View to return to design view.
- Right-click the GovtType Header bar and choose Properties.
- Edit the Force New Page property to Before Section.
- Click View to see the report. Review the Constitutional Monarchy group.
- Click View to return to Design view. The GovtType Header property sheet should still be open.
- On the Format tab, edit Repeat Section to Yes.
- Click View and scroll through your finished report (see Figure 10.20).
Figure 10.20 This is third and last page that has data about the group Constitutional Monarchy. The next group, Dictatorship, doesn't start until the following page.
- You can compare your report with rptAdministrationCS in AsiaChap10.mdb. When you're done, save your work. Close the report and the database.
)
For more information on Microsoft Office, visit our Microsoft Office Newsletter.