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, Microsoft Access 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 LawTrack Contacts sample database.
You ...
Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.