How to Create a Form or Report From Filtered Records in Access 2003

Once you create a form or datasheet with some data, you may filter it by using the filter option in Microsoft Access 2003. You can then create a Microsoft Access form or report from these filtered records. For example, you might filter all records of a particular recording artist in your CD collection, and print a report based on those records only.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access 2003
• Computer

1. Open Microsoft Access 2003 on your computer, by clicking on the Access icon on your desktop or accessing the program through your Start menu.

2. Select the filtered records that you wish to work from.

3. Click the little arrow on the right of the New Object button located on the toolbar. A menu of objects will appear.

4. Click AutoForm or AutoReport.

5. Click either Form or Report, depending on which one you want to make.

6. Make any changes you want to the design.

7. Save your form or report by either pressing Ctrl + S or selecting the Save command under the File menu.

Tips & Warnings

• The new form or report uses the table or query used when you created the filter. In other words, the filter is inherited.