With the globalization of economy, the change of residents' living needs and the continuous development of computer technology, people's living standards are getting higher and higher, and financial management is becoming more and more important. Financial management directly affects people's lives. This system is suitable for the platform with C/S structure. The main purpose of this research topic is to provide unified management of financial data and make reasonable financial decisions. It has a friendly interface and simple operation. In addition to the basic financial information management, it also provides functions such as data statistics, data query and automatic statistics of charts.
For the convenience of operation, the household income of users is increased in many ways. Family expenses? Statistical savings and other property management data, as well as their own living balance and consumption statistics, and through scientific statistical methods to store these data in financial management software? Explain income in the form of pie chart? Expenditure? The relationship between three deposits contributes to the effective management and rational distribution of family property? This paper focuses on the functions and implementation of the system, such as data flow and storage. Management and other functions, and the key technologies are introduced in detail?
1.2 related theoretical and technical basis
1.2. 1
1.2.2 ACCESS 2003 2
1.2.3 C/S mode 2
2 System Requirements Design 3
2. 1 User Role Requirements 3
2.2 Feasibility Analysis 3
2.3 Environmental requirements
3 System analysis 3
3. 1 Division of specific functional modules 3
3. 1. 1 System Login Module Design 3
3. 1.2 Design of Function 4 of User Registration Module
3. 1.3 Design of Function 4 of Password Modification Module
3. 1.4 Family Finance Module 5
3. 1.5 Asset Management Module 6
3. 1.6 Asset Query Module 7
3. 1.7 Statistical Analysis Module 8
3.2 Functional Schematic Diagram 8
4 system design 9
4. 1 system design objective 9
4.2 Database Design 10
4.2. 1 financial management system 10
4.2.2 Family Income Statement 10
4.2.3. Household Expenditure Table 1 1
4.2.4. Fund Management Table 1 1
4.3 Realization of main functions of the system 1 1
4.3. 1 User login and registration 1 1
4.3.2 Family Finance 13
4.3.3 Asset Management 14
Database management 14
5 system test 16
5. 1 test environment 16
5.2 Test Contents 16
5.3 Test Results 19
Conclusion 20