Cnac 607 Personnel And Payroll Management System

Management of information is an old activity, while the means of managing is developing during all the time: from handwork to computer technology; from flat file to relational object database; from single computer mode to client/server mode, the technology for management is more developed, more scientific and more objective. Meanwhile, the datum that can be managed is much more , which matched the development of information era.According to the requirements of person management in one company, this dissertation analyzes and discusses the system design and realization: it first briefly introduces the basic theories of database; then according to the experience gotten during the period of design for this person management system, this dissertation expounds the theories which are instructional modules and the main functions of each module, further more, some codes are listed to demonstrate the technologies which are adopted in application programs.The Visual Basic of the company of Microsoft develops 6.0 versions of system, is a tool that develops the efficiency to use for establishing the high performance module and the application procedures very highly. The Visual Basic 6.0 can support to develop the personnel to carry according to the customer or the server carry to establish the excellent applied procedure , or operate under the distribute type n layer environment. The Visual Basic is the fast application procedure development (RAD) tool, can be the independent product usage, also can be 6.0 sets of part of pieces of the Visual Studio usage.Access 2002 is one of the member of the software package of Office, Access 2002 excel the logarithms according to carry on the processing, for example establishment, line up the preface and categorize and gather the data etc. to operate.2002 similar to the Visual Basic 6.0 knots put together the advantage of the most is both usage database engines of Access, namely Microsoft Jet. Therefore can build up since include the applied procedure that the module of Access includes the module of Visual Basic again, thus since raised the stability of the procedure, and then developed both well each from of advantage.The SQL is a kind of search language. in addition to database search, it still has others multi-function. It can control condition etc. with the data and the elucidation safety within definition data structure, the modification database. This text discussed SQL some applied methods.This system adopts these languages of the technique that kinds are mature conduct and actions plait distances, have simple, practical advantage, need not weave to write a great deal of complicated code, can complete the function of the overwhelming majority.This system requests to carry on according to the process that the software item manage, experiencing the step of the need analysis, actual plait distance and test.This system is divided into the password system, the personnel system and wages systems. Carried on the specialized treatise to this a few systems in this text.