Alexander Huatian Qing Island Sales Management System

Sales management information system is typical management information system,which include background database building and application development.According to the database building, it reqires data coherence,integrality and database security.For the application development,it reqires application function maturity, easy use,and so on.According to my company's operation,I study SQL Server 2000 database management system,SQL language principle,VB application design,VB database technology.I have completed sales management system reqirement analysis,function module distribution,database mode analysis,and developed database construction and application.System operation verify sales management system designed by me meet customer,sales people,and super manager need.It can fit my company's sales management flow and it has already used in due form in my company.In the first chapter,I introduce concisely the database application development,sales management system, and analyze the job should be done in developing sales management system of Shandong University Huatian Technologies Co.,Ltd Qingdao Branch.In the second chapter,I introduce the sales management system in atatus quo analysis and other case experience.In the third chapter,I do the system analysis in the database design and SQL language use,introducing material developing tool:VB,database module,SQL language in VB application,etc database programming key technologies.In the forth chapter,I introduce the design analysis and blueprint analysis of MIS and SMIS.In the fifth chapter,I will analyze the module design theory and function realization.In the sixth chapter,I will operate the program design, plotting out operation popedom of 3 kind users,with 3 operation interface.It realize the much function,such as database table browse,the record append,delete,amend,report forms create,multi-database table link operate,multi-term query,out of focus query.It realize expediently update operation of no update query result collection,principal and subordinate table operation,password maintenance function.At last,System can operate the database with the same construction by open database.Making the best of the power of the VB,MS SQL Server2000,It improve the programming efficiency and dependability.