Microsoft Office Tutorials and References
In Depth Information
With the Query Wizard, you can also create sorts
within sorts. For example, you can alphabetize a
list of states, counties, and towns as follows: first
in alphabetical order by state, then in alphabetical
order by county, and finally in alphabetical order
After importing the data into Excel, you can use
Excel’s tools to further sort and filter. You can go
beyond the wizard and directly manipulate the
Access tables from which your query is drawn.
On the final page of the wizard, click View Data or
Edit Query in Microsoft Query and then click Finish
for a graphical view of the underlying data tables.
You can work directly with criteria fields, add tables,
and connect tables by shared fields. You can also
run and view queries.
When you finish creating your query, you can save
your query. Saved queries become available in Excel
for viewing, analysis, charting, and so on. To learn
how to run a saved query, see Task #91.
The Query Wizard — Sort Order
Click here and select the column
by which you want to sort your
Click Ascending or Descending
to choose a sort order
Optionally, you can add
additional sort criteria.
The Query Wizard — Finish page
Click Return Data to Microsoft
Click View Data or Edit Query in
Microsoft Query and then Finish
for a graphical view of the
underlying data tables.
Click here to save your query.