Naming conventions

Q

Question Boy

Is it wrong to name object such as tables, forms, queries like

300-01.....
900-02.....

Are numbers allowed?
Are hyphens?

Thank you,

QB
 
A

Arvin Meyer [MVP]

If you document and follow your convention religiously, there is no right or
wrong. I might point out, however, that using a standard convention allows
others the same insight into your database objects.
 
J

Jeff Boyce

I'll echo Arvin's comments and add:

If you are "embedding data" in your table names (using "300-01..." and ...),
this is NOT a good approach.

If you'll provide a bit more specific description of what (if anything)
these names represent, and the kinds of data (elements) you'll be storing in
the tables with these names, folks may be able to offer more specific
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

strive4peace

Hi,

Do not ever start a name with a number or special character, that will
bite you in unexpected ways. Always use an alpha for the first character.

Hyphen is also used for subtracting

While special characters like hyphens are allowed, it is best to stick
with alpha characters, underscore , and numbers (but be careful, a name
containing a number is often an indicator of data that needs to be
normalized).

Why do you want to use numbers in your names?


Warm Regards,
Crystal

*
:) have an awesome day :)
*
 
Top