Printing Reports

Team-Fly    

 
10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 22.  Printing Access Objects

Printing Reports

As you learned earlier in this book, the Access report is the ideal format for presenting database information on the printed page. Using reports, you can add page numbering controls and other header or footer information that repeat on each page of the report.

Whether you create a report using AutoReport or the Report Wizard, the completed report appears in the Print Preview mode, as shown in Figure 22.1.

You can immediately send the report to the default printer by clicking the Print button on the Print Preview toolbar. If you find that you would like to change the margins on the report or change how the report is oriented on the page, click the Setup button on the Print Preview toolbar. The Page Setup dialog box appears (see Figure 22.2).

Figure 22.1. Reports created using AutoReport or the Report Wizard open in the Print Preview mode.

Figure 22.2. The Page Setup dialog box enables you to control the margins and page orientation of the printed report.

Three tabs are on the Page Setup dialog box:

  • Margins ?A NAME ="d1e28523">This tab enables you to set the top, bottom, left, and right margins. To change one of the default settings (1 inch), type the new setting in the appropriate margin box.

  • Page ?A NAME="d1e28554">This tab enables you to change the orientation of the report on the printed page. Portrait, which is the default setting, orients the report text from top to bottom on a regular 8 1/2-inch by 11-inch page. Landscape turns the page 180 degrees, making it an 11-inch by 8 1/2-inch page. Landscape orientation works well for reports that contain a large number of fields placed from left to right on the report. This tab also enables you to select the type of paper that you are going to use for the printout (such as letter, legal, and so on).

  • Columns ?A NAME="d1e28596">This tab enables you to change the number of columns in the report and the distance between the columns. Because the columns for the report are determined when you create the report using AutoReport or the Report Wizard, you probably won't want to tamper with the column settings. It's easier to change the distance between field controls in the Report Design view.

Tip

Use the Report Design View to Make Design Changes If you find that the report needs some major structural changes, click the View button to go to the Design view.


After you have finished making your choices in the Page Setup dialog box, click OK to close the dialog box. You can now print the report.


Team-Fly    
Top
 


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net