Microsoft Office Tutorials and References
In Depth Information
Changing the Database Structure
the organization must satisfy may change as well. In either case, the organization must add
additional ﬁ elds to an existing table.
To make any of these changes, you ﬁ rst must open the table in Design view.
T O D ELETE A F IELD
If a ﬁ eld in one of your tables no longer is needed; for example, it serves no useful
purpose or it may have been included by mistake, you should delete the ﬁ eld. To delete a
ﬁ eld you would use the following steps.
1. Open the table in Design view.
2. Click the row selector for the ﬁ eld to be deleted.
3. Press the DELETE key.
4. When Access displays the dialog box requesting conﬁ rmation that you want to delete
the ﬁ eld, click the Yes button.
To Add a New Field
You can add ﬁ elds to a table in a database. JSP Recruiters has decided that it needs to categorize its clients.
To do so requires an additional ﬁ eld, Client Type. The possible values for Client Type are MED (which indicates
the client is a medical institution), DNT (which indicates the client is a dental organization), or LAB (which
indicates the client is a lab). The following steps add the Client Type to the Client table immediately after the
Postal Code ﬁ eld.
• Show the Navigation pane, and
then right-click the Client table to
display a shortcut menu.
• Click Design View on the shortcut
menu to open the Client table in
Client table open
in Design view
• Click the row selector for the
Amount Paid ﬁ eld, and then press
the INSERT key to insert a blank
row above the Amount Paid row
new ﬁ eld
• Click the Field Name column for
the new ﬁ eld. If necessary, erase
any text that appears.
• Type Client Type as the ﬁ eld
name and then press the TAB key.
1. Click Insert Rows button