Creating Queries by Using a Wizard
There are two methods you can use to create queries. In this section you see
how to use the Query Wizard to build a query. Later in this chapter, I show
you how to start from scratch and create a query in Design view.
You can save yourself a lot of grief by creating a copy of your favorite Access
database and using the copy to practice creating and running queries. By
using the copy you can get as wild as you want in experimenting with differ-
ent types of queries without worrying about destroying any live data. You
might want to add something like
practice copy
to the filename of the
copied file just to be sure you don’t get confused.
Why you should be off to see the wizards
Access includes quite a broad range of wizards to help you with various
tasks. If you’re one of those macho users who thinks, “I don’t need any stink-
ing wizards," you’re welcome to skip over this section, but be forewarned —
even the experts sometimes find that the wizards can cut down on the
drudgery of common Access operations. Letting a wizard do some of the
work enables you to get more done with less effort (and fewer mistakes).
Some people always seem to have the answers right at their fingertips. Ask
one of those people how to do something that he or she is expert on and
you’ll instantly hear the whole process rattled off to you. Most of us, though,
have too many different interests to make it worth our time to become
experts on everything. That’s one reason why the Access query experts, or
wizards, are so useful. When you create a query with a wizard, the wizard
Figure 2-8:
You use a
delete query
to remove
records
from an
existing
table.
33
Chapter 2: Getting Started with Queries
06_599658 ch02.qxd 8/31/05 12:43 PM Page 33
|
|