• 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. ICT notes

    Navigation (method of moving around the site) is important especially if the site is made up of several web pages. There are 3 main methods to of using navigation: 1.

  2. System requirements analysis

    with the software, you would have to contact a technician to sort out the problem. 3. MedicsElite(tm) (http://www.adsc.com/medicselite.asp) Here is an example of a successful American booking software that could be used by Howard health centre. It has many features, these include: (Quotes from website- http://www.adsc.com/me_details.asp)

  1. Creating a computer system for a video rental shop

    We found that every non-key attribute is functionally dependent on the unique identifier (Transaction number). So if we No the transaction number we can determine the Member ID and the borrowing date To check for the 2 NF. We found that every non-key attribute is functionally dependent on the unique identifier (transaction number).

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

    Others said the tables where a bit confusing and prefer to use forms. I have tried to make the forms as simple as possible and unlike the tables, which are found confusing. What improvements and Modifications I have made As a result of my testing, I have changed a few aspects of my design.

  1. task2-report-template 3

    Or "old" Must be either new or old Telephone number =11 Must be equal to 11 Price >200 And <1000 Must be between 200-1000 Order date >NOW Must be before the present day 3.1.2 Alternative Designs [2] After making changes Field Name Field Type Field Length Model Text String Brand

  2. ICT car insurance quotation System Coursework

    �Add VAT onto the final cost. (0.175*...) Output requirements: �Full quote details on screen and details are provided on multiply outputs. �Fully customised and professionally printed output with company logo and header. �The output will include all the personal details of the user. �The output will include which policy the user has selected.

  1. Creating a computer system.

    He keeps a note of the amount of stock and keeps it in a box, which also contains customer details. He then orders the stock by phoning his suppliers, or going to the Cash and Carry. The Input, Output and Processing of the Current System Routine Inputs Processes Outputs Entering customer details Entering customer details, (name, address and telephone number)

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

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