Proper Name Technique

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top