Question

In Query Design view, add an ascending sort order to the LastName field of the ManagerList query, then run the query.

A) Drag the LastName field to the Sort row, then click "Run Query"
B) Right-click on the LastName field, choose "Sort Ascending," then click "Run"
C) Select the LastName field, click the "Ascending" button, then click "Run Query"
D) Double-click on the LastName field, set the sort order to Ascending, then click "Run"

Answer 1

In Query Design view in a database program, to add an ascending sort order to the LastName field of a query, you must right-click on the field, select "Sort Ascending," and then execute the query by clicking on the "Run" button.

Step-by-step explanation:

To add an ascending sort order to the LastName field of the ManagerList query in Query Design view and run the query, you should follow these steps:Select the LastName field.Click on the Sort row under the field name.In the Sort row, choose "Ascending" from the drop-down list.After setting the sort order, click the "Run Query" button, typically represented with an exclamation mark icon, to execute the query with the applied sort.Option B from the question is the correct method. You right-click on the LastName field, choose "Sort Ascending," and then click the "Run" button.

This will sort the LastName field in ascending order and then execute the query.The correct option is Option A, which is to drag the LastName field to the Sort row, then click 'Run Query'.In Query Design view, you can add a sort order to a field by dragging the field to the Sort row. In this case, you need to drag the LastName field to the Sort row, which will automatically sort the records in ascending order based on the last name.After adding the ascending sort order to the LastName field, you can click the 'Run Query' button to execute the query and see the results in the specified order.