Chapter 8. Create Queries

Chapter at a Glance

Create Queries

In this chapter, you will learn how to

Create queries by using a wizard.

Create queries manually.

Use queries to summarize data.

Use queries to perform calculations.

Use queries to update records.

Use queries to delete records.

Microsoft Access 2010 provides a variety of tools you can use to locate specific items of information. In addition to sorting and filtering tables and forms, with a little more effort, you can create queries. There are two basic types of queries:

  • Select queries. These find records in the database that match the criteria you specify and then display those records in a datasheet, ...

Get Microsoft® Access® 2010: Step by Step 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.