O'Reilly logo

Microsoft® Access® 2010: Step by Step by Joan Lambert and Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required