• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 4386

The aim for this coursework is to design a new system for an estate agent called Mr Hall, who currently is the manager at Central Estate Agents.

Extracts from this document...

Introduction

GCSE COURSEWORK Name: Mohammed Hasnat Candidate number: 8081 Centre number: 14328 Subject: I.C.T Exam: December 2002 Contents Introduction: The client and the problem: Solution: An Access Database Plan Interview with Mr Hall Final solution Evaluation Report Introduction Introduction The aim for this coursework is to design a new system for an estate agent called Mr Hall, who currently is the manager at Central Estate Agents. The database will be designed to hold information about the properties such as number of bedrooms, garden size, price etc. Currently the company is using a filing cabinet to keep the current data, this takes up a lot of space and it is hard for the workers to access or amend the information. The company currently files all the information about the houses that are for sale or rent. They are all organised by the area that they are in. If any customer inquires about buying a house but doesn't specify the requirements are but sets other criteria then all the files have to be studied to find a house meeting the criteria set. If information about the area is given then it is a bit easier because only houses in that area have to be searched. Searching for the right houses can take hours because a lot of files have to be searched. House prices are constantly changing and it isn't possible for the company to manually change the prices for each house. When inquires for a house which has to be between a certain price range is made, many houses cannot be made available because the current price hasn't been updated and the latest price may be out of range. The company is losing a lot of business because it takes a long time to find the right properties for the buyers; the company also needs to employ many extra staff because excessive manual work is required. ...read more.

Middle

It is a meaningless total, but if it does not appear it means that not all the numbers/items on the invoice have been keyed in or a mistake has been made. Control total - is the same as hash total but with meaning. Character-type check - makes sure that I have correct types of characters have been entered. For example, if text is inserted for house number then the computer will inform the user and not let him carry on until the mistake has been corrected. Spell Check - This check will make sure that the words have been spelt correctly and the grammar is also right. Suggestions will be given if the words aren't right. Length check - This will inform me I have more or less characters than previously specified have been inserted onto the system. Validation is cheap and very quick because the computer does it, but it does not guarantee to find all errors. This will minimise errors and therefore is effective. All the mistakes will not be corrected because the computer only does what it has been told to look out for that is why a lot of validations should be used to completely minimise the number of mistakes made. VERIFICATION: I double-checked all the houses that are for sale and the correct price for it, and spell checked the addresses. Proof reading - the user reads the information again and compares the form and what has been entered onto the system. Re-typing - After the user has typed in the information another member of staff should come and type in the information, the data will only be processed if both entries are identical. It is unlikely that both people will make the same mistakes. The Re-typing method is expensive and time consuming but proof reading will be effective and easy to put into practice. Code Data - Data is often put into a code in a database, for example in the file above Y is used for yes and N for no. ...read more.

Conclusion

I will now go ahead with my final solution, to help my client to improve his business and his profession. This will help me to This The Database That I Have Created To Show Various Houses For Sale Reference Price Bedrooms Reception Garage Garden Area Address 1 �173,995.00 3 0 Yes Yes Epping Green 58 2 �189,995.00 3 0 Yes No Chigwell Row 2 3 �1,799,950.00 1 0 Yes Yes Loughton 5A 4 �8,500,000.00 7 3 Yes No Essex 21 5 �5,500,000.00 4 2 Yes Yes Loughton 32 6 �3,950,000.00 4 0 Yes No Burkhurst 56 7 �6,250,000.00 5 5 Yes Yes Housham Tye 57 8 �4,499,950.00 4 2 Yes No South Woodford 13 9 �464,995.00 4 3 No No Woodford green 99 10 �395,000.00 4 2 No Yes Russel RD 100 11 �2,750,000.00 3 2 No No Epping Green 65 12 �57,00,000.00 4 2 Yes No Chigwell 32 13 �1,360,000.00 2 1 Yes Yes Woodford Green 78 14 �1,225,000.00 5 3 Yes Yes Chingford 98 15 �4,560,000.00 5 2 No Yes Ilford 01 16 �234,786.00 9 4 Yes No Walthamstow 10 17 �669,995.00 5 2 Yes Yes Stratford 11 18 �996,995.00 6 4 Yes Yes Luton 54 19 �546,995.00 6 5 Yes Yes Walthamstow 87 20 �995,000.00 4 4 Yes No Chingford 89 21 �6,628,995.00 4 5 Yes No Manchester 14 22 �665,098.00 5 5 Yes Yes Birmingham 16 23 �995,000.00 5 4 Yes No Essex 19 24 �4,560,000.00 6 4 No Yes Walthamstow 23 25 �123,000.00 3 0 No Yes Walthamstow 69 26 �995,000.00 5 4 No Yes Chingford 35 27 �445,000.00 5 4 Yes Yes Walthamstow 6A 28 �486,995.00 4 9 Yes No Chingford 32 29 �995,995.00 5 6 Yes Yes Ilford 23 30 �452,000.00 6 2 Yes No Chingford 09 Screenshot of the Database in ACCESS As you can see above I have created a special screenshot showing how I have confronted my main task of this problem. I have used Microsoft ACCESS office XP, to show what the final product will look like in the latest program 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Peer reviewed

    Designing a database for Type a Flight Travel Agent.

    3 star(s)

    Create a letterhead and design letter templates I can do this task by hand using pen and paper but will not do it this way because it is time consuming and it will be a really tiring job. I can also do this task by using WordPad but will not

  2. ICT notes

    * Faster to access * Any problems with the hard drive may mean all data stored on it will be lost Floppy Disks * Small and portable * Data can be transferred easily between different computers. * Disks can be made read-only which will reduce the chances of data being accidentally overwritten.

  1. System requirements analysis

    accessed by Intranet or Internet/Intranet or Internet * Ability to have regular or irregular times on the one day * Protection of sensitive data is by 128 bit SSL encryption, Cisco firewall technology * No double bookings security feature * Option to connect Agents with rules-based access permissions, tracking and

  2. task2-report-template 3

    To allow software to communicate with the hardware. 2.3.3 Reasons for Choice of Hardware and Software [4] Hardware and software that being chosen Comparing with alternative software and hardware Laser printer I chose to use a laser printer instead of dot matrix printer because laser printers produce fast, high-quality print copies.

  1. Creating a computer system for a video rental shop

    * Routinely check for and update programmed threat detection tools as needed as well as train users in virus prevention and recognition techniques. Data integrity * Data integrity means, in part, that you can correctly and consistently navigate and manipulate the tables in the database.

  2. Database design.

    The employer always said that if he got a computer in again he wouldn't know much about the software or hardware to buy. Aims My aims are * To provide an easy to work database for the users. * To design an organised database.

  1. Performance Charts - The aim of this task is to produce a simple chart ...

    Once this is done, it must be manipulated so that only the essential data is left, and it is in manageable order. * To do this, the columns titled 'year' and 'race' can be deleted, as they are the same for all of the rows of figures, and therefore serve no purpose.

  2. The Design Brief - The company is a car hire company called Citicar.

    I made any improvements they though needed making and this feedback really helped me to improve my design. The people who tested the design all felt that a user guide was necessary. They didn't want a user guide that was too long because they said they didn't have the time.

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