Page 42 - Computer - 8

Changing the Data Type of a Field

To change the data type of a field: 1
1. Click the column header of the field whose data type you
want to change.

2. On the Table Tools Table Fields tab, click the Data Type
down arrow in the Formatting group. 2
A list of data types appears.
3. Select the required data type.
Access changes the data type of the field. 3

SORTING RECORDS IN A DATASHEET

Sorting Records
Access allows you to sort the records stored in a table based on the values in one or more fields, either
in ascending or descending order. Sorting of data makes it easy to compare values across records in a
table. By default, Access sorts records on the basis of ID (AutoNumber) field.

To sort records in a table:
1. Open the table in Datasheet view.

2. Click the column heading of the field on which you want to sort the data.

3

2

1

3. On the Home tab, in the Sort & Filter group, click:
Ascending To sort the data in ascending order (smallest to largest).

Descending To sort the data in descending order (largest to smallest).

Access sorts the data as per the selected option.

40