• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20

Estate agent.I will be creating a system that will help my client to let all of the employees to have access to the database

Extracts from this document...

Introduction

Task Description Maurice Carter owns a small estate agent situated in Seven Kings. He owns 51% of the company and he has a silent partner who owns 35% of the business and takes 30% of the profits once all the bills have been paid. Mr Carter employs 4 employees' (Mr Patel, Mr Singh, Mrs Tsuchikawa and Miss Smith) who each take it in turn to take people to viewings and paper work. Each employee has houses that are his priority. As a new house is bought to the business it is given to an employee. Mr Carter works alongside the employee's and does the same job as each of them. To run their business they are required to keep the addresses of the property's that they need to sell, the addresses of the property's they need to rent, a list of property's that have been rented and who is currently living there and they need a list of which property is assigned to which employee. At any given time there must be at least 2 employees' in the office to man the phones. The person must take the details off the person and the details of the house they wish to sell/rent. Then it must be added to an employees' list of houses'. The list alternate's so everyone gets one in 5 houses going in alphabetical order. The information is just written down on a piece of paper, which is then left on the designated employees' desk. Each employee has a different way in which he or she then record the houses employed to them. Only the employee who has been given the detail's for the house then has access to the house details. In the current system if the sheet on which the detail is recorded is lost then they have no means of contacting the client. If the sheet is given to someone who has to many house's as it is then the customer may take his custom elsewhere as it takes to long. ...read more.

Middle

take photocopy's off details and writing the name of the designated employee on the corner but leaving a copy on each employee's desk. Or I could solve the problem by giving each employee a set way in which they must record their details. 2. I could make a spreadsheet based solution for the problems by: I could have a different book for each employee but for letting each employee being able to look at each book but on the same spreadsheet. 3. I could make a database solution for the problems by: Creating an entirely new system. I will be able to connect the fields and my employee's will be able to check any house's going in certain area's and in certain price ranges. I have chosen to do a database solution as my employee's will be able to search up in certain field's and everyone will have access to it and it will be in my view very effective and not be as time consuming. Specification In this section I will specify what I expect from my system. As the customer details are taken down while the customer is on the phone my system must be very easy to navigate. Also everyone should be able to choose where they want to go from the main menu easily and quickly.My employee should be able to add new clients in less than 2 minutes so the client will not get impatient. The system should also allow my user to be able to search for certain price ranges and certain house's in certain area's in under 3 minutes. My system should be secure and only employees; accountants and anyone that Mr Carter wishes to will be able to see it as the office will be locked when they are not there.. My outputs should be very clear and my employee's should be able to see clearly what they want and it should be easy to print. ...read more.

Conclusion

The highlighted row in this form will be deleted. Before After 4. Validated data. This is what happens when something wrong is done to the system. 5. Output. This is the output after an area search for Clayhall. Evaluation As the customer details are taken down while the customer is on the phone my system must be very easy to navigate. Also everyone should be able to choose where they want to go from the main menu easily and quickly.My employee should be able to add new clients in less than 2 minutes so the client will not get impatient. The system should also allow my user to be able to search for certain price ranges and certain house's in certain area's in under 3 minutes. My system should be secure and only employees; accountants and anyone that Mr Carter wishes to will be able to see it as the office will be locked when they are not there. My outputs should be very clear and my employee's should be able to see clearly what they want and it should be easy to print. This is what my specification consisted of. I have achieved everything from my system that is specified. The searches work especially well and accurately in my view and the only thing I can improve on is the colour design. Mr Carter had this to say about the system. Dear Mr Azam, Thank you for completing the system in the short time delegated and to such a high standard. We are especially grateful for the search's which will be a great asset and time saver and will make our business much more efficient. However the system is a bit dull and could do with a bit of colour. Apart from that we could not ask for anything more. Finally perhaps the system could have used a password to protect it but once again congratulations on a job well done. Yours faithfully Mr Carter. Rezwan Azam 10R Mr T.Chikomba I.t cw. ...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

  1. Evaluation of a database set up in microsoft access.

    font size, colour. It was easy to create the different fields because I could chose what information I wanted to insert in them. I could easily chose what I wanted other people to type into the fields as well, by setting up simple validation rules e.g.

  2. AN UNDERSTANDING OF THE NERVOUS SYSTEM

    brain is actually, potentially more dangerous because it could knock out coordination of the cerebrum's activities, or worse yet, automatic control of breathing and/or heart beat. The midbrain is responsible for receiving and integrating of information and sending/routing that information to other appropriate parts of the brain.

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

    The outcome of any project is never a foregone conclusion and project sponsors must understand that when they invest in a project they are, in effect, gambling. One of the few certainties about projects is that they will involve risk and because of this those risks need to be planned for and managed in a rational and methodical manner.

  2. How standard documents are presented. I have chosen six standard documents to analyze. Three ...

    All the information is in black, except the main title at the top of the page representing Vodafone's red and the headings over the page reflects this a well. Colour Scheme A simple black and red is used across the document as there is about 90% black to a small 10% red ratio.

  1. I will be comparing the difference between types of ownership and the industrial sector ...

    The success levels that BMW has achieved not only in Britain but also internationally helps to bring more consumer confidence for expenditure. The trends that I have elucidated also plays a major part for increased sales and more importantly their overall strategy for each year.

  2. Business Organisations - set questions and answers.

    This would help Laing homes know were to improve next time and how to do it, so the customer can be left leaving in a happy home. The development department then pass the house to the commercial department. 6.2 Question: An explanation of how each functional area helps in the

  1. E-commerce plan - I will be producing a plan report aimed at the management ...

    There is a market is growing market for holiday rentals the business takes 10% of the rent on every villa. The Price Brown Partnership have holiday rentals listed below are just some of the fabulous apartments and townhouses that they have available.

  2. Business c/w

    I will now list the different forms of marketing media available to Errol with examples of each in the form of spider diagrams. Errol only has a limited number of options for him to promote his new business. He has to keep in mind not to go too far with advertising and make sure he sticks to hid budget.

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