Database Reference
In-Depth Information
In this exercise, you'll explore two existing queries.
SET UP
You need the GardenCompany01 database you worked with in the preceding
exercise to complete this exercise. If necessary, open the database, and then follow the
steps.
1
In the
Navigation
pane, display the
Queries
group, which includes all the queries that
have been saved as part of this database.
2
In the
Navigation
pane, right-click the
Delete Discontinued Products
query, and
then click
Object Properties
to display the properties of the query, including a
description of its purpose.
The icon at the top of the General tab indicates that this is a select query.
3
In the
Delete Discontinued Products Properties
dialog box, click
Cancel
.
Let's run a query.
4
Right-click the
Products By Category
query, and then click
Open
to run the query
and display its results in a datasheet. If necessary, close the
Navigation
pane so that
you can see all the results.