图书销售管理系统

图书销售管理系统

用Access 2003开发一个小型的数据库应用系统:图书销售管理系统

一、总体设计:

在使用Access 2003建立数据库的表、窗体和其他对象之前，设计数据库是很重要的。合理的设计是创建能够有效地、准确地、及时地完成所需功能的数据库的基础。没有好的设计，数据库不但在查询方面效率低下而且也较难维护。

在进行数据设计之前必须清楚这个系统需要实现什么样的功能，然后再细化到数据库各个组件的设计上。设计的一般过程为:

规划系统设计流程

了解用户需求并设计基本结构

分析与设计数据库

设计基本表

设计窗体、报表等其他组件

最后测试、完成

(一)需求分析:5

在开始设计数据库的之前，需要确定数据的目的以及如何使用，尽量多了解一些有关数据库的设计要求，弄清用户需要从数据库得到什么样的信息。

1、数据库设计的主要步骤:

正式实施数据库设计时，主要的过程具体有以下几个步骤:

(1) 确定数据库中需要的表;

(2) 确定该表中需要的字段;

(3) 明确每条记录中有唯一值的字段;

(4) 确定表之前的关系;

(5) 输入数据，创建其他数据库对象。

2、创建数据库时要做的准备:

在创建一个数据库之前需要明确以下几点:

(1) 数据库必须能够管理用户期望的输出生打印输出所有必须具备的信

息;

(2) 数据中不保存不必要的信息;

mplementation "five big development concept" of requirements,

accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our

efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere

to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

(3) 弄清数据应该为用户所做的操作和应解决的问题;

(4) 明确用户通过什么样的界面来操作数据库中的数据和输出。

3、数据库用户的分类

数据库设计完成之后，所面对的是数据库的用户，不同的用户对于同一个数据库会有不同的使用，因此明确谁将使用数据库是很重要的。

通常数据库的用户分为以下3种情况使用数据库。

(1) 将数据添加到数据库中;

(2) 编辑、操作和整理输出数据库中的数据;

(3) 查询数据中的数据。

从设计角度来看，应按不同类型的用户设计数据库的表、窗体和报表。

(二)数据库设计原则:

一个好的数据库必须在开发时使用数据库结构满足一定的条件和原则。简化一个数据库结构的过程被称为“数据标准化”。

标准化数据库设计的一些原则如下:

1、减少数据的冗余和不一致性:

如果数据库存在冗余和不一致问题，用户每次向数据库中输入数据时，都有发生错误的潜在可能。例如，人事信息数据库中，如果在多个不同的表中都包含姓名的输入，那么用户在多次输入时，就有可能发生错误。

2、简化数据检索:

数据库中保存的信息必须能够根据需要快速地显示出来，否则，使用计算机自动化的数据库系统将没有任何意义。

、保证数据的安全: 3

数据库中的数据，必须具有一定的安全性，输入数据库中的数据在输出显示时，必须对应显示原有的数据。

4、维护数据的方便性:

数据库中的数据在每次更新或删除时，都必须将数据库中所有出现与它相关的地方做出改变，并且在设计数据库时，要考虑到数据的修改，最好在尽量少的操作步骤中完成。

二、图书销售管理系统的设计:功能模块:

mplementation "five big development concept" of requirements, accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge

ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

1、图书进货:

通过“图书进货录入”窗体来实现。

2、图书销售:

通过“图书销售录入”窗体来实现。

mplementation "five big development concept" of requirements, accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our efforts to promote economic and social development--in the Communist XX

XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

3、库存查询:

通过“库存查询条件”窗体来实现。要求:单条件可以实现查询(例如:输入图书编号即可查询此编号的图书信息)、多条件也可实现查询(例如:输入图书编号、图书名称或输入图书编号、图书名称和作者都可实现查询)

4、销售浏览:

通过“图书销售浏览”窗体来实现。

mplementation "five big development concept" of requirements,

accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our

efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

5、报表:

报表模块的功能如下图:要求每点击一个功能选项即可弹出相关的报表。

6、系统维护:

系统维护模块的功能如下图:

mplementation "five big development concept" of requirements, accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good

environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our

efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

其中“图书信息维护”模块用“图书信息维护”窗体来实现。

“人员信息维护”模块用“人员信息维护”窗体来实现。

mplementation "five big development concept" of requirements, accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of

requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our

efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order

7、退出:既退出数据库管理系统环境。

1、把应用系统进行集成。

应用系统集成的目的是把窗体、报表等对象组织起来，通过特定的操作界面来调用它们，并且屏蔽数据库其他的操作，使之成为一个完成的系统。

系统集成的过程主要包括切换面板的创建、启动窗体的设置和生成MDE文

件等步骤。

mplementation "five big development concept" of requirements, accurate grasp economic development new normal and transformation development of relationship; deep understand on in-depth advance rule of law construction, and to build transformation development good environment of requirements; deep understand on full mobilization General cadres enthusiasm, and constantly upgrade work essence God of requirements, put Jia Secretary speech spirit implementation to specific action in the to, promoted XX economic social development Michael Shang new steps. Xiang BA third party Congress report on the work of our

efforts to promote economic and social development--in the Communist XX XX eight reporting three plenary meetings of the Commission representatives and comrades: today, on behalf of the Chinese Communists XX th report of the Committee to the General Assembly. First, forge ahead in unity, overcome difficulties, XX years of outstanding achievements. XX years in the County, the County Government's strong leadership, the Township Party Committee rally and lead the entire

people of all ethnic groups, seriously implement the Central, provincial, State authority and the decisions of the County party Committee, adhere to the "steady, steady, steady quality," General requirements, forge ahead in unity, overcome difficulty, do solid work, to promote theImplementation of the work, the successful completion of the objectives defined at the beginning of the task, the Township to

maintain sustainable economic growth, social harmony and stability, ethnic unity and progress, peace consolidation and eco-good order