When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.
A) AND
B) OR
C) NOT
D) BETWEEN

Question

Quizplus · Accepted Answer

When multiple criteria must be met, we use the AND logical operator. This means that all criteria specified must be true for the record to be included in the results. The OR logical operator is used when either one or both criteria need to be true for the record to be included. NOT is used when we want to exclude records that meet a particular criteria, and BETWEEN is used to select records within a range of values.

When You Want to Specify Multiple Criteria,and All Criteria Must