• 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. Creating a computer system for a video rental shop

    This is better than fonts such as Algerian which although is fancy, is difficult to read. Forms Methods of Data Entry The user only needs to enter data into the database about the customer, parcel, destination and order. To make data entry easy I have written instructions for the user

  1. System requirements analysis

    This software adds and removes appointments very easily. The doctor can view the appointments page and will know who his/her patient is and prepare (if necessary) themselves. The doctor will also be aware of their break and will know how long to spend with the patients.

  2. Database design.

    * Show the employee how to send e-mail. * To make letter for the customers, mail merge. Explanation of the entities and attributes Entities An entity is a thing or object of importance about which data must be captured. All things aren't entities - only those about which information should be captured.

  1. I will be analysing the problems defined by the management in the old system ...

    * MS Access is a product of Microsoft(c) which is the biggest computer software giant. So the program is trustworthy as the program is designed for not one application but a huge field of applications. DATA COLLECTION Now that the computer is taken care of, I will have to decide how to collect the data needed for computerising the system.

  2. Ict coursework full

    Also, all mathematical problems are done automatically; allowing for reliable results, which means no more over-charged or under-charged customers. User requirements * The spreadsheet must be easy to use, and quick to find information, so that customers aren't waiting around for too long.

  1. ICT Report 2b: ICT in Organisations

    helps the suppliers because their individual sector in the warehouse can visually see what they need (rather than begin shown a monitor to their face, or having to read terrible handwriting which could lead to errors). Printers also help the staff because they do not need to handwrite the receipts

  2. GCSE ICT Coursework Booklet

    on its customers and advise them that their private details will be safe. * When the shop sends out promotional material by e-mail, it must ensure that recipients have agreed to receive this information, so that it is not classed as spam.

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