Page 62 - Computer Class 08

7. Double-click on the field names in the field list window which you would like to include

in the query.

Defining Criteria in the Query

In order to control which records are displayed, you must define criteria in a query. The most
common type of query is the Select Records query which will be discussed below.
Let’s
Let’s Learn...
Learn...
To define criteria for your query.

1. Position your cursor in the criteria row in the field for which you wish to define the
criteria for.

2. Type the criteria.
Example: To find all Excel courses:

3. Position your cursor in the criteria row of the Course ID field .
4. Type Excel (Access adds the quote marks to the criteria automatically when you tab to

the next column).

5. Click the Run Query button.

Saving the Query

Let’s Learn... 1
Let’s
Learn...

To save the query.

1. Click the Save icon.
2. Enter a name for the query.

3. Click OK . 3

Computer-8 62