Chapter 7. Creating Simple Queries
Queries enable you to save specifications for sort/filter operations as reusable objects. They are the backbone of any data retrieval system and enable users to quickly pull the needed information from large tables.
In this chapter, you will learn how to create simple, effective queries that sort and filter the data from one or more tables.
Create a Query with the Simple Query Wizard
Start a New Query in Query Design View
Insert, Arrange, and Remove Query Fields
Set Field Sorting
Add an Alias to a Query Field
Filter a Query for a Specific Value
Specify a Range of Values