Proper Name Technique

[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

 

[Van T. Dinh]

For basic info:

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

For more details, check your Access books and search the Microsoft Web site
(and other sites) for Reddick (or Leszynski or both) Naming Convention.

 

[SteveS]

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