2007 Microsoft® Office System Inside Out

Chapter 28. Creating and Working with Simple Queries

Selecting Data from a Single Table

Testing Validation Rule Changes

Working in Query Datasheet View

In the last chapter, you learned how to create tables. Although you can certainly build forms and reports that get their data directly from your tables, most of the time you will want to sort or filter your data or display data from more than one table. For these tasks, you need queries.

When you define and run a select query, which selects information from the tables and queries in your database, Microsoft Office Access 2007 creates a recordset of the selected data. In most cases, you can work with a recordset in the same way that you work with a table: You can browse through it, select information ...