How to Create a Select Query in Access 2003

Select queries retrieve data from other fields and can sum, count or average values as well. Initiate a select query in Access 2003 using the wizard, or follow these steps to create one.

Things You'll Need

• Computer
• Access 2003

Instructions

1. Run the wizard. In the database window, click "Objects," and then "Queries." Click "New." Select "Simple Query Wizard" and click "OK."

2. Create a select query from scratch. Go to the database window.

3. Click "Queries," and then "Objects." Choose "New." The "New Query" dialog box will open.

4. Click "Design View." Click "OK." The "Show Table" dialog box will open.

5. Click on the tab of your table or query. Choose the one that contains the data you intend to use.

6. Add objects to the query by double-clicking the name of the object you want to add. Repeat this step until you've added all of your chosen objects. Click "Close."

7. In the design grid, add fields to the "Field" row. Specify the criteria and a sort order.

8. Click the "View" button on the toolbar to study your results.

Tips & Warnings

• If the wizard doesn't launch, you may need to install Microsoft Jet 4.0 SP8.

• A simple select query can find the minimum or maximum as well as the sum and average.

• You cannot set criteria on queries made with the wizard.