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
  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
  14. Under
    Sort By, select Customer No. and click Next.
  15. Click
    the Save Query button, then click Next.
  16. Click
  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.