Question

19. open the sortedstates query in design view. modify the query to sort the state field in ascending order. each state should appear only once. save the query. open the query in datasheet view and then close it.

Answer 1

To sort the state field in the sortedstates query in ascending order and display each state only once, open the query in design view, sort the State field ascending, enable 'Unique Values', save, and then view the results in datasheet view.

Step-by-step explanation:

To modify the sortedstates query in design view to sort the state field in ascending order and ensure each state appears only once, you need to take the following steps:

1. Open the sortedstates query in design view.
2. Click on the State field to select it.
3. Locate the Sort row in the design grid and select Ascending from the dropdown options.
4. To ensure that each state appears only once in the output, set the Show row checkbox for the State field and enable the 'Unique Values' property by setting it to Yes in the query’s property sheet.
5. Save the changes you made to the query by clicking Save.
6. Open the query in datasheet view to view the changes and then close it.

These steps will alter the query to display a sorted list of unique states.