Microsoft Access Versions: 1.0, 1.1, 2.0 Microsoft Access for Windows 95, Version 7.0 Microsoft Access 97 The words and symbols listed in this article are reserved words, avoid using the Access field name and variable name because these reserved words are There is a specific meaning in the Access and Microsoft Jet Database systems. If you use it, it will be wrong.
-A Add All (2.0, 7.0, 97) Alphaumeric Alter and Any (2.0, 7.0, 97) Application AS ASSASTANT AUTOINCREMENT AVG -B BETWEEN BINARY BIT BOOLEAN BYTE-CHAR, CHARACTER Column CompactDatabase (2.0, 7.0, 97) Constraint Container (2.0, 7.0, 97) Create CreateDatabase (2.0, 7.0, 97) CreateField (2.0, 7.0, 97) CreateGroup (2.0, 7.0, 97) CreateIndex (2.0, 7.0, 97 CreateObject (2.0, 7.0, 97) CreateProperty (2.0, 7.0, 97) CreateRelation (2.0, 7.0, 97) Createuser (2.0, 7.0, 97) CreateWorkspace (2.0, 7.0, 97) Currency Currentuser (2.0, 7.0, 97) - DATABASE (2.0, 7.0, 97) Date (2.0, 7.0, 97) DateTime delete Desc Description Disallow Distinct DistINCTROW Document (2.0, 7.0, 97) Double (2.0, 7.0, 97) Drople - Echo (2.0, 7.0, 97) Else end Eqv Error EXISTS (2.0, 7.0, 97) EXIT -F FALSE FIELD, FIELDS (2.0, 7.0, 97) Fillcache (2.0, 7.0, 97) Float, Float4, Float8 Foreign (2.0, 7.0, 97) Form, Forms from Full (2.0, 7.0, 97) Function -G General G ETOBJECT (2.0, 7.0, 97) Gtopage Group (2.0, 7.0, 97) Group by Guid (7.0, 97) - H Having -i IDLE (2.0, 7.0, 97) IEEEDOUBLE, IEESINGLE IF Ignore (2.0, 7.0, 97) Imp in, in Index Index, Indexes (2.0, 7.0, 97) Inner Insert InsertText (2.0, 7.0, 97) INT, INTEGER, INTEGER1, INTEGER2, INTEGER4 INTO IS, IS -J JOIN - K Key (2.0, 7.0, 97) -l Left Level Like Logical, Logical1 Long, Longbinary, Longtext -M Macro Max (2.0, 7.0, 97) MAX, Min, Mod Memo Module Money Move (2.0, 7.0, 97) - N name (2.0, 7.0, 97) NewPassword (2.0, 7.0, 97) No Null Number, Numeric -O Object (2.0, 7.0, 97) OleObject (2.0, 7.0, 97) OFF ON OpenRecordset (2.0, 7.0, 97 ) Option or Order Outer (2.0, 7.0, 97) Owneraccess -P Parameter (2.0, 7.0,
97) Parameters Partial (2.0, 7.0, 97) Pivot Primary Procedure Property (2.0, 7.0, 97) -q queries Query Quit (2.0, 7.0, 97) -R Real Recalc (2.0, 7.0 , 97) ReferenceSet (2.0, 7.0, 97) References Refreshlink (2.0, 7.0, 97) RegisterDatabase (2.0, 7.0, 97) Repaint (2.0, 7.0, 97) RepairdAbase (2.0, 7.0 , 97) Report Reports Requery Right -s Screen Section SELECT (2.0, 7.0, 97) SETSTFOCUS (2.0, 7.0, 97) SHORT SINGLE (2.0, 7.0, 97) Smallint (2.0, 7.0 SOME (2.0, 7.0, 97) SQL stdev, stdevp string sum -t table, Tabledef, Tabledefs (2.0, 7.0, 97) TableId Text Time, TimeStamp (2.0, 7.0, 97) TOP (2.0, 7.0, 97) Transform True Type -u Unique Update -v Value Values (2.0, 7.0, 97) Var, Varp Varbinary, Varchar (2.0, 7.0, 97) -w Where with Workspace (2.0, 7.0, 97) -X xor -y year YES YESNO (2.0, 7.0, 97) The following symbols cannot be used in the field design
. / *:! # & -
