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

The estate agency Halletts is an experienced business in Thatcham and have not yet benefited from a computerised system. They are now looking for an efficient database system for all the houses for all the houses they have for sale.

Extracts from this document...

Introduction

Database Coursework Identify The estate agency Halletts is an experienced business in Thatcham and have not yet benefited from a computerised system. They are now looking for an efficient database system for all the houses for all the houses they have for sale. Estate agency though is not really that simple. To run the business successfully with a computer you need a minimum of three database systems, but ideally you need four. You need one system for the houses you currently have for sale. You need one for all the houses you have sold. You need another one for all the houses that have been taken off the market or put up for sale with another estate agency (these are called 'take offs'. You also (if you find it necessary) have a system for all the people on your mailing list. All this is too complicated for the project that I am doing, so I have decided to use one system for houses the agency have for sale and once they are sold, ideally they should be transferred onto another database but because I do not have another one, I will just take it off the system. The current system works by employees going to the houses for sale and taking down all the details of that particular house and writing it down on a particular form. ...read more.

Middle

The Data included in the system will be as follows. Data Type Characters Example House ID Counter Unlimited 01 **House Price Numeric Unlimited �250 000.00 Location Text Unlimited Cold Ash Vendor Last name Text Max 30 Smith Vendor first Name Text Max 15 John Vendor Tel number Numeric Max 15 01635 567483 Date put up for Sale Numeric Max 8 16/01/99 Property type Text No. Of rooms Numeric Max 2 14 *No. Of Bedrooms Numeric Max 2 05 *Number of bedrooms is put in so that the potential Buyer can tell the estate agent how many bedrooms he wants to have in his house. This information can then be entered into the search. **House Price is put in so that The potential Buyer can tell the estate agent the maximum price he wants to pay and this information can then be entered into the database search aswell. A suitable house can then be found In my system, collecting the data is collected and processed in the following way: 1. Employees go to the house for sale with a laptop and enter all the information into a form with the field names specified above. 2. The employee then returns to their headquarters in Newbury where the laptop is linked up to their network and then the loaded from the laptop onto their proper system. ...read more.

Conclusion

Have I met all the objectives set? Objective 1: To provide a quick and easy way to enter data about houses into the system, using tables and forms. * I have achieved this by setting up forms Objective 2: To use validation checks to make sure all data entered is valid, and limit errors * I have also created successful validation checks, such as number fields, and limiting the number of characters in each field. Objective 3: To present data in an organized way. * I have achieved this as well by using structured tables, forms, and a switchboard. Objective 4: To create a way of accessing data quickly and easily, using certain criteria. * I have achieved this by setting up queries using macros, and have also put this into the switchboard. This means houses can be found according to certain criteria, like price range. As you can see, I have met all the original objectives set by me and my end user. My end user suggested that one possible change could be to create reports. This would mean that hard copies can be printed off. He said that instead of having a separate system for brochures, we can use these reports as brochures. I then explained that we will need much more information on houses to be able to create that, like description, directions and size, if we wanted it to look like one of their current brochures. ...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. Marked by a teacher

    Unit 4 Business Studies

    4 star(s)

    goes into business, this would help raise awareness and you can place banners on roadsides or the place of business to give customers an example of what to expect of them. To advertise on their own website saves costs so in terms of money having a website as a internal

  2. The business I am going to set up is a snooker club,

    Advantages- 1 It can be used to compare returns on different projects 2 Identify how much profit will be made each year. 3 Are able to compare profitability with other projects. Disadvantages- 1 No account of the risk involved 2 Does not take into account of future value for money.

  1. Business Aims and Objectives.

    In an office, hazards such as boxes left in a passageway or files piled high on a rickety shelf can lead to accidents. Staff are expected to keep their work area tidy and are responsible for ensuring that hazards are dealt with promptly.

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

    Graphs ? I used this for 'Fees Paid' and 'Fees Not Paid'. This allowed me to see which was in the majority and minority. ? It presented my information in an interesting and simple way and it was easier to read information.

  1. This coursework that I intend on completing will be based around setting up a ...

    * Electricity - I have looked on the Internet and was provided with information for businesses about electricity provided by Swalec. Two bedroom flat �164 per year Typical 3 bedroom semi-detached or terraced �285 per year Typical 3 bedroom detached �405 per year I tried contacting Swalec but was unable to get a reply.

  2. AN UNDERSTANDING OF THE NERVOUS SYSTEM

    The space between two cells is known as the synaptic cleft. To cross the synaptic cleft requires the actions of neurotransmitters. Neurotransmitters are stored in small synaptic vessicles clustered at the tip of the axon. Synapses usually occur between the axon of a pre-synaptic neuron & a dendrite or cell body of a post-synaptic neuron.

  1. In this coursework I need to produce a detailed business report on one medium-sized ...

    This financial data can be used to determine and monitor total costs, revenues, profits and the achievement of business objectives for example, it will be possible to identify any fall-off in productivity or rise in labour costs which might contribute to arise in unit labour costs or to detect the

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

    * Video Surveillance System In some cases, Video Surveillance System (VSS) with a tiny video camera is installed somewhere in the ATM enclosure to take snapshots of activities inside the enclosure continuously. VSS basically consists of a VCR, camera and monitor.

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