en uk

Viewing and Printing a Report Microsoft Access 2007

    The first time you create a report, Access displays it on the screen right away. After you close a report, you can add, edit, or delete your data and then view your data through your report.

    To view a report, follow these steps:

    1. Click the downward-pointing arrow that appears in the left pane.

    A pull-down menu appears, as shown in Figure 18-8.

    Viewing and Printing a Report Microsoft Access 2007

    Figure 18-8:

    To view your saved

    Reports, click Tables

    And Related Views in the

    Left pane.

    2. Click Tables and Related Views.

    Access displays a list of all your previously saved reports in the left pane.

    3. Double-click a report name.

    Access displays your chosen report, displaying any new or edited data that you may have added since the last time you viewed the report.

    After you display a report onscreen, you can use the Print Preview command to see exactly how your report will appear when printed. Within Print Preview, you can also modify the appearance of your report, such as adjusting page margins or paper orientation.

    To preview and print a report, follow these steps:

    1. Make sure your desired report appears on the screen. (Follow Steps 1-3 of the preceding step list.)

    2. Click the Office Button.

    A pull-down menu appears.

    3. Click the right arrow that appears to the right of the Print command.

    A submenu appears, displaying the Print Preview command.

    4. Click Print Preview.

    Access displays the Print Preview tab, as shown in Figure 18-9.

    5. (Optional) Select one or more of the following:

    Size: Defines the paper size such as 8.5 x 11 or 8.5 x 14

    Portrait/Landscape: Makes the report print up and down or sideways on a page

    Margins: Lets you define page margins around your report

    6. Click the Print icon in the Print group to send the report to your printer.

    7. Click the Close Print Preview icon in the Close Preview group.

    Viewing and Printing a Report Microsoft Access 2007

    Figure 18-9:

    The Print Preview tab provides commands for modifying your printed report.

    Manipulating the Data in a Report

    After you create a report, you can manipulate the data displayed in that report, such as sorting data in ascending or descending order, or applying a filter that only displays data that meets a certain criteria.

    By using a report, you can get a different view of your data. By manipulating the data in a report, you can create alternate views of the same report. Some common ways to extract information from a report include




Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.