Use Excel’s MS Query Wizard to query Access databases

There’s data in your company’s Access database that you need
to analyze, but the PC you work with does not have Access. No problem! You can
use Excel’s MS Query Wizard to come up with the answers you need. For example,
suppose you need a list of customers with outstanding balances, and the data is
in the Customer table of your Sales database. To get the customer list, follow
these steps:

1. Open
   a new blank Excel worksheet.
2. Go to
   Data | Import External Data | New Database query.
3. Under
   the Databases tab, select MS Access Database and click OK.
4. Under
   Database Name, select Sales and click OK.
5. Click
   the Customer table.
6. Click
   Customer No. and then click the right arrow box.
7. Click
   Name and then click the right arrow box.
8. Click
   Balance and then click the right arrow box.
9. Click
   Next.
10. Select
    Balance from the drop-down menu.
11. Select Is Greater Than from the drop-down menu.
12. Select 0 from the drop-down menu.
13. Click
    Next.
14. Under
    Sort By, select Customer No. and click Next.
15. Click
    the Save Query button, then click Next.
16. Click
    Finish.
17. Click
    Existing Worksheet, and then click OK.

The results of the query will be displayed in the blank,
open worksheet.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.