Guidelines for naming objects
Names of fields, controls, and objects:
• Can be up to 64 characters long.
• Can include any combination of letters, numbers, spaces, and special
characters except a period (.), an exclamation point (!), an accent grave
(`), and brackets ([ ]).
• Can't begin with leading spaces.
• Can't include control characters (ASCII values 0 through 31).
• Can't include a double quotation mark (") in table, view, or
stored procedure names in a Microsoft Access project.
When you name a field, control, or object, it is a good idea to make
sure the name does not duplicate the name of a property or other element
used by the database; otherwise, your database can produce unexpected
behavior in some circumstances.
About data types and
About primary keys
Opening and viewing
tables and views
Change the appearance
of tables and views