Database Reference
In-Depth Information
For a query to work effectively with multiple tables, Access must understand the relation-
ships between the fields in those tables.
SEE ALSO
For more information about creating relationships, see “Defining relationships
between tables” in Chapter 2, “Create databases and simple tables.”
Regardless of whether you create a query by using a wizard or manually, what you create is
a statement describing the conditions that must be met for records to be matched in one or
more tables. When you run the query, the matching records appear in a new datasheet.
In this exercise, you'll use the Simple Query wizard to create a query that combines informa-
tion from two tables that are related through a common field. You'll then look at the under-
lying structure of the query, hide some fields, and sort the query results.
SET UP
You need the GardenCompany07 database located in the Chapter07 practice
file folder to complete this exercise. Be sure to use the practice database for this chapter
rather than continuing on with the database from an earlier chapter. Open the database,
and if you want, save your own version to avoid overwriting the original. Then follow the
steps.
1
On the
Create
tab, in the
Queries
group, click the
Query Wizard
button to open the
New Query
dialog box.
7
In this dialog box, you choose which of the four query wizards you want to use.
2
With
Simple Query Wizard
selected in the list, click
OK
to start the wizard.