About renaming a field in a table (MDB)
Note The information in this topic applies only to a Microsoft Access database (.mdb).
To rename a field in a table, you can change the name of the field itself, or you can change the Caption property of the field to specify a different display name. The Caption property determines the field name that appears in Datasheet view. It also specifies the default text for labels attached to controls in forms and reports. The name specified by the Caption property might be different from the name of the field itself.
This is useful in situations where you want the column heading to be longer or more descriptive than the actual field name. For example, you might want to name a field LName for use in Microsoft Visual Basic for Applications code and expressions, but display "Last Name" as the field's column heading.
If you don't specify a caption for a field in a table, the name of the field is used.