Chapter 7. Creating Simple Queries

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.