Access Programming Etiquette...

[racemadnss]

Hey Yall,

I'm new to programming in access and I would like to make my program look as professional as possible.

My main question is etiquette, naming tables, querys, forms, macros, reports, and modules.

I Have seen a few people use tblTablename before, is this the standard?

If so please give me your tips on how to make my program look professional.

Thanks Yall

 

[cbearden]

I do use those prefixes (tbl, qry, dap, frm etc etc)
It makes it easier to know what is what w/o looking to the left to see if your in tables, query, or whatever. plus i do think it makes it look more professional, but that's just my opinion.

 

[Cosmos75]

Leszynski/Reddick Guidelines

From The Access Web (http://www.mvps.org/)
Commonly used naming conventions

 

[racemadnss]

Awesome that link will help out A ton!

 

[Cosmos75]

racemadness,

You're very welcome. I think that when I first started out, someone else pointed me to that link or one like it! So, I guess now it is my turn to return the favor!


Good luck!