O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

Filtering Data

Filtering is for those times when you want to get many of the records out of the way so you can see the few that you're interested in. Filtering temporarily narrows down the number of records that appear, according to criteria you select.

Filters versus Queries

Queries also narrow down the records displayed, as you'll learn in Lesson 19. A filter is easier and quicker to use than a query, but a filter can't be saved as a separate object for later use. (However, you can save a filter as a query, as you'll learn later in this lesson.)

There are three ways to apply a filter: Filter by Selection, Filter by Form, and Advanced Filter/Sort. The first two are the most common for casual users, so we will cover them in the following ...

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