||An alternate and
more efficient way to apply a filter is to use the filter by form
command. Clicking the filter by form
button will a screen on which the user can select criteria from a drop-down
menu for every field in the database.
This allows the user to apply multiple criteria simultaneously. The most useful advantage of filtering by
form is that the user can specify relationships within a given criterion
(i.e. books with a copyright year greater than 2000). Filtering by selection, on the other hand,
requires that the user specify criteria equal to an existing value. Another advantage of filtering by form is
that the user can specify alternative criterion (i.e. book titles with
copyright year of 2000 and book titles by author Johnson). This is done by clicking the “or” tab
located on the bottom of the screen.