To create a query with the And logical operator i n Microsoft Access 2016, _____.
A)all conditions should be specified in the same Criteria row of the design grid
B)each condition should be specified in a different Criteria row of the design grid
C)the word AND should be specified in the Criteria row of the design grid
D)the && operator should be specified in the Criteria row of the design grid

Question

To create a query with the And logical operator i n Microsoft Access 2016, _____. ​
A)all conditions should be specified in the same Criteria row of the design grid
B)each condition should be specified in a different Criteria row of the design grid
C)the word AND should be specified in the Criteria row of the design grid
D)the && operator should be specified in the Criteria row of the design grid

Quizplus · Accepted Answer

In Microsoft Access 2016, when using the And logical operator to create a query, all conditions that need to be met simultaneously should be specified in the same Criteria row of the design grid. This ensures that only records meeting all specified conditions are returned in the query results.

To Create a Query with the and Logical Operator I