Access 2016 Intermediate

Access 2016

Lesson 3 – Using Operators in Queries

8. Type the desired value. 9. Complete the expression.

10. Select

.



Step-by-Step

Use the Expression Builder.

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

Steps

Practice Data

1. Select the desired field’s Criteria row. The insertion point appears in the corresponding Criteria row. 2. Click the Builder button on the Design tab. The Expression Builder opens. 3. Expand categories in the lower, left pane as necessary, and then click any category to display its subcategories in the center pane. The corresponding subcategories appear in the center pane. 4. Click the desired subcategory in the center pane. The corresponding values appear in the right pane. 5. Double-click a subcategory in the center pane or a value in the right pane to insert it into the Expression field. The element appears in the Expression field.

Click in the Contract Date field Criteria row

Click

Click Operators

Click Comparison

Double-click Between in the right pane

OFFICEPRO, Inc.

Page 63