Logical Operators
Which of the following is true about the AND logical operator (select all that apply)?
2 or more conditions must be met to return records in a query In Access, in the query design grid, all of the criteria is placed on the same line Using an AND logical operator will reduce the number of records returned in a query
Which of the following is true about the OR logical operator (select all that apply)?
In Access, in the query design grid, criteria is placed on different lines Using an OR logical operator will expand the number of records returned in a query At least one condition must be met to return records in a query
Which of the following are examples of Logical operators in Access (select all that apply)?
OR and AND