View Single Post
  #6  
Old March 4th, 2010, 02:41 AM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Student count for Class Registration

On Tue, 2 Mar 2010 21:16:01 -0800, Dennis
wrote:

My take on this is in my company's programming standards. Essentially
it says:
Even if you don't follow any of the many guidelines in this document,
BE CONSISTENT.

I think consistency is much more important as what the actual prefix
(if any) might be.

-Tom.
Microsoft Access MVP



Tom,

Thanks for the info. I will play with it.

Opps, I mistyped my query name. Query name should have been
qrytblClass_Count. My naming convension for better or worse is

qry for a true query that answer a question.
qrytbl ... for a "logical view" of a table or series of joined tables
qryupd for an update query
qryapp for an append query

etc.

Do you have a better suggestion for a name convension?

Thanks,

Dennis