商品管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。

本系统主要完成对商品进销存的管理，包括添加、修改、删除，查询，打印信息以用户管理等六个方面。系统可以完成对各类信息的浏览、查询、添加、删除、修改等功能。
    系统的核心是添加、修改和删除三者之间的联系，每一个表的修改都将联动的影响其它的表，当完成添加或删除操作时系统会自动地完成商品进销存的修改。查询功能也是系统的核心之一，在系统中主要根据学生姓名和学号进行查询，其目的都是为了方便用户使用。系统有完整的用户添加、删除和密码修改功能，并具备报表打印功能。
    系统采用Microsoft Office中的Access 2000来设计数据库，并使用当前优秀的开发工具—VB 6.0 ，它有着最为灵活的数据库结构，对数据库应用有着良好的支持。
论文主要介绍了本课题的开发背景，所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、难点技术和解决方案。

 

 

The system of managing student's achievement file is a typical application of managing information system (know as MIS), which mainly includes developing the application interface of front-end and building up and maintaining the data-base of back-end. The former should make the function of application integrated and the usage is easy, the latter required a data-base with powerful consistency and integrality, and nice security.

This system mainly completes the management to student's achievement, include six aspects such as adding, modifying, deleting, searching, printing information and the customer management. The system can complete to browse, search, add, delete, modify etc. to each kind of the function of information.

The core of the system is the contact of increase, modification and delete, the modifications of each form will affect to other forms, the system will complete the modification of student's achievement of itself while being to complete to increase or delete the operation. Inquiring about the function of searching also is the one of the systematic nucleus, carrying on the search mainly according to the student's name and registration number in the system, its purposes are all for the sake of convenient users usage.The system contain the integrity function of users increase, delete and the cipher modification, and the report form to print.