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

Multiple Choice

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.
To retrieve details of all the products with a RetailPrice field value equal to $10 and an OfferPrice field value not equal to $8, Anna should enter:

A) ={10} in the Criteria row in the RetailPrice column and !={8} in the same Criteria row in the OfferPrice column.
B) 10 in the Criteria row in the RetailPrice column and 8 in a different Criteria row in the OfferPrice column.
C) ={10} in the Criteria row in the RetailPrice column and !={8} in a different Criteria row in the OfferPrice column.
D) 10 in the Criteria row in the RetailPrice column and 8 in the same Criteria row in the OfferPrice column.