In Access, If You Want a Query to List the ProductID

question 5

Multiple Choice

In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid?

• A)ProductID, Description, Category
• B)Description, Category, ProductID
• C)Description, ProductID, Category
• D)ProductID, Category, Description

---

Definitions:

Reptiles

A class of cold-blooded vertebrates that include snakes, lizards, turtles, crocodilians, and various extinct groups, characterized by breathing air, laying shelled eggs, and having a skin covered with scales or scutes.

Urea

An organic compound and waste product produced in the liver, resulting from the metabolism of proteins, excreted in the urine.

Amphibians

A class of cold-blooded vertebrates that includes frogs, toads, salamanders, and newts, characterized by their ability to live both in water and on land.

Mammals

Warm-blooded vertebrates characterized by the presence of mammary glands, which females use to feed their young, and usually hair or fur on their bodies.