Question

With the Clients table in Datasheet view, sort the records in ascending (A to Z) order based on the values in the Client Name field.

a. Click the arrow at the right of the Client Name field. Click the Sort A to Z option.
b. Use the keyboard shortcut Ctrl + A to select all records, then right-click and choose Sort A to Z.
c. Navigate to the Home tab, click on Sort, and choose Ascending for the Client Name field.
d. Double-click on the Client Name field header for automatic ascending sorting.

Answer 1

To sort records in ascending order in a Datasheet view, click the arrow next to the Client Name field header and select Sort A to Z. The correct answer is a. Click the arrow at the right of the Client Name field. Click the Sort A to Z option.

Step-by-step explanation:

To sort the records in a Clients table by the Client Name field in ascending order while viewing the table in Datasheet view, you can usually follow these steps:

• Click the arrow at the right of the Client Name field header to display a dropdown menu.
• From the dropdown menu, select the Sort A to Z option. This will rearrange the records with the Client Name values in ascending order.

While the other options mentioned might work in different contexts or with shortcuts, the typical approach in a datasheet view in most database software, like Microsoft Access, is to use the dropdown menu associated with a field header for sorting.