You can use the FieldName property to specify the name of a field within a table. For example, you can specify "Last Name" for a field that stores employees' last names within the Employees table.
Setting
Enter a field name, following Microsoft Access object naming rules. The name can't duplicate any other field name in the table.
Note Avoid specifying a name for a field that could cause a conflict with built-in Microsoft Access function or property names, such as the Name property.
You can set this property in the upper portion of table Design view or by using Visual Basic.
In Visual Basic, use the ADO Name property to read and set a table's field name.
Remarks
Microsoft Access identifies a field by its field name. Once you have specified a field name in table Design view, you can use that name in expressions, Visual Basic procedures, and SQL statements.