Microsoft® Access® 2010 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 match tblContacts more closely. 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 several more fields. Now you’re ready to insert fields to store the middle initial, suffix, contact type, default address indicator, and more. As you go through adding these new fields, be sure to enter a description for each new field as well as the existing fields.

First, select the row or move your insertion point to the row that defines the field after the point where you want to insert the new field. In this case, ...