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

Changing Field Names

Perhaps you misspelled a field name when you first created one of your tables. Or perhaps you’ve decided that one of the field names isn’t descriptive enough. As you learned in Chapter 4, you can change the displayed name for a field by setting its Caption property. But you won’t necessarily want the hassle of giving the field a caption every time it appears in a query, a form, or a report. Fortunately, Access 2007 makes it easy to change a field name in a table—even if you already have data in the table.

Note

The next several examples in this chapter show you how to change the Contacts table that you created in the previous chapter to more closely match the tblContacts table in the Conrad Systems Contacts sample database.

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