I would avoid the spaces, although Access will let you use them. If you do,
you will have to make sure you always enclose the name in brackets, [table
name], when you use it. The upper/lower case will make no difference to
Access, use what makes it easier for you to read. Usually, if you type a
name that has several words in it but you leave out the spaces, it is easier
to read if you capitalize the first letter of each word. The exception would
be if you use a prefix, such as tbl. The prefix comes in handy when you are
looking at a query in design view and don't know whether the "table" in the
query is really a table or another query. Since Access treats queries as
tables in many circumstances, you can't use the same name for a table and a
query. However, if you prefix them with tbl and qry, then the rest of the
name can be the same. This may help you keep things organized.
Example:
tblTableName
