O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required