O'Reilly logo

Easy Microsoft® Office Access 2003 by Shelley O'Hara

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 6. Creating Queries

Often, you don't want to work with all the data in a database; just a subset or group of specific records. For instance, you might want to view all your customers in South Carolina. Or you might want to view all products with a low inventory. For this purpose, Access enables you to create a query. Using a query, you can instruct Access to select and display a set of records from a table that match the criteria you enter.

You base a simple query on a single table, and that query pulls data from the table. You can also build more sophisticated queries that pull data from multiple tables. (This topic is not covered in this book.)

The simplest way to get started building a query is using a wizard, but you can also build a ...

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