• 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

    The screen print below shows one such list box which brings up possible suggestions for peoples name titles. However if there was a duke the user simply has to type in the title and the system will accept it. This is shown below.

  1. IT system for local video store.

    Queries Required to Produce Reports The other queries that exist are the ones that are made to produce reports. All in all there will be 5 reports, so 5 queries will have to be made, these are all simple queries.

  2. ICT Coursework

    It is more better and beneficial than a flat-file database. Feasibility Study The computerised solution will reduce paperwork because all patient records will be stored on a computer system. All the data will be on a database. This will reduce the amount of files and filing cabinets.

  1. Benefits of using my IT system in the Travel Agents.

    Effects on Travel Agency Effects on Employees Effects on Customers 1. The new system will affect the travel agency because they will be able to advertise their company in various ways like making a website, leaflets and posters. 1.

  2. ICT notes

    * Small storage capacity - 1.44 megabytes. * Accessing data is slow * Being floppy it is easily damaged Optical Disks e.g. CDs DVDs * Direct access to the data. * Faster to access * CD-Rs only allow data to be written onto them only once The above list is

  1. Features of a sports club database. The system has at least 1 table and ...

    Action buttons and hyperlinks had also been put to side so that they won't appear on the printout. The user could also choose to save this record as PDF sending it via email. Fields had been separated into 4 parts; one for each day so that the player could easily indentify and find out about the information about that day.

  2. Design and create a computerized system that will assist Jack for his business as ...

    of Hard Disk space on my user account on the college Network Hard Drive. Windows 2000 and Office 2000 are already installed on this system. The development work will be carried out on the college network as well as my standalone PC at home.

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