Which of the following button is used to arrange data in ascending order in a table in MS-Access ?

The correct answer is (a). The Sort button is used to arrange data in ascending or descending order in a table in MS-Access.

The Filter button is used to filter data in a table. The Layout View is used to change the appearance of a table. The Design View is used to create and modify the structure of a table.

Here are the steps on how to use the Sort button to arrange data in ascending order in a table in MS-Access:

1. Open the table in Datasheet view.
2. Click the Sort button in the Sort & Filter group on the Home tab.
3. In the Sort dialog box, select the field that you want to sort by.
4. Select the Ascending or Descending option.
5. Click OK.

The data in the table will be sorted in the selected order.