Homework answers / question archive / 1) How does Access evaluate a criterion expression that just includes a criteria value? equal to not equal to equal to or greater than equal to or less than 2) How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch of a company who were hired after January 1, 2016? 1 3 6 9 3) Which of the following functions finds a specific number of characters from the left of the field? Left UCase iif Round

1) How does Access evaluate a criterion expression that just includes a criteria value? equal to not equal to equal to or greater than equal to or less than 2) How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch of a company who were hired after January 1, 2016? 1 3 6 9 3) Which of the following functions finds a specific number of characters from the left of the field? Left UCase iif Round

Business

Share With

1) How does Access evaluate a criterion expression that just includes a criteria value?

equal to

not equal to

equal to or greater than

equal to or less than

2) How many criteria would you need in a query in order to find all of the employees who work as insurance agents in the Cameron Park branch of a company who were hired after January 1, 2016?

1

3

6

9

3) Which of the following functions finds a specific number of characters from the left of the field?

Left

UCase

iif

Round