Add a title page to your Access report

by Mary Ann Richardson | May 31, 2005 8:45:00 PM

Tags: Microsoft Office, Mary Ann Richardson, title page, header, Properties, Microsoft Access, Microsoft Office Suite Access Tips Newsletter

Takeaway: The substance of your reports still takes precedence over the report's style, but all IT pros know that presentation definitely makes a difference. Find out how you can give your Microsoft Access report some pizzazz by adding a title page.

Microsoft Access reports automatically come with page headers and footers, but what if you want a title page at the beginning of your report? A title page for a report consists of the report header minus any page headers and footers.

For instance, let's say you want to add a title page to your Employees Report that consists of your company name and the name and date of the report. Here's how to add the title page:

1. Open the Employees Report in design view and add a report header by selecting View | Report Header/Footer from the Menu bar.
2. Design your title page by adding the appropriate controls for the information (or images) you want on the page to the Report Header section. Resize the Report Header section to the length of the page.
3. If the Report Properties Box is not visible, click the Properties button in the Report Design toolbar to activate it.
4. Select Report in the Report Properties drop-down list box.
5. Under the Format tab, click the Page Header property drop-down list and select Not With Rpt Hdr.
6. Click the Page Footer property drop-down list and select Not With Rpt Hdr.
7. Select Report Header in the Report Properties drop-down list.
8. Under the Format tab, select Force New Page from the drop-down list and select After Section.

You'll notice that adding a title page makes your report look a bit more polished.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.