Working with Tables
Remember these simple rules when you create field names:
A field name has to be unique: You canít have two fields with the same name in the same table.
A field name can be up to 64 characters long.
A field name canít begin with a space.
- A field name canít contain a period (.), an exclamation point (!), an accent grave (`), or either bracket ([ or ]).
Now remember this advice:
Make your field names descriptive.
Keep your field names short.
Youíll appreciate our advice when the time comes to create calculated fields, or to write Visual Basic code.