O'Reilly logo

Sams Teach Yourself Microsoft® Office 2003 in 24 Hours by Greg Perry

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

Chapter 19. Retrieving Your Data

Although your database contains a lot of data, you rarely want to see all that data simultaneously. Generally, you want to see only data subsets. Access filters and queries produce small, meaningful subsets of data from your tables.

When you view data subsets, you prevent unwanted data from getting in the way of the information with which you need to work. The power of queries is that you can select records and fields from multiple tables and view that selected data subset from within a single Datasheet or Form view.

The highlights of this hour include the following:

  • What a filter is

  • Why you sometimes use Filter by Selection and sometimes use Filter by Form

  • When a filter limits you

  • Why queries are more robust than filters ...

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