10. Creating a Basic Query
IN THIS CHAPTER
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
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 ...