Core Concepts of Accounting Information Systems 12th Edition by Carolyn Strand Norman, Mark Simkin

Exercise 22

To construct a select query in Microsoft Access in which you want to satisfy two conditions simultaneously-that is, implement an And operation-you should:
A) Specify both criteria in separate fields of the Criteria line of the query
B) Specify both criteria in the same field of the Criteria line of the query
C) Specify each criterion in separate fields and in separate Criteria lines of the query
D) Give up; this is not possible in Microsoft Access