Microsoft Office Tutorials and References
In Depth Information
• Right-click Add New Field to display a shortcut menu, click Rename Column on the shortcut
menu to display an insertion point, type Client Name to assign a name to the new ﬁ eld,
and then press the DOWN ARROW key to complete the addition of the ﬁ eld.
Did I have to press the DOWN ARROW key? Couldn’t I have just moved to the next ﬁ eld or
pressed the ENTER key?
You could have pressed the TAB key or the ENTER key to move to the column heading for the
next ﬁ eld. Pressing the DOWN
ARROW key, however, completes
the entry of the Client Number
ﬁ eld and allows you to ensure that
the column is assigned the correct
data type is
ﬁ eld selected
• Using the same technique add the
ﬁ elds in the Client table up through
and including the Amount Paid
• Click the Data Type box arrow to
display the Data Type box menu
• Click Currency to select Currency as
the data type for the Amount Paid
ﬁ eld (Figure 1–29).
Why does Currency appear twice?
The second Currency is the format,
which indicates how the data will
be displayed. For the Currency data
type, Access automatically sets the
format to Currency, which is usually
what you would want. You could
change it to something else, if
desired, by clicking the arrow and
selecting the desired format.
set to Currency
• Click the right scroll
arrow to shift the
ﬁ elds to the left and
display the Add New
ﬁ elds have been
shifted to the left