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 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.

Start your free trial