Lesson 9	Edit the table design by moving a field
Objective	Move a field in Datasheet and Design views

Edit Table Design by moving Field

After you create a table you may decide that the fields would work better in a different order. Fortunately, moving a field to a different position in a table is one of the easiest tasks there is in Access. You move a field the same way in either the datasheet or the Design view. The following series of images shows you how:

flipbook image1 — To move a column in a datasheet, first select the column you want to move.

flipbook image2 — The next step is to click the column hear a second time, hold the mouse button down, and drag the pointer to where you want to move the column.

flipbook image3 — Your column has now been moved.

Learn to choose and define a primary key field.