Rearrange the order of columns in a table
You can rearrange the order of columns in a table in Datasheet view or in Design view. You can move a single column or a contiguous group of columns.
Select the column that you want to move. To select more than one column, drag the pointer until you have selected the columns that you want.
Do one of the following:
In Datasheet view, drag the selected columns horizontally to the position that you want.
In Design view, drag the selected columns vertically to the position that you want.