How do you sort data in Access Query Design View?

a. Use the Sort row and specify the sort fields in a left-to-right order.

b. Enter the sort order on the Criteria row of the query design grid.

c. Select a grouping field, and then use the Sort row to select a sort order.

d. In the Sort row, select “major sort key” or “minor sort key” for each field you want to sort.