Microsoft Office Tutorials and References
In Depth Information
Query an
ACCESS DATABASE
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
by town.
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
page appears.
%
Click here and select the column
by which you want to sort your
data.
^
^
Click Ascending or Descending
to choose a sort order
(
%
changes to
).
Optionally, you can add
additional sort criteria.
l
&
Click Next.
&
The Query Wizard — Finish page
appears.
*
Click Return Data to Microsoft
Office Excel.
Click View Data or Edit Query in
Microsoft Query and then Finish
for a graphical view of the
underlying data tables.
l
*
Click here to save your query.
l
(
Click Finish.
(
210
 
Search JabSto ::




Custom Search