Microsoft® Office System Step by Step -- 2003 Edition

Chapter 11 Locating Specific Information

Chapter 12 To filter a table by selection

1. Open the table in Datasheet view.

2. Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.

Chapter 12 To remove a filter

• Click the Remove Filter button.

Chapter 12 To exclude a field from a filter process

• Right-click the field you want to exclude, and click Filter Excluding Selection on the shortcut menu.

Using Data Type Settings to Restrict Data To filter by form in a form

1. Open the table or form you want to work with ...