Question

In Query Design view of the ClientsByState query, add an ascending (A-Z) sort order to the StateName and ClientName fields, then run the query to display it in Datasheet view.

a. In query grid, click the Sort field > Click Sort arrow > Ascending > Click Sort cell for ClientName field > Click Sort arrow > Ascending > RUN!
b. Click on StateName field > Sort A-Z > Click on ClientName field > Sort A-Z > Execute!
c. Sort StateName in ascending order, then sort ClientName in ascending order, and finally, run the query.
d. Ascend the order of StateName and ClientName in the query grid, then execute the query.

Answer 1

To sort the StateName and ClientName fields in ascending order in a query design, apply an 'Ascending' sort to each field in the query grid and then run the query to view the results.

Step-by-step explanation:

The question involves performing actions in database query design using Microsoft Access or a similar database management system. To add an ascending sort order to the StateName and ClientName fields in a query design, you would follow these steps:

1. In the query design grid, click on the StateName field to select it.
2. Find the 'Sort' row in the design grid under the selected StateName column, click the sort type cell to open the dropdown menu, and choose 'Ascending'.
3. Repeat the process for the ClientName field by clicking on its column and setting the 'Sort' row to 'Ascending' as well.
4. After applying the sort orders, run the query by clicking on the 'Run' button, usually represented by an exclamation mark (!) in the toolbar or ribbon.

This will sort the query results first by StateName in ascending order and then by ClientName within each state in ascending order, and display the results in Datasheet view.