O'Reilly logo

Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries by Paul McFedries

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

10. Creating a Basic Query

IN THIS CHAPTER

Sorting Records

Filtering Table Data

Working with Queries

Creating a Query

Querying Notes for Business Users

Case Study: Querying for a Mail Merge

Creating Queries with the Query Wizards

Working with a Query Dynaset

Working with Query Properties

From Here

If you have a large amount of data in a table, it’s not often that you’ll want or need to work directly with the raw data. Instead, you’ll usually work with data that has been massaged in one or both of the following ways:

  • The data has been sorted on one or more fields.
  • The data has been filtered to show only a relevant subset of the records.

The combination of sorting and filtering is at the heart of one of the most powerful concepts in all of ...

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