Access 2016 Intermediate

Access 2016

Lesson 3 – Using Operators in Queries

Adding criteria to a query

NOTE Access automatically inserts number symbols ( # ) around date values and quotation marks ( " " ) around alphanumeric values. Access does not insert any symbols or characters around numeric values. Use the Expression Builder to add criteria to a query. To open the Expression Builder, select the Criteria row in the field where you want to add criteria then, on the Ribbon in the Design tab Query Setup group click the Builder button.



Procedures

1. Open the desired query in Design view. 2. Select the Criteria row in the field to which you want to add criteria. 3. Type the desired comparison operator and value. 4. Press [Enter] .



Step-by-Step

From the Student Data directory, open OPERATE.ACCDB . Use comparison operators in a query.

OFFICEPRO, Inc.

Page 53