Filters
You filter a table, form, or query by applying criteria to view a selection of data or, more formally, a subset of the records. There are several filtering methods, including Filter by Selection, Filter Excluding Selection, Filter For Input, Filter by Form, and Advanced Filter/Sort. Different filtering tools can be accessed from either the Filter submenu on the Records menu, the (right-click) shortcut menu, or the toolbar. Table 7.2 summarizes these options.
| Method | Records, Filter Menu | Shortcut Menu | Toolbar Button |
|---|---|---|---|
| By Selection | Yes | Yes | Yes |
| Excluding Selection | Yes | Yes | No |
| Filter for Input | No | Yes | No |
| Filter by Form | Yes | No | Yes |
| Advanced Filter/Sort | Yes | No | No |
| Excluding Selection and Advanced Filter/Sort buttons can be added to the ... | |||
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
