Access 2016 Intermediate
Access 2016
Lesson 3 – Using Operators in Queries
E XERCISE
U SING O PERATORS IN Q UERIES
Task
Use operators in queries.
1. Open OPERATEX.ACCDB . 2. Open the Course Query query in Design view. 3. Set criteria to find only projects with a cost of more than $150. ( Hint: Try using the > operator.) 4. Run the query; the criteria should find 16 records. Then, return to Design view and delete the criterion. 5. Use wildcards and an Or condition to find only records with the text excel or word occurring anywhere in the course name. ( Hint: Use asterisks both before and after each criterion.) 6. Run the query; the criteria should find 7 records. Then, return to Design view and delete the criteria from the query. 7. Use the Expression Builder to find only records with a start date between 4/1/2012 and 6/30/2013 . ( Hint: Select Operators from the left pane, Comparison from the center pane, and Between from the right pane. Then, replace the
OFFICEPRO, Inc.
Page 67
Made with FlippingBook - professional solution for displaying marketing and sales documents online