Microsoft Office Tutorials and References
In Depth Information
To Clear the Design Grid
If the ﬁ elds you want to include in the next query are different from those in the previous query, it is usually
simpler to start with a clear grid, that is, one with no ﬁ elds already in the design grid. You always can clear the entries
in the design grid by closing the query and then starting over. A simpler approach to clearing the entries is to select
all the entries and then press the DELETE key. The following steps return to Design view and clear the design grid.
• Return to Design view.
• Click just above the Client Number
column heading in the grid to
select the column.
I clicked above the column
heading, but the column is not
selected. What should I do?
You didn’t point to the correct
location. Be sure the mouse
pointer turns to a down-pointing
arrow and then click again.
with ﬁ rst column already
selected, clicking here while
holding SHIFT key down
selects all ﬁ ve columns
clicking here selects
ﬁ rst column
key with all
clears the grid
• Hold the SHIFT key down and click
just above the Recruiter Number
column heading to select all the
columns (Figure 2–34).
• Press the DELETE key to clear the design grid.
To Sort Data in a Query
If you have determined in the design process that a query is to be sorted, you must identify the sort key, that is,
the ﬁ eld on which the results are to be sorted. In creating the query, you will need to specify the sort key to Access.
The following steps sort the cities in the Client table by indicating that the City ﬁ eld is to be sorted. The steps
specify Ascending sort order.
• Include the City ﬁ eld
in the design grid.
City ﬁ eld
• Click the Sort row
below the City ﬁ eld,
and then click the
Sort row arrow to
display a menu of
possible sort orders