Access 2016 Intermediate

Lesson 3 – Using Operators in Queries

Access 2016

Using the Expression Builder

NOTE The Expression Builder is available in Design view for any database object. For example, use the Expression Builder to create a validation rule for a table field. Insert an element from an element pane into the Expression field by double-clicking the element or by selecting it and clicking the Paste button in the Expression Builder. Be careful to single-click when expanding a subcategory; double-clicking a subcategory inserts the first subcategory value.



Procedures

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

3. Click the Builder button on the Design tab. 4. Expand categories in the lower, left pane as necessary, and then click any category to display its subcategories in the center pane. 5. Click the desired subcategory in the center pane. 6. Double-click a subcategory in the center pane or a value in the right pane to insert it into the Expression field. 7. To enter a value, select existing text or position the insertion point as needed in the Expression field.

Page 62

OFFICEPRO, Inc.