Microsoft Office Tutorials and References
In Depth Information
Understanding Types of Queries
the datasheet. If data has been added, edited, or deleted, the query
datasheet may display different data.
To create a query, you use a wizard or Design view (or both) to tell Access
which data you want to see. The easiest way for a beginner to create a query
is to use the Simple Query Wizard, but after you understand queries, you
may prefer to go right to Design view.
We start this chapter by telling you about the different types of queries that
Access offers; then we introduce you to Design view. This chapter
concentrates on select queries, which are the most common type, and the skills you
use to create select queries. Next, we guide you through creating a query
with the Simple Query Wizard. The wizard provides some features that
are difficult for beginners to add in Design view, such as summary fields.
Because the Simple Query Wizard doesn’t allow you to define criteria (such
as limiting records to those ordered this month or viewing only products
that cost more than $20), you probably want to move quickly to the next
sections on using Design view and criteria. At the end of the chapter, you
find all the details on working with your query data in a datasheet. Use the
two views together to get the data you want.
If you want to send a query through Access to an SQL database, you need to
create a pass-through query. See Book IX, Chapter 2 for more information.
Understanding Types of Queries
The many types of queries that Access provides give you many ways to
select and view specific data in your database. You choose the type of
query, choose the fields you want to see, and define criteria to limit the data
shown as necessary.
These types of queries are available in Access:
Advanced Filter/Sort: The simplest kind of query, Advanced Filter/Sort
allows you to find and sort information from a single table in the
database. You can access this option in any datasheet by clicking Advanced
in the Sort & Filter group on the Home tab of the Ribbon and then
choosing Advanced Filter/Sort. Advanced Filter/Sort is covered Book II,
Chapter 3.
Select: A select query selects the data you want from one or more tables
and displays the data in the order in which you want it displayed. A
select query can include criteria that tell Access to filter records and
display only some of them. Select queries that display individual records
are detail queries; those that summarize records are totals or summary
queries (see the next item).
Search JabSto ::

Custom Search