1. At present, China's accounting software is changing from a simple accounting system to an integrated management information system, forming a management information system with accounting software as the core and integrating management, planning and analysis. Accounting software covers a wide range. The development of accounting software is based on the actual needs of users, easy to learn and use, and only conforms to China's Accounting Standards for Business Enterprises and its supporting industry accounting system. Accounting software is rapidly changing from DOS platform to Windows platform. Background database is gradually changing from XBASE database to large-scale network database. 2. Contradictions and problems: there are few high-quality commercial accounting software, the performance is not perfect enough, and the instruction manual is not standardized and detailed enough; Lack of compatibility between accounting software leads to excessive repeated development and waste of resources; Frequent upgrading of accounting software can not guarantee the relative stability of accounting data processing; The current accounting software can not meet the requirements of accounting data confidentiality; Due to the gradual increase of accounting software application units, the number of enterprises using accounting software has greatly increased. Advanced computer technology has not been fully applied in accounting computerization, and there is a gap between the development and promotion of commercial software and its practical application. The after-sales service of accounting software training can't keep up with the demand; The quality of developers needs to be improved. Second, the countermeasures and development trend research standardize accounting software accounting, including standardizing accounting subjects, accounting entries, accounting vouchers, accounting statements, accounting files, accounting posts, accounting work organization methods and accounting techniques; Strengthen market management and promote the formation and development of accounting software market; Vigorously improve the quality of accounting software, including defining development tasks, completing them by stages, combining commonness and individuality, systematically developing them step by step, unifying development tools and establishing a software inspection system; Strengthen personnel training; Accelerate the construction of accounting software sales and after-sales service framework; Establish and improve the management regulations and systems of accounting computerization in China, and strengthen the content control and audit of accounting computerization; Further improve the evaluation rules of accounting software; We should pay attention to the development of accounting information after accounting computerization. There have been serious problems in software development, such as project delay, cost overrun and even software delivery difficulties. These problems are collectively called "software crisis" by people in the industry. In order to solve this problem, software engineering has made improvements in software design, tools and development methods, trying to reduce the project risk in development, but with little effect. With the development of software engineering research, Boehm introduced the concept of risk management to the software industry for the first time in 1980s, and it attracted wide attention. Researchers began to realize that software projects need risk management as well as other projects, and the root cause of software crisis is that software projects and products have not implemented effective risk management-the research on risk management of software projects has been launched since then. Risk management research in the field of software engineering mainly focuses on its process, tools and methods. The process and method of realizing the theoretical design of risk management need the support of certain management tools. However, at present, the application scope of most software project risk management tools is relatively narrow, such as various types of risk analysis tools and communication platforms only used for risk consultation. Even the risk management software with complete functions has the defect that risk communication cannot be realized. Relatively speaking, there is little research on comprehensive risk management system. The actual situation of software project risk management activities is that there are a large number of different types of risk data to be stored and processed, and there are many logical relationships between these different types of risk data, so it is impossible to complete all management operations by only one risk list; Chapter 1 Introduction

With the rapid development of information technology, especially the development of database technology, computers have become a key tool in the information age. Database technology is an important part of computer application technology. For a large amount of data, it is more efficient to store and manage it with a database than with a file. After several generations of changes in database technology, a database era with relational database products as the mainstream has emerged. Access 2000 is a relational database product launched by Microsoft. As one of Microsoft's office suite products, Access has sold nearly 7 million copies, making it the most popular desktop database system in the world. Access, like many excellent relational databases, allows you to easily connect related information and supplement other database systems. As a "sharp weapon" for application development, Visual Basic is also manifested in the development of database applications. Its good interface and powerful control function make database programming easier. Visual Basic provides powerful database access ability, which organically combines various advanced functions of Windows with powerful database management functions.

This graduation project-personnel management system is designed and developed by using ADO technology, and a large number of SQL statements are used to add, query and delete. This system uses Access 2000 as the background database, and uses the database development platform provided by Visual Basic 6.0 to develop the foreground part.

Chapter II System Requirements Analysis

Section 1 Introduction of System Design Background

Management information system is what we often call m is (Management Information System), which is becoming more and more popular in the modern society that emphasizes management and information. Combining information management system with enterprise automation equipment is the development trend of modern enterprises in today's society. Through this management method, employees in various departments such as managers, technicians and statisticians can be freed from a large number of tedious materials and data, and only need to deal with the data and content they need, without knowing everything in each link. This can save manpower and material resources to a certain extent, and greatly enhance the timeliness and accuracy of data processing.

The content of this development-personnel management system is an example of the combination of information management and modern office equipment. The development of this system hopes to liberate personnel management personnel from the work of entry, calculation and statistics year after year. Due to the large number of personnel data, it is extremely inconvenient to input and count, and the amount of input and calculation is large. It will be time-consuming and laborious to complete these tasks by manpower, and it is easy to make mistakes and omissions. After inputting information once, the system can be reused in different information bases. All input information will be classified in detail by department, major, attendance date, pay date, etc. , so that customers can manage according to their own needs.

Therefore, the purpose of this management system is to use computers to store and process complex data, and use the connection between computers and modern office equipment to refresh data in real time, thus improving the work efficiency of enterprises.

Section 2 System Function Analysis

The heating network management system mainly has the following functional requirements:

* according to different permissions login system.

* Add, query, modify and delete the department information provided by them.

* Add, query, modify and delete the personnel information provided by them.

* Add, query, modify and delete the attendance data provided by them, and classify them by attendance month.

* Add, calculate, query, modify and delete the salary information provided by it, and classify it by salary month.

* You can add a new user, modify the user's original username and password, and delete the original user.

......

Section 1 System Design

3. Functional analysis of1.1system

* according to different permissions login system.

* Add, query, modify and delete the department information provided by them.

* Add, query, modify and delete the personnel information provided by them.

* Add, query, modify and delete the attendance data provided by them, and classify them by attendance month.

* Add, calculate, query, modify and delete the salary information provided by it, and classify it by salary month. As far as courses are concerned: course credit inquiry system

I. Introduction

The necessity of establishing a new system.

In the teaching process of the school, the recruitment and inquiry of grades is a daily work, and the school's academic staff need to recruit the relevant information of students' grades in time so that students can find their own personal grades in time and effectively.

In this school, due to the large number of students and courses, it is not timely to manually hire or count the students' course scores, so it is necessary to establish a course inspection system. In the teaching process of the school, the operation of the academic affairs office is the same as that of the students, which saves a lot of time for the academic affairs office and brings convenience to the students.

2) The goal of system design

The Academic Affairs Office allows teachers to input students' course scores by themselves, and students can input and query their own related scores through the computer course search system and print them out.

Second, the system analysis

2. 1 Analysis of organizational structure and functions

Organizational structure and function analysis is the simplest part of the whole system analysis. Organizational structure and function analysis mainly includes three parts: organizational structure analysis, relationship analysis between business process and organizational structure, and business function list. Among them, the analysis of organizational structure is usually realized through the organizational chart, which depicts the organizational structure learned from the investigation in detail on the chart as a reference for subsequent analysis and design. The analysis of the relationship between business process and organizational structure is usually realized through the business and organizational relationship diagram, which uses the information obtained from system investigation to focus on the analysis of the relationship between management business process and organizational structure, and is the basis for subsequent analysis and design of new systems. The business function list lists all the management business functions in an organization in the form of a table, which is the basis for future function/data analysis, determination of management functions to be realized by the new system, analysis and establishment of management data index system.

A. description of data flow

1. data stream number: A-0 1

Data Stream Name: Course Summary Table

Introduction: The course introduction entered by the teacher.

Source of data stream: teachers

Data flow: educational administrators

Composition of data stream: course number+credits+teachers+class hours.

Data flow: 100 sheets/day

Peak flow: 500 sheets/day

2. Data stream number: A-02

Data stream name: curriculum

Introduction: the curriculum schedule output by the educational administrator

Source of data stream: educational administrators

Data stream: students

Composition of data stream: course number+credits+teachers+class hours.

Data flow: 100 sheets/day

Peak flow: 500 sheets/day

B. Processing logic description:

1. Processing logic number: B-0 1

Processing Logical Name: Course Introduction Entry

Introduction: Teaching will introduce the courses taught by itself.

Input data stream: course introduction table

Description: According to the course information, the teacher enters the course introduction and submits it to the educational administrator for review.

Output data stream: course introduction table

Processing frequency: 200 sheets/day

2. Processing logic number: B-02

Processing Logical Name: Generate Curriculum Schedule

Introduction: The educational administrator makes the curriculum schedule according to the teacher's curriculum introduction table.

Input data stream: course introduction table

Note: the educational administrator makes the curriculum schedule according to the teacher's curriculum introduction table.

Output data stream: curriculum

Processing frequency: 200 sheets/day

C. description of data storage

Data storage number: C-0 1

Name of data storage: curriculum

Description: Detailed information about the course.

Composition of data storage: credits+class hours+teachers+course name+course number.

Keywords: course number+credits

D. description of external entities

1. External entity number: D-0 1

External Entity Name: Teacher

Description: School educators

2. External entity number: D-02

Name of external entity: student

Description: The main part of the school, the most important part.

3.3 System operating environment design (software and hardware)

System running environment design (software and hardware)

A. software environment:

Client: Windows2000, Windows2003, Windows XP.

Server: WindowsNT/Windows2000 and above operating systems.

Programming language: SOL

Database: Access2003

Hardware environment:

There are high-performance electronic computers, large-capacity storage devices, personal computers (terminals) and connected network cables. , thus forming a computer network sharing information resources, printers, scanners, etc.

3.4 Data storage design

1) Teachers submit scores of all subjects to the Academic Affairs Office, and staff record the scores to form a database system.

2) Students can use the computer grade inquiry system.

3) Teachers have the right to update and maintain their systems, and students can query and print their grades.

Answer, supplement, continue