编程开发 > ACCESS > 文章内容

Access教程:Access保留字变量名列表

2017-6-20编辑:daibenhua

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

  Access 2002/2003

  -

 代码如下:

  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

  以及以下标点符号

  .

  /

  *

  :

  !

  #

  &

  -

  ?

  "

  '

  $

  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

  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教程:union这个连接是有什么用的和INNERJOIN有什么区别

热点推荐

登录注册
触屏版电脑版网站地图