VB通用药品公司进销售存管理系统设计(源代码+系统).rar

摘 要

计算机管理信息系统是一项系统工程，综合了计算机、网络、数据库、通

讯技术，也包括了企业管理科学和众多丰富实践经验的总结。它是先进科学技

术和现代企业经营管理结合的范例。它的产生和运行是企业经营管理发展到一

定阶段、一定规模及特定经济环境下的必然要求。

目前，全球药品市场竞争日益激烈，超市企业要想获得持续性的赢利取决

于 其 是 否 能 够 赢 得 和 保 持 相 当 的 客 户 的 满 意 度 。 经 过 分 析 ， 我 们 使 用

The calculator management information system is a system

engineering, synthesizing the calculator, network, database, the

communication technique, also including the business enterprise

management science and numerous abundant empirical summary of

fulfillment.It is the example that the advanced science technique

combines with the modern business enterprise management. Its

creation and movement is the business enterprise management

management develops the certain stage, inevitable request of certain

scale and particular and economic environmentses are. Currently, the

global drugs` market competition is increasingly vigorous, the

is convenient and simple and direct to manipulate the database of

intelligence turn the object, build up the system application

prototype in the in a short time first, then, start the prototype

system to carry on the need generation to the beginning, revise and

improve continuously, until formation the customer is satisfied and

can go the system.

Keywords: window body area database.

目 录

摘 要.............................................................................................................................I

ABSTRACT ...............................................................................................................II

3.1 前台开发工具语言...........................................................................................3

3.1.1 Visual Basic 语言的特点： .......................................................................3

3.2 数据库简介.......................................................................................................7

3.2.1 关系型数据库的实现 ...................................................................................7

3.3 二者的结合(DBA).............................................................................................8

3.3.1 使用 Microsoft Access 2000 创建数据库 ...............................................8

3.3.2 修改已建的数据库 ..................................................................................8

3.4 软件的运行环境设计.......................................................................................8

3.4.1 软件环境： ................................................................................................9

3.4.2 硬件环境： ................................................................................................9

5.1.2 库存表 kc..................................................................................................13

5.1.3 密码表 ma ................................................................................................14

5.1.4 客户基础信息表 kh .................................................................................14

5.1.5 入库表 rkd ................................................................................................15

5.1.6 入库退单表 rktd.......................................................................................16

5.1.7 销售表 xsd................................................................................................17

5.1.8 销售退单表 xstd.......................................................................................18

5.2 系统主界面设计.............................................................................................19

5.3 日常业务设计.................................................................................................21

5.3.1 入库单模块设计 ......................................................................................21

5.5 查询统计设计.................................................................................................25

5.5.1 入库查询模块设计 ..................................................................................25

5.5.2 销售查询模块设计 ..................................................................................26

5.5.3 销售退货查询模块设计 ..........................................................................27

5.6 基础信息管理设计.........................................................................................28

5.6.1 供应商管理模块设计 ..............................................................................28

5.6.2 客户管理模块设计 ..................................................................................28

5.7 系统设置设计.................................................................................................29

5.7.1 初期建帐模块设计 ..................................................................................29

5.7.2 密码设置模块设计 ..................................................................................29