Lesson 16: Running and Printing Database Reports
/en/access2003/running-database-queries/content/
Introduction
By the end of this lesson, you should be able to:
- Run Contact Management database reports
- Create a report using AutoReport
- Create a report using the Report Wizard
Running Contact Management reports
The Contact Management database contains two reports you can use to print a complete list of contacts in the database: Alphabetical Contact Listing report and Weekly Call Summary report, a call log to recap phone call summaries made between any two dates.
To run the Alphabetical Contact Listing report:
- On the Main Switchboard form, click once on the Preview Reports menu selection.
- On the Reports Switchboard, click once on the Preview the Alphabetical Contact Listing Report menu selection.
- The Alphabetical Contact Listing report is displayed.
The Contact Management reports can also be run in Datasheet view by selecting the Reports tab from the Objects palette of the database window. Then double-click on the Alphabetical Contact Listing report.
Running Contact Management reports
To run the Weekly Call Summary report:
- On the Main Switchboard form, click once on the Preview Reports menu selection.
- On the Reports Switchboard, click once on the Preview the Weekly Call Summary Report menu selection.
- In the Weekly Call Summary dialog box, type the date range in the Begin Call Date and Ending Call Date fields. This lets you search the database for calls made between two defined dates.
- The Weekly Call Summary report is displayed.
Creating a report using the Report Wizard
Another way to create reports in Access is to use the Report Wizard. The Report Wizard asks a series of questions you must answer. Access uses your responses to create the report.
To create a report using the Report Wizard:
- Open the database window and choose the Reports option from the Objects palette.
- Click the New button to open the New Reports dialog box.
- Click the Report Wizard selection.
- Click the drop-down list, and choose the table or query on which the report or query is based.
- Click the OK button to begin the Report Wizard.
Creating a report using the Report Wizard
In the Report Wizard's first dialog box:
- Choose the table or query in which you would like to base the report.
- Highlight the first field from the Available Fields that will be included in the report, and click the right arrow to move the field to the Selected Fields box.
- Repeat so each field is included in the report, or the click the double arrow to move all fields for the report.
- When finished, click the Next button.
In the Report Wizard's second dialog box, you can select a field name for grouping purposes. For example, by selecting First Name, notice how First Name becomes the group header (blue text) in the right side of the picture. You do not have to select any grouping levels.
- Highlight the field you would like to use as a group level, and click the right arrow to move the field to the Selected Fields box.
- When finished or to bypass this screen, click the Next button.
Creating a report using the Report Wizard
In the Report Wizard's third dialog box, you can specify how or if the reports are to be sorted on the report. For example, if you wanted to show names alphabetically and by state, you would first sort by State and then by Last Name.
- In the first field (optional), select a field name from the drop-down box only if records in the report are to be sorted by that field. Then click the button to define whether records are to be sorted in ascending or descending order.
- If necessary, repeat for each of the remaining three sort fields.
- When finished or to bypass this screen, click the Next button.
In the Report Wizard's fourth dialog box:
- Select one of the three listed Layout options: Columnar, Tabular, or Justified.
- Select an Orientation for the report: Portrait or Landscape.
- Select or deselect the Adjust the field width so all fields fit on a page field (this is optional).
- Click the Next button to continue.
Creating a report using the Report Wizard
In the Report Wizard's fifth dialog box:
- Click through the different format options displayed on the screen—Bold, Casual, Compact—to display a picture of each report format on the left side of the wizard screen. Highlight the desired format you would like to use.
- Click the Next button to continue.
In the Report Wizard's sixth dialog box:
- Assign a name to the report by typing a file name in the What title do you want for your report? field.
- Click the Finish button to complete the wizard and generate the report.
You can decide to include any or all of the Report Wizard's selections in your report.
Very important! When working in tables, forms, queries, and reports, use the New Object button on the toolbar to create new database objects (tables, forms, queries, and reports).
Challenge!
- Open the Contact Management database.
- Open the Contacts table in Datasheet view, and Print all records in the table.
- Open the Calls table in Datasheet view, and Print all records in the table.
- Open the Contact Types table in Datasheet view, and Print all records in the table.
- Open the Main Switchboard form.
- Run the Alphabetical Contact Listing report, then Print the completed report.
- Run the Weekly Call Summary report, then Print the completed report.
- Create a report using AutoReport.
- Create a columnar report against the Calls table.
- Print the completed report.
- Close the report, and click the "No" button in response to the Do you want to save changes to the design of report 'Report1' system prompt.
- Create a report using the Report Wizard.
- Select the Calls table.
- Select the following fields in the Calls table: Contact ID, Call Date, Subject, and Notes.
- Do not add any grouping levels.
- Do not define any sorting.
- Keep the Layout and Orientation default settings.
- Pick a Style of your choosing.
- Name the report "Job Search Progress".
- Print the completed report.
Print from the menu bar to open the Print dialog box.
