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.
To view your saved
Reports, click Tables
And Related Views in the
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.
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