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.
Answer: D
You might also like to view...
Which statement is true regarding overloaded functions?
A. The functions must have different input parameter lists. B. The functions must have the same types and numbers of input parameters. C. Only the return values for the overloaded functions should be different. D. The overloaded functions can have different names
To display measurements on the ruler while changing column widths, hold down the ________ key while dragging the marker
A) Alt B) Ctrl C) Tab D) Shift
Which of the following is NOT a step that you would take when creating an ERD?
A) Identify the entities. B) Determine the functionality of the relationships. C) Identify the relationships. D) Identify the attributes.
In row order form, the ____.
A. first row is stored first B. first row is stored last C. first column is stored first D. first column is stored last