Access 2016 Intermediate

Lesson 3 – Using Operators in Queries

Access 2016



Procedures

1. Open the desired query in Design view. 2. Select the desired field’s Criteria row. 3. Type the desired criterion.

4. Type the And operator and an additional criterion in the same Criteria row and field, or type additional criteria in the same Criteria row of one or more other fields. 5. Press [Enter] .



Step-by-Step

Use an And condition in a query.

If necessary, open the CSales Query query in Design view and delete any previous criteria.

Steps

Practice Data

1. Select the Criteria row of the desired field.

Click in the Credit Limit field Criteria row.

The insertion point appears in the corresponding field’s Criteria row.

2. Type the desired criterion.

Type >=6000

The criterion appears in the design grid .

3. Type the And operator and an additional criterion in the same Criteria row and field, or type

Type and <=8000

additional criteria in the same Criteria row of one or more other fields. The additional criterion appears in the design grid .

4. Press [Enter] .

Press [Enter]

The And condition is added to the design grid.

Page 56

OFFICEPRO, Inc.