When you create a field name within an Access table, you may use a name that is useful to the developer, e.g. strSurname, indicating that the field is text, but it may not be that user-friendly for the person using the table or related form.
If, however, you enter a caption for the field, this caption will be displayed instead of the field name in all views apart from Design view.
To give a caption to a field, open the table in Design view and select the field to which you wish to add a caption. In the Field Properties pane at the bottom, type in your required caption in the Caption box on the General tab.
Find out more about our Microsoft Access training courses Sydney, Australia.