Understanding Queries


10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 17.  Creating a Simple Query

Understanding Queries

As you learned in the previous lesson, Access offers many ways to help you narrow down the information you're looking at, including sorting and filtering. The most flexible way to sort and filter data, however, is using a query.

A query is a question that you pose to a database table or tables. For example, you might want to know which of your customers live in a specific state or how many of your salespeople have reached a particular sales goal. The great thing about queries is that you can save queries and use them to create tables, delete records, or copy records to another table.

Queries enable you to specify

  • The table fields that appear in the query

  • The order of the fields in the query

  • Filter and sort criteria for each field in the query

Plain English

Query A query enables you to "question" your database using different criteria that can sort, filter, and summarize table data.

Queries are a powerful tool for analyzing and summarizing database information. In this lesson, you take a look at the queries you can create using a wizard. Creating queries in the Design view is covered in Lesson 18, "Creating Queries from Scratch."


10 Minute Guide to Microsoft Access 2002
10 Minute Guide to Microsoft Access 2002
ISBN: 0789726319
EAN: 2147483647
Year: 2000
Pages: 160
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net