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.
Understanding Queries
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
Understanding Criteria
Filter a Query for a Specific Value
Specify a Range of Values
Specify ...
Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 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.
