How to Create a Select Query in Microsoft Access

You can retrieve and display specific database records by creating a select query in Microsoft Access. For example, you could create a query to display the names and e-mail addresses from your Address table. These instructions apply to Access 97.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access

1. Open the Database window.

2. Click on the Queries tab. Click New. A New Query window opens.

3. Click Design View, then click OK. The Show Table dialog box appears.

4. Click on the tab that lists the data you want to use. You can choose from tables, queries or both.

5. Double-click the names of the objects you want to add to the query. In the example given in the summary, it would be the Address table. Click Close when you are finished.

6. Add the fields that you want to use by dragging them from the field list into the design grid. In the example, it would be Name and E-mail.

7. Name and save the query by clicking Save on the toolbar and then entering a name for the query.

8. To view the query, click View on the toolbar. A datasheet opens containing the fields that you have specified.

Tips & Warnings

• You can refine your query by including a sort order, setting criteria, creating calculated fields or in various other ways.
• You can also use a wizard to create a select query. The wizard asks you questions about what you want to do, then creates the query for you. To use the wizard, click that option in the New Query window.
• If you are using more than one table, the tables must be connected by a join line to show Microsoft Access how the information is related. (See Related eHows on database relationships and primary keys.)

[Mughal]

on 12/12/2006 i think this site was usefull however it would have been better if screen shots of the process were included