Case 18-3 Anna, the manager of a general store, uses Microsoft Access 2016 to maintain product information. She uses multiple criteria to retrieve specific details about products. She combines two or more conditions to filter the records based on her requirement.
Anna types Like "a*" in the Criteria row in the ProductName column and 25 in the same Criteria row in the RetailPrice column. In this case, the query datasheet, created by Anna, will include the records for products with a ProductName field value that :
A)begins with "a" or a RetailPrice field value not equal to 25.
B)ends with "a" or a RetailPrice field value equal to 25.
C)ends with "a" and a RetailPrice field value not equal to 25.
D)begins with "a" and a RetailPrice field equal to 25.

Question

Quizplus · Accepted Answer

The criteria "Like 'a*'" filters for ProductName values that begin with "a", and "25" in the RetailPrice column specifies that the RetailPrice must be exactly 25. Both conditions must be met for a record to be included.

Case 18-3 Anna, the Manager of a General Store, Uses