Move a field when you want it to appear in a different place in the table. To move a field, follow these steps:
1. Select the field by clicking on the box to its left. The field is highlighted.
2. Drag the field up or down across the small squares to the left of the fields. As you drag, a gray line appears between fields to show where the field will land when you release the mouse button.
3. Release the mouse button.
TIP: You can also move fields in Datasheet view. To do so,
click the field name at the top of the database table. Click again and drag it
to the left or right. A black line appears between columns to show where the
field will go. When the black line is in the right place, release the mouse
button. However, moving fields in Datasheet view only changes the table's
layout; it doesn't change its underlying structure. When you export the table,
for example, its fields will be in their Design view order.
Copy a field when all its settings—its data type and field properties—can be used over again in another field. After you have copied the field, be sure to rename it. Identical fields cannot appear in the same table. To copy a field, follow these steps:
1. Select the field to be copied by clicking the box to its left in Design view.
2. Press Ctrl-C or right-click and choose Copy from the shortcut menu.
3. Click on the field that you want the copy to appear above. In this illustration, for example, the copy will appear between the account numbers 610 and 620:
4. Either press Ctrl-V or right-click and choose Paste on the shortcut menu.
5. Change the field name for the field you copied.