Database Reference
In-Depth Information
TIP
When a query is open, you can also simply switch to Datasheet view to run the query.
CLEAN UP
Close the Customer Orders query, saving your changes. Keep the
GardenCompany07 database open for use in later exercises.
Creating queries manually
The query wizards guide you through the creation of common queries, but you create less
common queries manually in the Query Designer.
7
This query was created manually in the Query Designer.
Let's review the features of the Query Designer:
▪
In the top pane are field lists for the tables that can be included in the query.
▪
Lines connecting the field lists indicate that the tables are related by common fields.
▪
A table's primary key field is indicated in its field list by a key icon.
▪
The Field row of the design grid contains the names of the fields actually included in
the query.
▪
The Table row shows which table each field belongs to.
▪
The Sort row indicates which field(s) the query results will be sorted on, if any.
