Skip to Main Content
Ten Minute Guide to Access 97
book

Ten Minute Guide to Access 97

by Faithe Wempen
December 1996
Intermediate to advanced content levelIntermediate to advanced
224 pages
4h 56m
English
Que
Content preview from Ten Minute Guide to Access 97

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 for Starters: The Missing Manual

Access 2003 for Starters: The Missing Manual

Kate J. Chase, Scott Palmer

Publisher Resources

ISBN: 0789710226Purchase book