How to orgainze (name) many tables, queries

[rdy4trvl]

There seems to be some function missing in Access – a tool (graphic?) or numbering scheme to organize a database with many tables, queries, forms, reports etc… that allows the user to easily recognize the affiliation between all of the objects. (Keep in mind this is coming from a relatively “lite” user.) Is there some type of naming convention or plan someone could share in naming tables (for example) in a large database – or is there something in Access I just don’t know about.

 

[JeremyNYC]

Yeah, there are dozens of them! That's a bit of a pain, in that it diminishes the value of having a standard. But there are plenty of good ones out there, and in some ways each is as good as the next. I use some variation of Hungarian/Leszynski. You can find MS's writeup of it here:

http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaraccgen/html/msdn_20naming.asp.

There's a shorter version here:

http://www.acc-technology.com/namconv.htm.

Also, when naming objects, I use CamelBack style, as it makes it easier to read. And if there are several objects related to each other, I make the first part of the name be the same for all of them, sotha they sort into the same place. Here's and example:

frmCustomer
frmCustomerOrderSub

The second one would be a subform that gets used on the first one.

Hope this is helpful.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[rdy4trvl]

Thanks Jeremy that helps!!

 

[DBAMJA]

This might help you on your way:

http://www.triadconsulting.com/Resources/Reddick.htm

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.