Microsoft Office Tutorials and References
In Depth Information
To Clear the Design Grid
If the fi 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 fi 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 fi rst column already
selected, clicking here while
holding SHIFT key down
selects all fi ve columns
clicking here selects
fi rst column
pressing DELETE
key with all
columns selected
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).
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 fi 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 fi eld is to be sorted. The steps
specify Ascending sort order.
Include the City fi eld
in the design grid.
City fi eld
Click the Sort row
below the City fi eld,
and then click the
Sort row arrow to
display a menu of
possible sort orders
(Figure 2–35).
Sort row
Sort row
sort order
menu of
sort orders
Figure 2–35
Search JabSto ::

Custom Search