Microsoft Office Tutorials and References
In Depth Information
• Make the remaining entries from
the Client table structure shown
in Figure 1–31 to complete the
structure. Be sure to select Currency
as the data type for the Current
Due ﬁ eld.
ﬁ eld added
Current Due ﬁ eld
Making Changes to the Structure
When creating a table, check the entries carefully to ensure they are correct. If you
discover a mistake while still typing the entry, you can correct the error by repeatedly
pressing the BACKSPACE key until the incorrect characters are removed. Then, type the
correct characters. If you do not discover a mistake until later, you can use the following
techniques to make the necessary changes to the structure:
• To undo your most recent change, click the Undo button on the Quick Access Toolbar.
If there is nothing that Access can undo, this button will be dim, and clicking it will
have no effect.
• To delete a ﬁ eld, right-click the column heading for the ﬁ eld (the position containing
the ﬁ eld name), and then click Delete Column on the shortcut menu.
• To change the name of a ﬁ eld, right-click the column heading for the ﬁ eld, click
Rename Column on the shortcut menu, and then type the desired ﬁ eld name.
• To insert a ﬁ eld as the last ﬁ eld, right-click the Add New Field column heading, click
Rename Column on the shortcut menu, type the desired ﬁ eld name, click the down
arrow, and then ensure the correct data type is already selected.
• To insert a ﬁ eld between existing ﬁ elds, right-click the column heading for the ﬁ eld
that will follow the new ﬁ eld, and then click Insert Column on the shortcut menu.
You then proceed just as you do when you insert a ﬁ eld as the last ﬁ eld.
As an alternative to these steps, you may want to start over. To do so, click the Close
button for the window containing the table, and then click the No button in the Microsoft
Ofﬁ ce Access dialog box. Click Create on the Ribbon and then click the Table button
to create a table. You then can repeat the process you used earlier to deﬁ ne the ﬁ elds in
Creating a Table: Table
Access includes table
templates that assist
you in creating some
commonly used tables
and ﬁ elds. To use a
template, click Create
on the ribbon and then
click the Table Templates
button on the Create
tab. Click the desired
template, make any
adjustments you wish
to the table that Access
creates, and then save