Add a Cover Sheet to Your Report

If you have a cover sheet saved as a Microsoft Word file, you can use it for your report. In the database window, on the Reports tab, click the name of the report, and then click Design. Select the Report Header section, and then click Insert Object (Insert menu). Click Create from File, click Browse, and then select the Word file that contains your cover sheet.

To print the cover on a separate page, double-click the section selector to the left of the Report Header section bar. In the property sheet, click All, click the ForceNewPage box, and then click the arrow. Select After Section from the list. To make the border of the cover disappear, click the Format tab, click in the BorderStyle property box, and then select Transparent from the list.

Guidelines for Formatting a Cover Sheet in Word

Before you import the cover sheet to Microsoft Access, you need to set page layout options in the document so that its size and orientation fall within the print area of your report. For example, suppose you want to set up your Microsoft Access report to print on 8.5-by-11-inch paper, portrait orientation, with one-inch margins on the top, bottom, left, and right sides.

In Microsoft Word, click Page Setup (File menu). On the Paper Size tab, click Portrait.

• Set the width to 6.5 inches, which is the width of your paper (8.5 inches) minus the sum of the left and right margins (2 inches).

• Set the height to 9 inches, which is the height of your paper (11 inches) minus the sum of the top and bottom margins (2 inches).

For more information on creating cover sheets or importing objects from Word, see Create Letterhead and Matching Envelopes.

Next Steps