Residential property management system

With the development of China's economy and cities, residential quarters have become the mainstream of living, and residential property management should also come into being on behalf of the market demand of society. Computer-run residential property management system is a management software developed for residential managers and residential users to better maintain various property management services. According to the demand analysis, the benefits of realizing residential management services have become more and more obvious. Therefore, it is necessary to develop such a set of residential property management system software. In this paper, I will talk about the development process, problems involved and solutions of the residential property management system I developed in this graduation project.

Residential property, management system, user, VB, ACCESS.

catalogue

Chapter 1 System Overview 3

The research significance of 1. 1 system 3

1.2 Research Status and Design Objectives 3

1.2 1.3 Features, advantages and disadvantages of similar research topics

1.2.2 Problems and solutions in current research 4

1.2.3 Design objective to be achieved by this project 5

Chapter II System Analysis 7

2. 1 system development background 7

2.2 Demand Analysis of Residential Property Management System 7

Chapter III System Design 8

3. 1 system function analysis 8

3.2 System Module Design 8

3.3 System Structure 8

3.3. 1 System module structure diagram: 8

3.3.2 system flow chart 10

3.4 Database Design of Residential Property Management System 10

3.5 Development Tools 15

3.5. 1

3.5.2 Visit 16

The fourth chapter system implementation 18

4. 1 permission setting 18

4. 1. 1 Form Design of Login New User Sub-module 18

4. 1.2 Modify the old user codon module window design 18

4. 1.3 Add new user sub-module form design 19

4.2 Property Management Center 2 1

4.2. 1 User Complaint Sub-Form Design 2 1

4.2.2 User Service Form Design

4.2.3 Sub-form Design of Parking Management 32

Chapter 5 Performance Testing and Analysis 35

5. 1 research and selection of test cases (test set) 35

5.2 Test Environment and Test Conditions 37

5.3 Performance Analysis 37

Chapter VI Conclusion 38

Reference 39

Chapter 1 System Overview

The research significance of 1. 1 system

With the development of market economy and the improvement of people's living standards, residential quarters have become the first choice for people to settle down and buy their own homes, and hundreds of thousands to millions of residential quarters abound. The more money you spend, the higher the requirements, not only for the beauty and quality of the house itself, but also for the service and management of the property community, such as the maintenance of the community, and even for all kinds of complaints, which require the community managers to do well and improve. In this way, community managers are required to carry out macro and micro detail management of property management, and the best way is to use computer-operated community property management system to realize the management of community property, which provides market demand for us to design community property management system. The residential property management system we designed is the hottest industry in modern society, and it is the design that cares most about the real life of ordinary people. Various humanized configurations make it easier, faster and more satisfactory for managers and owners to answer things in residential quarters. With the continuous expansion of the scale of the community and the increasing number of residents, the maintenance and complaints of cars, ancillary facilities and complaints in the community will become more and more complicated and the workload will increase. However, people have always used the traditional manual method to manage all kinds of data, which has many shortcomings, such as low efficiency and poor confidentiality. After a long time, a large number of files and data will be produced, which brings many difficulties to search, update and maintenance.

With the continuous progress of science and technology, computer science and technology is becoming more and more mature, and its powerful functions have been deeply recognized by people. It has entered all fields of human society and is playing an increasingly important role.

As a part of computer application, using computers to manage the information of enterprise units has incomparable advantages over manual management. For example: fast retrieval, convenient search, high reliability, large storage capacity, good confidentiality, long service life and low cost. These advantages can greatly improve work efficiency, and it is also an important condition for scientific and standardized management of enterprises to connect with the world.

Therefore, it is necessary to develop such a set of residential property management system software. In the next chapter, we will talk about the development process, problems involved and solutions of the residential property management system I designed and developed for this graduation.

1.2 Research Status and Design Objectives

1.2. 1 Features, advantages and disadvantages of similar research topics

With the development of China's economy and cities, property management has formed a scale, and its benefits are becoming more and more obvious. For local governments, the economic benefits are mainly reflected in: reducing a large number of financial subsidies, improving the competitiveness of residential development enterprises in the property market, making the development enterprises' properties sell well and accelerating capital turnover. At the same time, perfect property management can establish a good corporate image for developers and attract more real estate developers and consumers. In terms of environmental benefits, the environment, layout, public security and overall architectural style of residential areas are integrated, which improves the comprehensive benefits of the real estate industry. However, there are still the following problems in the practice of property management:

1. The property management structure is not perfect. At present, the primary problem of property management in China is the imperfect structure, and the system needs to be further straightened out and reconstructed. Among them, the relationship of responsibility, right and benefit among government, management committee and property management company needs to be further clarified. For example, there are three basic forms of housing property management in residential quarters built in Chengdu in recent years: one is managed by government real estate management departments, the other is managed by real estate developers, and the third is managed by property rights units themselves. These three property management modes each account for about 1/3. Moreover, many of them are biased in property management. Some property management enterprises ignore their own construction and regard property management only as a kind of charging service and simple production activities, so as to improve the level of enterprise development and professional management. There is no plan, no measures, no clear responsibility system for management objectives, no pressure and motivation for enterprises, no cost for management, and no accounting at the end of the year. They have countless ideas about which rules and regulations and management standards to establish, copying other people's rules and regulations and making them a mere formality.

2. The operation of supporting facilities is not ideal. At present, the investment and construction of residential areas are out of touch with property management, and there is no overall design and all-round operation from the whole process of property production, circulation and consumption. The operation of supporting facilities is not ideal, and property management lags behind housing consumption. There are few public facilities, shops, schools, banks and entertainment facilities, and these commercial outlets are still "in name only" for various reasons.

3. Maintenance is invalid. Once the residential area or office building fails, report to the property management company (such as elevator damage, water pipe leakage, switch damage, security door failure, wall ash, etc.). ), often can't be solved in time. The reason is that property management companies are powerless in these areas. They don't have all kinds of professional knowledge and necessary maintenance teams and facilities. Once they receive maintenance complaints, they can only report or apply for maintenance to other relevant units, which obviously does not meet the professional property management standards.

4. Property management funds are unsustainable. Property management, like construction, also needs capital investment. In property management, the principle of "who benefits, who invests" should be implemented to form the source of property management funds. However, the traditional concept of welfare housing consumption still has considerable inertia, and many families often understand property management as free service or low compensation service. This is contrary to the principle of residential consumption under the condition of socialist market economy, and it is also a major crux that affects the smooth development of property management.

5. The legal system of property management is not perfect. The national laws and regulations on residential property management are not perfect, such as property management system, property management funds, qualification examination of residential property management companies, acceptance and handover of residential property, etc. Other major issues of residential property management need to be further clarified. Therefore, it is difficult to bring property management into the track of legal management, and the standardization of property management in residential quarters lacks the fundamental guarantee of legal system.

6. The relationship between the property management company and relevant social parties is not smooth. Property management companies are closely related to streets, neighborhood committees, public security, transportation, environmental protection, health, municipal administration, gardens, education, public utilities, commerce, culture and entertainment. Because the scope of work is not clear and the relationship is not harmonious, it has become a prominent contradiction in residential property management.

7. Property management is not in place. At present, some property management companies do not take "property management" as the core, but focus on diversified operations, or are limited to rent collection and general maintenance, but fail to maintain the appearance, public parts and surrounding environment of buildings, actively maintain equipment and improve the use function and economic value of properties, not to mention special services. (VIII) Uneven development among regions. Provinces (cities, districts) declare participating in the national excellent management residential quarters, accounting for less than 30% of the total number of residential quarters in the country, and participating cities account for less than 1% of the cities in the country. Six provincial capital cities failed to participate in residential quarters. There are not only objective factors of the economic development difference between the North and the South, but also the tendency of the competent authorities to "emphasize construction and neglect management".

1.2.2 Problems and solutions in current research

The state should enact professional laws and regulations on property management as soon as possible, standardize the respective responsibilities, rights and interests of the government, owners' committees, property management companies, real estate developers and residents, further clarify the position and role of property management in the primary stage of socialism, provide a relaxed, open and fair competitive environment for property management companies, and make China's property management take a step forward on the track of socialization, specialization and enterprise management.

1. The state promulgated professional laws on property management as soon as possible. Property is a comprehensive economic behavior involving real estate, municipal administration, public security, industry and commerce, commerce, planning, communications and other departments. The authoritative and normative role of single departmental regulations in concrete implementation is limited, and the above-mentioned separate regulations also have various limitations. The country urgently needs to formulate a professional law to guide, standardize and constrain the property management behavior under the conditions of modern market economy, including the organization and operation of owners' committees, the identification and standardization of owners' conventions and housing use conventions, the qualification management of professional property companies, and the definition of the relationship between owners' committees, property companies and government functional departments.

2. Establish the system of owners' contract and owners' committee. The real estate administrative department should start this work as soon as possible. Buildings that have been built and put into use before can help to draw up a perfect and fair owner's contract (or house use convention), urge the owners to sign it, and further guide and assist the owners of buildings to set up a sound owners' committee organization. For buildings that have not been completed for sale, developers must be instructed and instructed to draw up the owners' convention before sale, so as to create the necessary conditions for future owners' independent management.

3. Strengthen the qualification management of property management companies. Real estate administrative departments should strictly manage the qualifications of property companies, implement the registration and licensing system, support market-oriented and socialized professional property management companies, guide professional property management companies to develop on a large scale, create economies of scale, and recommend outstanding property management companies to the owners' committee.

4. Set up institutions and standardize management. It is necessary for the state to set up a special property management organization to comprehensively manage the owners' committee, property management companies and developers by using some laws, regulations and policies formulated by the state and local governments, and to work out the labor quota for property management as soon as possible, so as to clearly identify the workload, material consumption and mechanical loss of various types of work of each property, so that the property can be selected in two ways in competition and unfair competition in the property industry can be prevented.

5. Implement the system of owners' committee management and independent choice of property companies. The selection of property management companies by the owners' committee has a direct supervision function on the service quality of property management companies and urges them to improve their comprehensive management level. On the other hand, the owners' committee and the owners' convention are also mandatory for internal members in paying management fees and observing order and morality.

6. Strengthen supervision and improve the level of property management. Government departments should supervise the maintenance, maintenance fees and greening maintenance fees paid by developers according to the relevant provisions of the state to ensure that they are in place in time and used scientifically and rationally. Owners' committees and real estate developers have the right to strictly supervise daily management, various expenses, maintenance of houses and public facilities and equipment, change the use of real estate and public facilities, and non-performance of property management contracts, management methods and regulations.

7. Strengthen management and establish brand.

8. Establish an incentive mechanism to promote the healthy development of the real estate industry.

1.2.3 Design objectives to be achieved by this project

Brief introduction of residential property management system

The emergence of residential property information management system is to meet the market demand that residential quarters are becoming the mainstream of contemporary social life. It is a management software developed for the management of residential quarters and the better maintenance of various property management businesses in residential quarters. According to the demand analysis, the community management business and various management functions can be realized.

For the property management center, it is necessary to consider the residents' application for repair, complaint feedback and processing results, parking lot management in the community, and various equipment maintenance. The management of residents' application for repair needs to carefully record the content of the application for repair, the reception personnel, date, maintenance personnel, expenses and the feedback of residents on the situation after repair. Complaint management needs to record the complainant's information, complaint content and handling process. Vehicles in the community should have parking space number, parking owner, parking space location and other records.

In terms of function:

1. Introduce buildings and apartment types.

2. Records of family and real estate information should be kept.

3. Record the rental and sale of buildings.

4. Property and equipment shall be registered.

5. Manage the household's water, electricity and gas payment, and handle the warranty.

Chapter II System Analysis

2. 1 system development background

In the era of manual operation, community management is very complicated, requiring a lot of manpower, material resources and financial resources, which greatly wastes the resources of community property. For community managers, property management includes property equipment management, instrument data management, parking lot management, household complaint management, household maintenance management, household equipment maintenance management and so on. In the past era of manual operation, these projects need to record these things manually, which is not only troublesome, but also often makes mistakes, which brings a lot of inconvenience to users. In order to better serve the residents, we decided to develop a residential property management system to help the residential managers to liberate themselves from the complicated property management.

2.2 Demand analysis of residential property management system

The residential property management system is a system developed by using computers for centralized management and used for all affairs in residential areas, including property management, data management and other business processing. The system is a residential property management system based on MDI form, which is connected with the ACCESS database through the JET engine of VB. Strive to combine with reality, with query and management functions, aiming to make the management and operation of the community tend to be computerized, more convenient and faster, and improve work efficiency.

It mainly includes three management modules:

1. Login to the system.

Manage the security of the system.

○ Add Users Set user names and passwords for new users of the system.

○ Change password is used for the operator to change his own system password.

2. Basic data management

This paper mainly introduces the basic information such as the number of households and real estate.

○ Household information introduces the basic information such as the name and work unit of the residents in the community.

○ Real estate information introduces some basic information such as room type and area of houses in the community.

3. Property management center, which manages the general business in the community;

Specific system functions are described as follows:

Manage maintenance services, complaints, parking lot and property equipment maintenance management, etc.

○ Property equipment maintenance management provides community facilities, equipment list, equipment maintenance registration and other information.

○ Electric meter data management provides data such as water meters and electric meters in the daily life of community residents.

○ Parking lot management records the vehicle position of residential users and parking users.

○ Charge management records data such as water and electricity fees paid by residents in their daily lives.

○ User complaint management records the complainant's information, complaint content and handling process.

○ User service management records information such as user service items and handling.

○ User maintenance management records the maintenance items and treatment of community users.

Chapter III System Design

3. 1 system function analysis

The residential property management system implements computerized management of residential properties, thus improving work efficiency and facilitating users. The main functions include managing property equipment, instrument data, parking lot, charging, maintenance, complaint and maintenance. As well as the management of basic data and the user rights of the system itself. Provide all kinds of information input, such as complainant information, complaint content, processing flow, etc.; Property repair, and can repair the property of the property company; It also includes the management of family and real estate information. The property management center not only contains the information of daily projects in the community, but also includes the statistical function of inquiry. The main task of system management is to improve system security and provide good maintenance for the system. For example, user rights can provide rights services for users.

3.2 System module design

This system is a residential property management system based on MDI form, which is developed by connecting VB JET engine with Access database. Strive to combine with reality, with the daily management and statistical functions of residential quarters, aiming at making the management and personnel of residential quarters more convenient and efficient, and improving work efficiency.

1. Login system management mainly includes:

Adding user module includes: setting user name and password for new users of the system.

Password modification module includes: for operators to modify their own system passwords.

2. Basic data management mainly includes:

Family information module includes: display add, modify and delete queries.

The real estate information module includes: display add, modify and delete queries.

3. Residential property management mainly includes:

Property equipment management module includes: display add, modify, delete query, etc.

Instrument data management module includes: display, add, modify, delete query, etc.

Parking management module includes: display add, modify, delete query, etc.

The charge management module includes: displaying queries such as adding, modifying and deleting.

Resident complaint management module includes: display, add, modify and delete queries, etc.

The user service management module includes: displaying added, modified and deleted queries.

The equipment maintenance management module includes: display add, modify, delete query, etc.

See or download the full text for reference.