摘要:理财系统是一个企业或者家庭不可缺少的部分,企业很早就实施了理财的集中管理,而家庭使用的小型理财系统却只是凤毛麟角,理财是很小的一个部分,但大到企业,小到家庭都有十分重要的意义。现在的城乡家庭生活发生了明显的变化,人们的收入逐渐拉开档次,消费水平也高了。大多数家庭关注的是提高生活质量,一方面精打细算,量入为出,把钱用在刀刃上;另一方面保证适当的娱乐活动、社会交际、智力开发等方面的开支。因此,家庭理财具有十分重要的意义。
本文介绍了家庭理财系统开发全过程。本系统使用Visual Basic 6.0编程语言,采用SQL Server 2000作为数据库,本系统可以实现系统管理、理财项目管理、日常管理、统计报告管理等功能。包括日常收支的添加、编辑、删除及查询功能;家庭银行账户的存取款情况的记录、编辑及删除功能;家庭对外的借贷、放贷情况的记录、编辑、删除及查询功能。
关键字:家庭理财; 管理信息系统; SQL Server2000; Visual Basic
Abstract:The system of financial manage is very important to corporation and family, and it is an indispensability part. As early as the corporation had focused on carry out the financial manage, however, it was rarity. Though financial manage was only a small part, but to corporation and family, it has very important meaning.Nowadays, With the rapid development of economic, the family finance has become one of the problems, which are paid much attention by people. Now urban and rural family life of notable changes have taken places, people's income gradually open class, consumption level is also high. Most families concern is, on the one hand, to improve the quality of life habits, pay-as-you-go, put your money in the blade; On the other hand, ensure the proper entertainment, social communication, intelligence development expenditure. Therefore, many families have long-term financial budget, have basic construction planning.
By reading this paper readers will know the design process of the system and master the system’s functions. The system which uses Visual Basic 6.0 programming language and SQL Server 2000 as a database, can achieve system management, project management, financial management, daily management, statistical reporting and management functions.Including daily income and expenditure to add, edit, delete, and query; the family situation of the bank account deposit and withdrawal record, edit and delete functions; family of external borrowing, lending case record, edit, delete, and query.
Keywords:Family financial; Management information system; SQL Server 2000; Visual Basic