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

question 41

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.

---

Definitions:

Macular Degeneration

A progressive eye condition affecting the macula (part of the retina) that leads to vision loss.

Macular Area

A small central portion of the retina, responsible for detailed central vision and high visual acuity.

Iris

The colored part of the eye that controls the size of the pupil and the amount of light that enters.

Sclera

The white outer layer of the eyeball, providing protection and giving the eye its shape.