• 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. The purpose of this document is to define the Context of Cain Motors Information ...

    include: * Prevention - using counter measures * Reduction - reduce the likelihood of the risk * Transference - pass to a third party (insurance company or penalty clause) * Contingency - planned and organised to come into force as and when the risk occurs * Acceptance - Project Board

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

    They also have other ways to increase their revenue by offering home insurance, guarantee on much merchandise and the Internet banking system. FINANCE This may include wages of employees, waste, profit and even loses. It is very important for a business to regularly check all their financial information to see

  2. Tutor R Us - Creating an IT system.

    By using the interview technique, it allows me with a more one on one, face to face interaction with those who uses the existing system thus giving me more in right into how the system works. Fusing the interview and the questionnaire technique allows me to ask the precise questions,

  1. 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.

  2. Business Organisations - set questions and answers.

    This would be done by an architect, who has been hired to do the inside and outside of the house so that it looks attractive for the new owners. They are being told what to do by the customers wanting to buy the house, so that the house is done a specific way.

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

    * Shortening of the supply chain. * Possibility of global access to the website. * The location of the business will become unimportant to the customer. * Reduction in costs, due to removal of the need for premises. * E-commerce breaks down the barriers of market entry.

  2. Implementation of ATMS at SBI. Banks in India are looking at deploying biometric ATMs ...

    * * * * * ATM SWITCH CENTRE (ASC) * General ATM Switch Centre (ASC) is the hub of the ATM network of the Bank where various components of ATM Switch are set up. The ASC functions on a 24 x 7 basis. * Functions of ASC * Procurement of ATMs: All activities related to procurement of ATMs, such

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