Introduction to Reports

Report Wizard

Create a report using Access' wizard by following these steps:

1. Choose the "Create report by using wizard" option in the Reports Database Window.
2. Select the source for the information the report will display by selecting a table or query from the Tables/Queries drop-down menu. Then, select the fields that should be displayed by moving them from the Available Fields list to the Selected Fields list. Click the Next > button.
3. Records can be grouped by fields. Click the right arrow button to add a field to the diagram. The Priority buttons change the order of the grouping if more than one field is selected. When the fields are in the order you want them to be in, click Next.
4. If the records are to be sorted, you can order them here. Select the first field from the drop down menu and click the A-Z sort button to choose ascending or descending order. Click Next >.
5. Select a layout and page orientation for the report. If you have many fields or one field that displays a long string of characters, you may want to change the page orientation to portrait. Click Next >.
6. Select a graphics style and click Next >.
7. Name the report and select whether to open it in Print Preview or Design View. Click the Finish button.

Printing Reports

Go to File > Page Setup to modify page margins, size, orientation, and setup. After all changes have been made, print the report by going to File > Print or click the Print button on the toolbar.