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.