To sort records in a table

You can sort records in a table in Microsoft Access using different methods. All of the provided options are valid ways to achieve sorting:

Option A: Open the table, click on the field on which you want to perform sorting, and then click the Sort button on the database toolbar. This method allows you to sort the table based on the selected field in ascending order.
Option B: Open the table and click the Sort button on the database toolbar. A dialog will appear where you can choose the field based on which you want to sort. After selecting the field, click OK to apply the sorting. This method provides you with more control over the sorting options.
Option C: Clicking on the field heading allows you to sort the data in ascending order by default. Clicking the same field heading again will change the sorting to descending order.
Option D: All of the above options are valid ways to sort records in a table. Depending on your preference and the complexity of the sorting criteria, you can choose the most suitable method.

Therefore, the correct option is Option D: All of above.