Microsoft Office Tutorials and References
In Depth Information
Using Query Design View
Working with tables in Design view
The tables in the Table pane (the top pane of the Design View window) are
really just little field-list windows that you can move and size the same way
you move and size windows. Change the size of a table window by moving
the mouse pointer to the border of the window; when the pointer turns into
a double-headed arrow, drag the border to change the size of the window.
To move a table in the Table pane, drag its title bar. This technique may
come in handy when you work with related tables and want a clear look at
the relationships among them.
If your query contains tables that have existing relationships that were
defined with lookup fields (or created in the Relationships window), you see
those relationships as lines between the related tables. (You can see more
about relationships in Book II, Chapter 6.)
Introducing the query design grid
The bottom pane of Design view is technically the Query by Example (QBE)
grid but is often simply called the query design grid. It’s your handy visual
aid for defining the data you want to select with your query. Each row in the
design grid has a specific purpose. Table 1-2 lists how to use them.
Rows in the Query Design Grid
What It Does
Displays the name of a field that you want to include in a query.
Displays the name of the table that the field comes from. (Hide or
display this row by clicking the Table Names button in the Show/
Hide group on the Design tab of the Ribbon.)
Performs calculations in your query. (This row isn’t always visible;
click the Totals button in the Show/Hide group on the Design tab of
the Ribbon to display or hide it.)
Determines the sort order of the datasheet produced by the query.
Shows or hides a field. (If you want to use a field to determine
which records to display on the datasheet but not actually display
the field, deselect the check box in the field’s Show column.)
Tells Access the criteria — such as records with values less than
10 or records with dates after 12/3/2005 — for the field in the same
Contains additional criteria.
Each of these query features gets detailed coverage later in this chapter.