How to Access 2003 Interactive Reports

Make your Access reports interactive.

Creating a report in Access 2003 allows users to instantly see the information contained in the database, without the need to search the tables or execute complex queries. When creating custom reports in Access 2003, database administrators can make it even easier for users to find just the information they need. By creating an interactive report that requests input from the user, database administrators can help ensure that everyone who opens the database will find just the information they need.

Instructions

1. Log on to your computer and open Microsoft Access 2003. Open the database you want to work with.

2. Click the "Queries" section and use the design view option to create your query. Double-click each table you want to include in the table, then click "Close." Double-click each field you want to include in the query.

3. Go to the criteria section for the field you want to use for your interactive report. Type "[Enter selection]" or a similar prompt. Click the "Save" button on the toolbar to save your query.

4. Go to the "Reports" section and choose the wizard option. Use the drop-down box at the top of the window to select the query you just created.

5. Double-click the fields you wish to include in the report, then click "Next." Click "Finish" and type a name for your report.

6. Double-click the report and enter your criteria to test it. The report is now ready for production, and each user who opens it will be prompted to enter his criteria.

References

• Microsoft Office: Examples of Query Criteria