I would highly, HIGHLY recommend NOT using spaces (or other odd characters such as: !@#$%^&*(). If you do a lot of coding, spaces becomes a pain to deal with using brackets all the time and it doesn't pay to spend hours and hours troubleshooting syntax just because there's spaces or other odd characters in the field/table name. It may not seem like a big deal but when you're writing a lot of vba code (now or in the future), it can save you precious development/troubleshooting time.
If you need to separate wording in the name, use the _ instead of a space.
As a General rule, I follow this:
1. No spaces in any field/table names.
2. Don't start field/table names with numbers (I found this can be problematic...ex: 1SomeTableName or 2SomeFieldName or 3_SomeFieldName...etc...Numbers after are ok such as: SomeName1, SomeOtherName2...etc...otherwise again, plan on using brackets.)
3. Avoid using any 'special' characters as mentioned above.
4. Avoid long, long field names (such as field names that are 100+ characters long! - I had to work with a db once where someone named all their fields like this:
Are_you_21_years_old_or_at_least_18_years_old_starting_on_Dec_of_this_year. (imagine every freakin field name like this.)
One of my biggest pet peeves is when command buttons are named like: Command1, Command2, etc... instead of things that make sense like: cmdDelete, cmdClose, etc... For the few seconds it takes to name fields/buttons properly, it doesn't pay to name things idiotically and then spend the extra time tracing the name (when you haven't had to make code changes in the db for a year or so.)
Just remember that you (or someone else) will most likely at some point need to modify the code. You can make it easy on yourself (or someone else) and save a lot of time by simply naming things properly/easier.
Which of the following is easier to troubleshoot (this is a simple example but image a SQL statement with joins, etc.....):
strSQL = "Select FirstName, LastName From tblCustomers"
or
strSQL = "Select [First name], [Last name] From [my customer table]"