Microsoft Office Tutorials and References
In Depth Information
Organizing and Describing Your Fields
The list of fields (columns)
in your table
The data type
of each field
Settings that affect
your entire table
Design view lists the
fields in your table,
putting each in a
separate row. Fields
here are listed from
top to bottom, but
they appear in
Datasheet view ordered
from left to right.
Next to each field is
its data type and an
Underneath the field
list, the Field
Properties section shows
about the currently
selected field. Here,
the navigation pane
has been collapsed to
provide extra space.
The properties (additional settings) for the
currently selected field (Character)
Here are a few simple ways you can change the structure of your table in Design view:
• Add a new field to the end of your table. Scroll to the last row of the field list,
and then type in a new field name. This action is equivalent to adding a new
field in Datasheet view.
• Add a new field between existing fields. Move to the field that’s just under
the place where you want to add the new field. Right-click the field, and then
choose Insert Rows. Then, type a field name in the new, blank row.
• Move a field. Click the gray square immediately to the left of the field you want
to move, and release the mouse button. This selects the field. Then, click the
gray square, and drag the field to the new position.
Note: Remember, the order of your fields isn’t all that important, because you can change the order in
which you view the fields in Datasheet view. However, most people find it’s easier to design a table if they
organize the fields from the start.