Creating a Select Query

This is the simplest of the types of query you can apply to your database.

1. Open your database in the usal way.

2. From the Database Window select the Queries tab and presss the New button.

3. From the Design View dialogue box select Design View

4. You must now add the database to which the query will be applied. You could use serveral databases. For this example only one database will be used. Having first Added your database. Press the Close button.

5. There are two methods you can use to add fields to your query:
a. Click in the field cell and a drop-down list box arrow appears. Select the field from the list.
b. Drag a field from the field box and drop it into the field cell.

In this example the drop-down field list method is used.

6. Having added all the fields to your query, add the criteria in the column below each field on which you want the selection to be made. If you want to use an "AND" function you simple use the word And in the Criteria cell. If you wanted to search for Fred and Ken you would type exactly that into the cell. The "OR" function is applied by entering the criteria in the "or:" cell at the bottom of the column.

7. Go to Query/Run on the Menu bar, or select the query icon from the Tool Bar.

7. The results of the query will appear. In this example, since one of the criteria was "OR Age > 25" all of the people in the database over 25 are listed as well as "Ken".

| Previous Page | Menu | Next Page | Home Page |