776 Chapter 25 Explore an Access 2010 Database
The Query Designer.Two boxes in the top pane of the Query Designer list the fields in the tables this
query is designed to work with. The line between the boxes indicates that before
the query was created, a relationship was established between the two tables
based on the fact that the CategoryID field is present in both of them. The rela-
tionship enables this query to draw information from both tables.
See Also For more information about relationships, see “Creating Relationships
Between Tables” in Chapter 26, “Create Databases and Simple Tables.”
The query is defined in the design grid in the bottom pane of the Query Designer.
Each column of the grid refers to one field from one of the tables above. Notice
that <> Yes (not equal to Yes) is entered 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).- As an experiment, in the Criteria row of the Discontinued field, replace <> with =.
Then on the Design contextual tab, in the Results group, click the Run button.
Tip You can also run a query by switching to Datasheet view.
This time, the query finds all the records that have been discontinued. The 18 dis-
continued products account for the difference between the number of records in
the Products table and the number of records displayed by the original query.