Access preserves the list of Word & variable names, and you should avoid using these words and symbols when you build a table.
Access 2002/2003
-
Copy Code code as follows:
A
ADD
All
Alphanumeric
Alter
and
Any
Application
As
Asc
Assistant
AutoIncrement
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
By
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
CreateDatabase
CreateField
CreateGroup
CreateIndex
CreateObject
CreateProperty
CreateRelation
CreateTableDef
CreateUser
CreateWorkspace
CURRENCY
CurrentUser
-D
DATABASE
DATE
Datetime
DELETE
DESC
Description
Disallow
DISTINCT
Distinctrow
Document
DOUBLE
DROP
-E
Echo
Else
End
Eqv
Error
EXISTS
Exit
-F
FALSE
Field, Fields
FillCache
FLOAT, FLOAT4, FLOAT8
FOREIGN
Form, Forms
From
Full
FUNCTION
-G
General
GetObject
GetOption
GotoPage
GROUP
GROUP by
Guid
-H
Having
-I.
Idle
Ieeedouble, Ieeesingle
If
IGNORE
Imp
In
INDEX
Index, Indexes
INNER
INSERT
InsertText
INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
Into
Is
-j
JOIN
-K
KEY
-L
LastModified
Left
Level
Like
LOGICAL, LOGICAL1
LONG, Longbinary, Longtext
-M
Macro
Match
Max, Min, Mod
MEMO
Module
Money
Move
-N
NAME
NewPassword
NO
Not
Note
Null
Number, NUMERIC
-O
Object
OLEOBJECT
Off
On
OpenRecordset
OPTION
OR
Order
Orientation
Outer
Owneraccess
-P
Parameter
PARAMETERS
Partial
PERCENT
PIVOT
PRIMARY
PROCEDURE
Property
-Q
Queries
Query
Quit
-R
Real
Recalc
Recordset
REFERENCES
Refresh
RefreshLink
RegisterDatabase
Relation
Repaint
RepairDatabase
The
Reports
Requery
Right
-S
Screen
Section
SELECT
SET
SetFocus
SetOption
Short
Single
SMALLINT
SOME
Sql
StDev, StDevP
STRING
Sum
-T
TABLE
TableDef, TableDefs
TableID
TEXT
Time, TIMESTAMP
Top
TRANSFORM
TRUE
Type
-U
UNION
UNIQUE
UPDATE
USER
-V
VALUE
VALUES
Var, VarP
VARBINARY, VARCHAR
-W
WHERE
With
Workspace
-X
Xor
-Y
Year
YES
Yesno
And the following punctuation marks
.
/
*
:
!
#
&
-
?
"
'
$
Access 2000
-A
ADD
All
Alphanumeric
Alter
and
Any
Application
As
Asc
Assistant
AutoIncrement
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
By
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
CreateDatabase
CreateField
CreateGroup
CreateIndex
CreateObject
CreateProperty
CreateRelation
CreateTableDef
CreateUser
CreateWorkspace
CURRENCY
CurrentUser
-D
DATABASE
DATE
Datetime
DELETE
DESC
Description
Disallow
DISTINCT
Distinctrow
Document
DOUBLE
DROP
-E
Echo
Else
End
Eqv
Error
EXISTS
Exit
-F
FALSE
Field, Fields
FillCache
FLOAT, FLOAT4, FLOAT8
FOREIGN
Form, Forms
From
Full
FUNCTION
-G
General
GetObject
GetOption
GotoPage
GROUP
GROUP by
Guid
-H
Having
-I.
Idle
Ieeedouble, Ieeesingle
If
IGNORE
Imp
In
INDEX
Index, Indexes
INNER
INSERT
InsertText
INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
Into
Is
-j
JOIN
-K
KEY
-L
LastModified
Left
Level
Like
LOGICAL, LOGICAL1
LONG, Longbinary, Longtext
-M
Macro
Match
Max, Min, Mod
MEMO
Module
Money
Move
-N
NAME
NewPassword
NO
Not
Null
Number, NUMERIC
-O
Object
OLEOBJECT
Off
On
OpenRecordset
OPTION
OR
Order
Orientation
Outer
Owneraccess
-P
Parameter
PARAMETERS
Partial
PERCENT
PIVOT
PRIMARY
PROCEDURE
Property
-Q
Queries
Query
Quit
-R
Real
Recalc
Recordset
REFERENCES
Refresh
RefreshLink
RegisterDatabase
Relation
Repaint
RepairDatabase
The
Reports
Requery
Right
-S
Screen
Section
SELECT)
SET
SetFocus
SetOption
Short
Single
SMALLINT
SOME
Sql
StDev, StDevP
STRING
Sum
-T
TABLE
TableDef, TableDefs
TableID
TEXT
Time, TIMESTAMP
Top
TRANSFORM
TRUE
Type
-U
UNION
UNIQUE
UPDATE
User
-V
VALUE
VALUES
Var, VarP
VARBINARY, VARCHAR
-W
WHERE
With
Workspace
-X
Xor
-Y
Year
YES
Yesno
And the following punctuation marks
.
/
*
:
!
#
&
-
?
"
'
$
Reproduced from:
http://support.microsoft.com/kb/286335/
http://support.microsoft.com/kb/209187/
