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

Get Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.