Spaces in Table names?

  • Thread starter Thread starter Zack Barresse
  • Start date Start date
Z

Zack Barresse

Hi there,

New to Access. Wondering what the take is on having spaces in Table names?
Or any other names for that matter, i.e. Forms or Reports. Is there a
general accepted practice? Additional benefits? I'm just starting my first
*real* database and I'd like to not start out on the wrong foot here. :)

Thanks for your time.
 
Although you can use spaces in table names and fields names and query names,
it's not recommended. Such names always must be surrounded by [ ] characters
in queries and code. Preferred method is to put words together and
capitalize the first letter of each word; or use an underscore in place of a
space:

FirstName
DateInvoiceCreated
Date_Created
Audit_Total

etc.
 
Zack said:
Hi there,

New to Access. Wondering what the take is on having spaces in Table
names? Or any other names for that matter, i.e. Forms or Reports. Is
there a general accepted practice? Additional benefits? I'm just
starting my first *real* database and I'd like to not start out on
the wrong foot here. :)

Thanks for your time.

Never never never use spaces, and whenever possible use nothing but the alphabet
and digits (underscores being one exception). That applies to everything,
tables, forms, reports, fields, you name it.
 
Back
Top