O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 7.2. Filter Selection Methods
MethodRecords, Filter MenuShortcut MenuToolbar Button
By SelectionYesYesYes
Excluding SelectionYesYesNo
Filter for InputNoYesNo
Filter by FormYesNoYes
Advanced Filter/SortYesNoNo
Excluding Selection and Advanced Filter/Sort buttons can be added to the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required