:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

Microsoft Access - Class 1 - Part V

> Back

Rules for naming fields and objects:

1. A name can be up to 64 characters long.
   
2. A name can contain letters, numbers, spaces and special characters except a period (.), exclamation mark (!), accent grave (è), and square brackets ([ ]).
   
3. A name cannot start with a space.
   
4. A table or query name must be unique within a database. A field name must be unique within a table, but it can be used again in another table.

Extra tips for naming fields and objects:

1. Capitalize the first letter of each word in the name.
   
2. Avoid extremely long names.
   
3. Use standard abbreviations (Num, Amt, Qty, etc.)
   
4. Do not use spaces in field names; rather capitalize next word to save space (i.e. CustomerName). If preferred you can also use the underscore ( _ ) to separate two words (i.e. Customer_Name).



Print this page

 

Copyright © 2006 Consultation SOS