2024年5月26日发(作者：)

Database introduction and ACCESS2000

The database is the latest technology of data management, and the important

branch of computer science. The database , as its name suggests, is the warehouse

to preserve the data. The warehouse to store apparatus in computer only, and data

to deposit according to sure forms。The so-called database is refers to the

long-term storage the data acquisition which in the computer, organized, may

share。In the database data according to the certain data model organization, the

description, and the storage, has a smaller redundance, the higher data

independence and the easy extension, and may altogether shine for each kind of

user。The effective management database, frequently has needed some database

management systems (DBMS) is the user provides to database operation each

kind of order, the tool and the method, including database establishment and

recording input, revision, retrieval, demonstration, deletion and statistics。

Microsoft develops ACCESS2000 is in Windows95/98/2000 and Windows in the NT

platform the application relations database management system, may according

to carry on the control and the management through each kind of database object

logarithm, no matter the user founds the independent tabletop database is

suitable for individual, the department or the entire enterprise, ACCESS2000 all

may the database which is easy for the management data production to use,

ACCESS2000 not only have the function which multitudinous tradition data bank

administration software has, meanwhile further strengthened with the web page

integration, can a more convenient sharing surmount each kind of platform and

the different user rank data。ACCESS2000 certainly does not need the database

superintendent to have the very high specialized programming level, the non-

specialized user definitely may found a function formidable database system using

ACCESS2000, uses the ACCESS2000 database management system only if carries

out complex or the specialized operation, in the ordinary circumstances the user

does not need to compile the procedure code to be allowed to complete the

majority data the supervisory work。Now the society is an information society, all

the various trades' and occupations' data message all quite rich, this had decided

the use database management system management data is extremely essential, in

the library then manifests is more obvious, the manager may not spend the small

effort from in the tens of thousands of this book database to retrieve the books

which the reader wants to borrow. The ACCESS2000 database is object-oriented,

uses the event to actuate the mechanism the new relationship database

management system (RDBMS) it already to be allowed through ODBC with other

databases (Sybase, the Paradox □connected realization data exchange and sharing,

also may with Word, Excel □the Office office software carry on the data message

exchange with altogether to shine。After uses the ACCESS2000 database, the user

may manage all information in the sole database. The data only needs in the table

to save a time, the user then may examine in the different position, after some

data renewal, all demonstrations this data position all automatically will renew, like

this was allowed to avoid the redundancy memory reducing the work load and the

wrong ACCESS2000 database will be by the table, the inquiry, the window, the

report form, the data accessing page, great as well as the module seven kind of

data objects is composed, these data objects have the different function in the

database, these database objects majority of all saved in the database take

ACCESS2000 a part, if had alone to output some database object, was allowed to

provide using ACCESS2000 derives the function, Although ACCESS2000 can use its

conformity ACCESS Visual the basic 6.0 languages visible foundations application

procedure, but the very few some people use it to develop a database application

procedure。

数据库概论及ACCESS2000简介

数据库是数据管理的最新技术，是计算机科学的重要分支。数据库，顾名思义，是存

放数据的仓库。只不过这个仓库是在计算机存储设备上，而且数据是按一定的格式存放的。

所谓数据库是指长期储存在计算机内的、有组织的、可共享的数据集合。数据库中的数据

按一定的数据模型组织、描述、和储存，具有较小的冗余度、较高的数据独立性和易扩展

性，并可为各种用户共享。为了有效的管理数据库，常常需要一些数据库管理系统（DBMS）

为用户提供对数据库操作的各种命令、工具及方法，包括数据库的建立和记录的输入、修

改、检索、显示、删除和统计等。

微软开发的ACCESS2000是在Windows95/98/2000及Windows NT平台中应用的

关系型数据库管理系统，可以通过各种数据库对象对数据进行控制和管理，不论用户创建

的独立桌面数据库适用于个人、部门还是整个企业，ACCESS2000都可以为管理数据生成

易于使用的数据库，ACCESS2000不仅拥有众多传统数据库管理软件所具备的功能，同时

还进一步增强了与web页集成，能够更方便的共享跨越各种平台和不同用户级别的数据。

ACCESS2000并不需要数据库管理者具有很高的专业程序设计水平，非专业的用户完

全可以利用ACCESS2000创建出一个功能强大的数据库系统，使用ACCESS2000数据库

管理系统除非执行复杂或专业的操作，一般情况下用户无需编写程序代码就可以完成大多

数数据的管理工作。

当今社会是一个信息化的社会，各行各业的数据信息都比较丰富，这决定了利用数据

库管理系统管理数据是十分必要的，图书馆中进而体现的更加明显，管理员可以从成千上

万本书的数据库中不费吹灰之力检索出读者想要借阅的图书……等等。ACCESS2000数据

库是一个面向对象，采用事件驱动机制的新型关系数据库管理系统（RDBMS）它既可以通

过ODBC与其他数据库(Sybase、Paradox 等)相连实现数据的交换与共享，也可以与

Word 、Excel 等 Office办公软件进行数据信息交换与共享。

使用ACCESS2000数据库后，用户可以在单一的数据库中管理所有的信息。数据只需

要在表中存储一次，用户便可以在不同的位置查看，当某一数据更新后，所有显示该数据

的位置都将自动更新，这样可以避免冗余存储减少了工作量和错误ACCESS2000数据库是

由表、查询、窗体、报表、数据访问页、宏以及模块七种数据对象组成，这些数据对象在

数据库中有着不同的功能，这些数据库对象大部分都存储在数据库中作为ACCESS2000的

一部分，如果要单独输出某个数据库对象，可以利用ACCESS2000提供的导出功能，虽然

ACCESS2000能够利用其整合的ACCESS Visual basic 6.0语言可视化的创建应用程序，

但是很少有人利用它来开发一个数据库应用程序。