Question

For each data type, what are the rules related to entering specific criterion values?

Answer 1

Answer: / Explanation:

The rules includes:

1, Open the desired query in Design view.

2, Select the cell on the Criteria row below the field that contains the first condition you want to enter.

3, Type the first criterion you want to enter. For example, you can type Sales Manager as the criterion for Contact Title.

4, Select the cell on the Criteria row below the field that contains the second condition you want to apply.

5, Type the second criterion you want to apply

6, Click the Run button to run the query. Only rows that meet both conditions appear in the query result.