Is there a naming convention used when naming your tables,
queries, forms etc?
There are many such naming conventions... <g>
I see you've gotten pointers to the commonly used Reddick conventions.
They're ok but IMHO you shouldn't get fanatic about using them; for
instance I never use prefixes on table fieldnames. Others do.
Provided you're consistant, understand what you're doing, and do it in
a way which is understandable to anyone else who'll be using the
database, you should be OK. A convention like Reddick helps in this
goal, but is far from the only way.