• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

An I.T. System for Estate Agents

Extracts from this document...


Introduction 1 Specification 1 Analysis 2 Design 3 Input 3 Storing 3 Processing 3 Output 3 Testing 3 Evaluation 3 Introduction I am going to be designing a system that will be used by estate agents. This system is being created so that it will make the estate agents job a lot easier and more organised. At the moment estates agents are using a paper-based system but I am going to change this to a computerised system as I think it will have more advantages for them. Estate agents have many different jobs, which they have to carry out but the way in which they are organised is not very efficient and I have found a few problems that need to be solved within the way that they are currently working. The main problem that I have found with the way that estate agents work is that the system that they are currently using is a paper based system, to solve this problem what I am going to do is design them a new system that will be created on computer. This will hopefully help them in a great deal and improve their way and quality of working. The different jobs that this system will help he estate agents to do is a number of different things including: * Searching for houses in certain areas and price ranges * Storing details on houses and customers * Collecting data * Mail merging letters to customers * Contacting solicitors through email * Giving quotes * Sorting mortgages and many more. Specification The new system that is being created for estate agents is going to improve their way of working by making them more organised so their jobs are quicker and easier for them to do. I have looked at the existing paper based system that the estate agents are currently using in detail and found all the problems that I think are necessary to change and also found solutions that I think will work appropriately. ...read more.


This is a list of the field names that will be used on the customer's table: * * ID Number * Title * Forename * Surname * Street * Town * County * Postcode * Phone Number * Mobile * Location * Upper Price * Lower Price * Off street parking * Value of their house * Other This is a list of the field names that will be used in the houses table: * * ID Number * Door Number * Street * Town * County * Postcode * Number of rooms * Number of bedrooms * Room sizes * Garden size * Type of house * Central heating * Double glazing * Date put on market * Extension/Conservatory * Fitted Kitchen * Fitted Wardrobes * Swimming Pool These are all the field names that will be used to create the forms, which show all the information about the customers and houses. Once I have chosen the relevant field names I will then choose the relevant data type that it is, this is needed so that the computer knows what type of thing you are talking about. The different data types include: * * Auto * Text * Number * Date/Time * Yes/No * Currency I will write notes about each field name in the notes section provided. The type of thing that I will write in this section will be validation rules, these are so you can make sure that the write information is always written in the correct place. The validation rules need to be used to help the estate agent fill in the correct information so that no mistakes are made. When the validation rules are entered into the computer it will prevent the estate agent from making any mistakes and stop the estate agent from entering any wrong information. For example when they type in the information to the field name 'title' there will be a validation rule which says the only thing that can be typed into that box is 'Mr' 'Mrs' 'Miss' or 'Ms'. ...read more.


I think I would have been able to produce something a lot better if I had more time to do it as I struggled to complete it properly in the time that I had to do it. I found this task very difficult and I found that it took me a long time to get to grips with it and to understand fully what was needed to be done. I think that if I had more time I would have been able to produce it better and I would have had a better understanding of the whole project. I think my work could have been of a better standard if I had more time but I think it is the best I could have done in the time that I had as I found it quite difficult. There are a few things that I'm sure that I haven't done properly or that I haven't done at all but I think I have done the most important things that I needed to do. Whilst doing this task I think I learnt quite a few new things about the program Microsoft Access, as I didn't really know much about it before doing this task. After looking back at my specification I can see that I completed most of the tasks that I set at the beginning, these are the tasks that I completed: * To store details on the houses for sale and the houses that have been sold. * To store details on vendors and buyers * To search for houses in a certain area * To search for houses in a certain price range * Create enquiry forms * Input various information * Access information The only tasks that I did not complete as I did not have enough time was: * To be able to contact vendors * To mail merge letters to customers. Apart from not completing these two tasks I am very pleased with my end result of the new system that I have created. ?? ?? ?? ?? 1 Rachel James ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays


    The sympathetic division of the PNS is also critically important in maintaining normal homeostasis and physiologic function, and in our response to the environmental and psychological variables that affect our lives.

  2. Business report on Marks and Spencer.

    In the case of a pilot they can be trained to deal with dangerous situations such as hazardous weather conditions with no real danger involved. However simulations can still not replace real experience. The previous text shows that the major advantages of computer-based training for employers are a reduction in cost and an increase in efficiency.

  1. The Entourage System: A Feasibility Study

    - Allows advanced functionality usage analysis by system Administrator. Email - Enables system based communication with attachments Facility to view Video Clips - Allows users to upload and view actor video clips Calendar - Allows users access to calendar functionality Scheduler - Allows users access to scheduler functionality Conclusions and Recommendations The implementation of an internet-based searchable database of

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    A computerised booking system will ensure that incoming work does not exceed the maximum that can be physically undertaken by staff, double booking will become a thing of the past as staff will be required to consult the booking system before making an appointment.

  1. Reform of the Justice System

    It is true that there are more informal hearings in the tribunals then in courts; in addition, most cases are heard in private. The procedure is also relatively flexible (one reason because there is no set precedent to follow) and the tribunals are not bound by strict rules of evidence.

  2. Analysis - ict cw project - estate agents

    It would be easier and much more effective as all information and contact details including types of properties etc can be viewed quicker. Microsoft Access would be the best way of doing this, as it would be the key to the database.

  1. Report for StGeorges School computer system

    Attendance Register The school uses both electronic and paper based registers to analyse and report on attendance this seems to be a waist of resources to the school and a waste of time for the secretary as the teaching staff will mark the register on paper and then the schools secretary enters this data into a database.

  2. Estate agent.I will be creating a system that will help my client to let ...

    You will get a wide range of answers. Disadvantages: As with questionnaire you answers depend on which question you ask. Also if lots of people talk at once you might not get what you want to know. Some people may be scared to voice their opinions.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work