F. Scott Barker's Microsoft® Access 2000 Power Programming

CREATING DATABASE OBJECT BASE NAMES

The building blocks of your Access application are its database objects. When creating base names for these objects, you should give careful consideration to the purpose of the object, the approaches used to name associated objects, and the following rules of thumb for naming database objects.

Rules for Base Names

Follow these rules when developing a base name for a new database object:

• Spaces aren't allowed in any object name. Spaces create a multitude of problems with consistency, readability, and documentation. Where a space would help readability, use an underscore instead.

• Object names begin with a letter and should include only letters, digits, and underscores. Using special characters in object names ...