Modify your query in the View Designer window to order the result set by LastName and FirstName: a. Switch to the View Designer window. In the Criteria pane, in the Sort Order column, in the LastName row, enter 1 as the Sort Order. Notice the Sort Type defaults to Ascending and the ORDER BY clause is added to your SELECT statement. Your display should look similar to Figure 4-11.

b. In the Sort Order column, in the First Name row, enter 2 as the Sort Order. This causes the result set to be ordered by Last Name. For any results that have the same Last Name, the results will be ordered by First Name. Notice also that the ORDER BY clause has been added. c. Execute the query.