Appendix A. Naming Conventions

This appendix gives you suggestions for naming variables and other database objects. The suggested standards are based on the Reddick VBA Naming Conventions (RVBA), which are commonly accepted in the industry.

When you’re creating variable names, it’s important to make the type and intended use of each variable clear and self-documenting. Here are a few rules to follow:

  • Remember to always make variable names mixed case, with each word or abbreviation in the variable name capitalized.
  • Don’t use underscore characters in your variable names.
  • Abbreviate variable names only when it’s necessary.
  • Make the beginning of each variable name describe the type of data it contains.

Following these conventions will go a long ...

Get Alison Balter’s Mastering Microsoft® Office Access 2007 Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.