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 ProductName field value of "Briston" or a RetailPrice value not equal to $10, Anna should enter:
A) "Briston" in the Criteria row in the ProductName column and 10 in a different Criteria row in the RetailPrice column.
B) in the Criteria row in the ProductName column and !={10} in the same Criteria row in the RetailPrice column.
C) "Briston" in the Criteria row in the ProductName column and {10} in the same Criteria row in the RetailPrice column.
D) in the Criteria row in the ProductName column and !=10 in a different Criteria row in the RetailPrice column.
Correct Answer:
Verified
Correct Answer:
Verified
Q36: Identify an accurate statement about deleting a
Q37: Which of the following statements is true
Q38: In Microsoft Access 2016, the _ divides
Q39: Which of the following is true of
Q40: In Microsoft Access 2016, the count function
Q42: In the accompanying figure of a Microsoft
Q43: Explain property sheets in Microsoft Access 2016.
Q44: In the accompanying figure of a Microsoft
Q45: In the accompanying figure of a Microsoft
Q46: Zoya, a manager, uses Microsoft Access