access.txt

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