Question

To limit query results to only records that meet all the criteria, how can you enter criteria for multiple fields on the Criteria row?

1) By entering criteria for multiple fields separated by the word 'And'
2) By entering criteria for multiple fields separated by the word 'Or'
3) By entering criteria for multiple fields separated by the word 'Not'
4) By entering criteria for multiple fields separated by the word 'All'

Answer 1

To limit query results to only records that meet all the criteria, you can use the 'AND' operator to enter criteria for multiple fields on the Criteria row.

Step-by-step explanation:

To limit query results to only records that meet all the criteria, you can enter criteria for multiple fields on the Criteria row by using the 'AND' operator. For example, if you want to find records that meet criteria for both the 'Name' and 'Age' fields, you can enter 'Name = John AND Age = 25'.