Design And Implementation Of Civil Servants’ Statistics Management System

Since2006, as an opportunity to the Civil Servant Law was promulgated, the Organization Department of CPC Central Committee and the Ministry of Human Resources and Social Security decided to carry out the civil servants statistics annually. Accurate statistical data, is the basis of deepen the reform of personnel system, construction of high-quality civil service, in exercising the structural condition of the civil service, researching to develop policies and regulations. How accurate and efficient to complete the annual statistical work for civil servants, and to provide real-time data accurately, is a new historical task, which is placed in front of all of the personnel departments.Over the years, in the civil servants’ information annual statistical work and daily work for filtering query the cadre and personnel information, there are have not provided valid information support tools, the personnel department works by traditional hand finishing methods to carry out the task statistics. Because of work intensity and heavy task, that produced many problems such as data losing, result error and redoing repeatedly. To change the personnel department relies on traditional "one table, a book, a pen, a calculator" that manual way to statistics, this paper describes the system implementation process of the Civil Servants’Statistics Management System, using of modern information technology to achieve statistical information of computer processing.The design and development process of system focused system application security and database support interoperability by demand-oriented. Developed security access control measures for the system, used data encryption technology which applicable to the system to encrypt sensitive data, designed algorithm for calculating date that stored by text, applied library functions and advanced statements in Access2003to construct special and complex queries for statistics. Through by using the Civil Servants’ Statistics Management System was designed and implemented, the personnel department could improve the statistical work efficiently and quality and needn’t to work by traditional hand finishing methods to carry out the statistics. By this way, many promble such as inefficient, data being inaccurate and repetitive work is annoying etc, should be solved also.