Database Reference
In-Depth Information
The two boxes in the top pane of the Query Designer list the fields in the Categories
and Products tables. The line between the boxes indicates a relationship based on
their common CategoryID field. The design grid in the bottom pane defines a query
that matches information from both tables. Because <> Yes (not equal to Yes) is en-
tered in the Criteria row for the Discontinued field, this query finds all the records
that don't have a value of Yes in that field (in other words, all the records that have
not been discontinued) and displays them by category.
As an experiment, let's make a small change to the query design.
6
In the
Criteria
row of the
Discontinued
field, replace
<>
with
=
. Then on the
Design
tool tab, in the
Results
group, click the
Run
button to find all the records that have
been discontinued.
The 18 discontinued products account for the difference between the number of records in the
Products table and the number of records displayed by the original query.
TIP
You can also run a query by switching to Datasheet view.
7
Close the
Products By Category
query. When a message asks whether you want to
save your changes to the query, click
No
.
CLEAN UP
Keep the GardenCompany01 database open for use in later exercises.