A general query rather than a specific one.

Are there any naming conventions for forms, tables etc?

Are there any standards for any or all access bits?

I have noticed databases where the forms were prefixed with "Frm" altho' I was unsure of the merits of this??

Wiki on Leszynski naming convention (http://en.wikipedia.org/wiki/Leszynski_naming_convention)

http://www.access-programmers.co.uk/forums/showthread.php?t=132449

Some good discussion points here also

I think David's link is good. Here are some extra conventions that I have used myself (some are my inventions, some are not):

cbo = combo box
lbl = label
lst = listbox
txt = text box
tbl = table
frm = form
subfrm = subform
bas = VB module
mcr = macro
qry = query
rpt = report
cmd = button
img = image control

Just my 2 cents worth.

I've said it before and I'll say it again.

Any naming convention that isn't "natural" to you is useless. Because you'll forget to use it or avoid using it. Or use it inconsistently.

Any convention that you will use is good. As long as you follow it. As long as you CAN follow it.

The most beautiful theoretically-based naming convention in the world is a steaming pile of dyspeptic dragon droppings if you can't use it effectively.

(OK, I'll admit it - I'm a pragmatist.)