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|
|Filter for Input||No||Yes||No|
|Filter by Form||Yes||No||Yes|
|Excluding Selection and Advanced Filter/Sort buttons can be added to the ...|