Microsoft Office Tutorials and References
In Depth Information
6
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 fi eld.
Recruiter Number
fi eld added
Current Due fi eld
added
Figure 1–31
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 fi eld, right-click the column heading for the fi eld (the position containing
the fi eld name), and then click Delete Column on the shortcut menu.
• To change the name of a fi eld, right-click the column heading for the fi eld, click
Rename Column on the shortcut menu, and then type the desired fi eld name.
• To insert a fi eld as the last fi eld, right-click the Add New Field column heading, click
Rename Column on the shortcut menu, type the desired fi eld name, click the down
arrow, and then ensure the correct data type is already selected.
• To insert a fi eld between existing fi elds, right-click the column heading for the fi eld
that will follow the new fi eld, and then click Insert Column on the shortcut menu.
You then proceed just as you do when you insert a fi eld as the last fi 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
Offi 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 defi ne the fi elds in
the table.
Creating a Table: Table
Templates
Access includes table
templates that assist
you in creating some
commonly used tables
and fi 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
the table.
Search JabSto ::




Custom Search