Proper Name Technique

  • Thread starter Thread starter Shelly Jackson
  • Start date Start date
S

Shelly Jackson

I have no formal training using Access. What is the proper technique/format
for naming tables, forms, queries, reports, etc.

I noticed a lot of users name tables like this:

tblMyTable

If this is the proper way to name a table, what is the proper way to name
queries, forms and reports?

qryMyQuery

frmMyForm

rptMyReport?

TIA

S. Jackson
 
Shelly,

Yes, that is one way. There are many ways for naming
objects. The main thing is to pick one way and be
consistant. Check out this link:

http://www.mvps.org/access/general/gen0012.htm

You could do a Google search for "naming conventions" also.

Don't use reserved words (Date, Name, etc) as field names.
Using a prefis or suffix (dteDate, txtName) will ensure
that you won't use a reserved word. And don't use spaces
in names!(Employee Name, Customer Table) It will only
cause you headaches.

HTH

Steve
 
Back
Top