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

Question

Quizplus · Accepted Answer

The correct arrangement is ProductID, Category, Description. This allows you to list the required fields and sort by Description within each Category, as sorting in Access queries follows the left-to-right order of fields in the design grid.

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