Database Management System Of Entering Selling And Saving Of Jinong Paddy Company

Along with the development of modernization, the information management of the calculator becomes a hot issue. The data management system of entering,selling and saving is indispensable in enterprise logistics. This article is mainly talked about the establishment of the stock system of Jinong Paddy Office and the implement that is pragmatic, efficient and direct. It practically proves that in the process of carrying out, this system, on one hand, can increase the efficiency of the workers, decrease the labor intensity, and solve the problems in each aspect of the system as soon as possible. On the other hand, this system can provide the timely information of warehouse and sales for the leadership, meanwhile, can scientifically manage the quantities of stocking various species and selling in each place, having a macroscopically influence on controlling the operating condition of the paddy rice seed. Furthermore, build up a detailed file of farmers who grow the rice seed,(be so called to provide the goods to the farmer) and dealers and the customers of the paddy rice, so that it can carry on with regularity scientific effective management, ensure the quality of rice. It guarantees the scientific management of the paddy field, the increase of the quantities and profits to form a positive circulation of breeding, sales, and usage of paddy. This point is also the response and support to the agricultural policies of our country.At present, with the globalization of economy and gradual deepening of economic reformation, there is severe competition among the various businesses. It becomes the critical factor for the Chinese enterprise to improve the management and installment of the company and each segment of the process of producing, supplying and selling, to adapt to the new requirement of the customer and the abilities to take the opportunities of the market. The design of this system is just to adapt to this situation. During the limited period of time, it is hard for someone to realize all the functions, so there are two objects of this system. First, the basic object-is to make great effort to realize the automation of the logistics control, and make the enterprises find that it is very necessary to exist and to turn an intelligent manifest way to display. That can make the decision of each enterprise more relaxed, more scientific, more reasonable. Second, the further object-is to realize the management of ERP (Enterprise Resource Planning), it becomes more mature than that is taking calculator as the core of the management system of the business enterprise, adding functions including financial budget, the ability to produce and adjustment to the resources...etc.. To coordinate the enterprises to realize these functions comprehensively has been the terrace tool for the enterprise to carry out their product managements and decisions.The system reduces the labor quantity of the management section of the company after applying, improves the management and installment of the company and each segment of the process of producing to reasonably standardize the management. Try to control the stockings and the quantities in each place reasonably. Make the control to the degree that can provide the data if it needs and the amount for the department. It is also to say that it can prevent paddy from supplying backwardly, from spreading precociously to the dealers, and from stocking too much species not good sale, resulting in unnecessary pressure.This system uses Visual Basic as the principal developmental tool, combining Access database and Excel data form to carry out the development and design. It both considers the acquirement of business enterprise and the functions, making the system operate efficiently and expanding the functions in the future, and etc. the characteristics of the system are that the implement is efficient, the period of development is short, the ability to expand is strong, and the technology is standardized, etc.Here are some tasks as follows:1. It overalls the definition and the development condition of the management data system, analyzing the necessity and the significance of establishing the system.2. This article is mainly talked about the establishment of the system of entering,selling and stocking, to the concrete requirement of Jinong Paddy Company. Compare to the other software of the same kind, it is much more convenient, supplying figures to show the statistic results. In the aspects of functions, credibility, safety, specific etc. it completely satisfies the demand of the company3. It completes the design of saving the database system. On one hand, it is a common design of the system; on the other hand, it displays the statistic results by the figures. It can get the conservation and adjustment of the conventional data, and also make these data be the audiovisual graph.4. according to principle and aim of the information management system, it supplies the visible data management by Visual basic 6.0 to adjust to, and carries on a basic management to the database information, completes the development of the system of entering,selling and saving.This article mainly analyzed the basic functions and constitutions of the system, including the demand analysis of the system, the structure, classifications of the function mold, the linking method of database, and the analysis of the database mode etc. It puts emphasis on the introduction of the realization of the applicant procedure, especially transfers the abstract data to the direct graph to promote the functions to come to the consistency and safety, and the functions of the applicant procedure are integrated, conforming to the requirement of MIS symbolized by the management system of entering,selling and saving. At the same time, it gives a brief introduction of the characteristics of Visual Basic 6.0,Access and Excel.