The Analysis System Of Client Demand Of Automobile Ordinal Design Based On VB+ACCESS

The information of client demand is very valuable for enterprise. It's the most important for product development. The Analysis System of Client Demand (CDA) can effectively manage the client demand of enterprise, record the specific requirement of the product development. The enterprise will effectively meet client, not blindly produce it, which is very important to modern Automobile development. Its design and development will be introduced.1, As of December 2007, it has been collected and finished to the model parameters of the market for sales, classification input parameters, the database which contains 6 hundred models and 120thousand data, such as: basic parameters, body parameters, drive and transmission parameters, safety and control parameters and comfortable parameters, appearance picture, engine status of plans, equation/idling noise parameters.2, Database structure haved been designed. It contains nine main tables: User, Types, Brand, Model, PBbasic, PBody, PDrive, PSafeCon and PComfortable.Its connection and class have been defined.3, Analyzed it, put forward system objective and operating environment, also design its collectivity structure, confirm its function structural chart and flow chart.4, Designed public module, and reduced program codes. It includes four public modules: the Const manage constant, the DbFunc manage statement,variables and function, the GeneralFunc manage user-defined functions and the Variable manage the global variable.5, VB as tool, Access as database. Achieved TreeView lookup for Brand, and the Types (price region, exhaust region, tiptop speed region and environment standard) mutual lookup, also lookup based on body structure, drive type, transmission form, and the keyword, then finded relatively parameters.6, Designed each forms of edit and management in allusion to main functions module, insured the system conveniently and intuitively run, in order to manage parameters for each type. Using addition command directly read in the system, modification and deletion edit database.7, Managed users right. Designed System user management module, and invested system administrator with right, add and delete ordinary user.