程序员人生网站导航

Access保留字&变量名列表

栏目：access时间：2013-10-19 12:28:52

Access保留字&变量名列表建表时应避免使用这些词汇和符号

Access /

　　复制代码代码如下:

　　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 FLOAT FLOAT
    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 INTEGER INTEGER INTEGER
    INTO
    IS
J
    JOIN
K
    KEY
L
    LastModified
    LEFT
    Level
    Like
    LOGICAL LOGICAL
    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
    Report
    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

以及以下标点符号

   /
   *

   :
   !
   #
   &

   ?


   $

Access

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 FLOAT FLOAT
    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 INTEGER INTEGER INTEGER
    INTO
    IS
J
    JOIN
K
    KEY
L
    LastModified
    LEFT
    Level
    Like
    LOGICAL LOGICAL
    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
    Report
    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

以及以下标点符号

   /
   *
   :
   !
   #
   &

   ?



   $

转载自

------分隔线----------------------------

上一篇 mssql access top分页方法

下一篇 Google Adsense优化常见的八个误区

------分隔线----------------------------