• 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. Financial Model to help organise the year eleven prom

    still appeared to be nothing, so now I had to find an efficient formula that would solve this. After thinking about this over a period of time, I came up with the idea of an "if" formula. (picture 4) This was proven to be efficient enough, so I could then

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

  2. ICT Report 2b: ICT in Organisations

    The advantage of CD ROMs for Boots is that they are larger than USB flash drives and are much harder to lose as they can be placed on CD holders (a rack or case where multiple CD's can be placed in pockets and stored together).

  1. Database Design Guideline

    That is how I would create a relationship between two tables however to see the relationship again I can always click on the save icon as before and it will illustrate the direct relationships that has been created. - This is the icon used to create a relationship witch is located on the top of the database toolbar.

  2. Database design.

    * To design an organised database. * To make user names and passwords for them. * I want to keep it secure so I won't let them have access to any options to be able to edit or delete the whole database. * I will try to keep a paperless shop.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    Like"*"&[enter member id]&"*" like"*"&[enter customer id]&"*" like"*"&[enter customer post code&"*" This is the user interface: TESTING REPORTS > DVDs REPORT This is preview of the report for all the DVDs on the store. The user must use the navigations buttons to move from record to record.

  2. Computer Studies Past paper definitions

    1 Generally, one mark per valid point. Two examples can gain two marks. (a) mouse pointing device/controls cursor input device allows user to select options from a menu used in windows environment uses buttons/scroll wheels(s)/touch pad [2] (b) search engine used on the Internet to locate web sites/web pages/other links based on input of certain key phrases/words [2] (c)

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