Chapter 3. Working with an Existing Query

IN THIS CHAPTER:

  • 9 Open a Query in Datasheet View

  • 10 Open a Query in Design View

  • 11 Add Fields to a Query

  • 12 Order a Query Result

  • 13 Refine a Query with Criteria

  • 14 Save a Query

  • 15 Print a Query Result

  • 16 Close a Query

A Select query is a stored question about the data stored in a database’s tables. Only the question is stored, not the resulting data. Select queries are the foundation of much of what you do in Access. They underlie most forms and reports, and they allow you to view the data you want, when you want.

Key Term

Key Term

Select query—A stored question about the data stored in a database’s tables.

You use a simple ...

Get Microsoft Office Access 2003 in a Snap now with O’Reilly online learning.

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