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 expressions with the appropriate dates.) 8. Run the query; the criteria should find 24 records. Then, switch back to Design view and delete the criteria. 9. Find all records with trainer initials of DF and a cost of $175 or more. The criteria should find 3 records. 10. Close the query, saving the changes. 11. Close the database file.

OFFICEPRO, Inc.

Page 67