-

Access数据库(图文教程)

Microsoft Access 是微软推出的关系型数据库管理系统,集成于 Microsoft Office 套件中,兼具数据库引擎与图形化开发工具的特点
字段索引(有重复)

access创建表
在Microsoft Access里创建表,需要启用数据库中某些内容设置

Create Table layout_page (
    id AUTOINCREMENT Primary Key,
    pagename TEXT(255),
    pagefolder TEXT(255),
    pagetablename TEXT(255),
    addedittip TEXT(255),
    listsearch TEXT(255),
    isdelinputpass INTEGER,
    isshowupdownpage INTEGER,
    isbatchdelete INTEGER,
    isshowsearch INTEGER,
    isshowaddbutton INTEGER,
    isshowprint INTEGER,
    isshowoperate INTEGER,
    isdblclickviewpage INTEGER,
    npagesize INTEGER,
    formviewmaohao TEXT(255),
    formeditmaohao TEXT(255),
    listorderby TEXT(255),
    listpagereplace MEMO,
    editpagereplace MEMO,
    viewpagereplace MEMO,
    listqueryfield TEXT(255),
    idindexname TEXT(255),
    databasetype TEXT(255),
    databaseippath TEXT(255),
    databasename TEXT(255),
    databaseuser TEXT(255),
    databasepass TEXT(255),
    tools TEXT(255),
    helpcontent MEMO,
    aspcodezip TEXT(255),
    sortrank INTEGER,
    ip TEXT(255),
    createtime DATETIME,
    updatetime DATETIME,
    isthrough INTEGER,
    bodycontent MEMO)