How to Create a Simple Query in Access 2003

In Access 2003, you can use a simple query to retrieve data from fields. A simple query can also calculate values such as average, minimum, maximum and sum. The wizard makes it easy.

Difficulty:

Moderate

Instructions

Things You'll Need

• Computer
• Access 2003

1. Choose "Query" from the "Objects" menu and click "New."

2. Click "Simple Query Wizard" and then "OK."

3. Choose the table with the fields you want to use from the drop-down menu of tables and queries.

4. Browse the list of available fields and queries from which to retrieve data. Select those you want to include and hit the ">" arrow to add them. Click the ">>" arrows to select all. Click "Next."

5. Title your query by typing a name in the field.

6. Choose "Open the query to view information," if you have finished and want to run the query.

7. Choose "Modify query design" to make changes.

8. Click "Finish."

Tips & Warnings

• To set criteria, open the query in design view and set up a filter.

• Alternately, open the wizard by double-clicking "Create query by wizard" after selecting the "Queries" button.

• If the wizard doesn't open, you may need to install Microsoft Jet 4.0 SP8 or a later version.