|
::
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
|
