To create a query with the Or logical operator in Microsoft Access 2016, _____.
A)all of the 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 OR 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 Or logical operator in Microsoft Access 2016, _____. ​
A)all of the 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 OR 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, to use the Or logical operator in a query, each condition that is part of the Or logic should be placed in a different Criteria row of the design grid. This allows the query to return records that meet any one of the specified conditions.

To Create a Query with the or Logical Operator in Microsoft