Commonly used naming conventions

When building Access databases, it is highly recommended that you use a naming convention to standardize how you name your objects. This will make development easier for yourself and help eliminate confusion when other developers make modifications to your database. This article outlines some commonly used naming conventions.

The best way to choose good names for software objects is to employ a naming convention or standard system. Aside from better communication among programmers, the many benefits of using a naming convention include:

• Saves time thinking up names
• Reduces the need for comments
• Helps you spot errors, by allowing visual consistency checks, similar to dimension checks on mathematical equations
• Triggers early detection of design or implementation issues
• Helps in debugging code
• Provides an identity for the project's code and participants
• Allows automated tool support for writing/checking code

General: Commonly used naming conventions