Microsoft® Office Access 2003 Inside Out

Inserting Fields

Perhaps one of the most common changes you’ll make to your database is to insert a new field in a table. Up until now, we’ve renamed and moved the available fields to more closely match tblContacts. If you take a look at the comparison of the two tables again (Table 5-1 and Table 5-2), you can see that we need to add a few more fields. Now you’re ready to insert fields to store the contact title, suffix, contact type, default address indicator, and more.

First, you must select the row or move your cursor to the row that defines the field after the point where you want to insert the new field. In this case, if you want to insert fields for the title (Mr., Mrs., etc.), suffix (Jr., Sr., etc.), and contact type (customer, sales prospect, ...