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.