• 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: 2464

An I.T. System for a Video Rental Store

Extracts from this document...

Introduction

GCSE coursework Contents * Choice of Problem * Description of Problem * Investigation and Analysis of Problem * Specification of Solution * Design of Solution * Implementation of Solution: * Resources Required * Data Collection, Capture and Input * Data Verification and Validation * Output Format * Testing of Solution * Documentation of Solution * Evaluation of Solution Choice of Problem I live in large city called London. My Grandfather runs a video shop there under the name Video Rentals LTD. Has a large and varied amount of stock that he finds hard to keep track of. At the moment he employs a card index system but this has its limitations: * Cards often get misfiled meaning that extra time has to be spent refilling and amending lost data. * On average it takes 30 seconds to search for a record, at busy times this is too long. * The shop currently has about 150 customers, which means that to find a record it may take a long time, this will delay the time that it takes to sort through the records and therefore customers may not want to wait that long and may go to another shop. Description of Problem At my grandfathers video shop the current system involves filing all the information in a filing cabinet. This is a manual system as all the data is hand written. I believe that because of this the video shop needs a computerised system, which will make the database better. ...read more.

Middle

In order to run Access 97 and be able to perform a mail merge using Word, a minimum of a Pentium 133 system with 16Mb, wil be required. A faster processor may be needed if the system is going to appear slow in switching between screens and searching for records. When the system is up and running it will take up about 5Mb. The user has a Pentium 300 with 16Mb, which will be perfectly suitable, and similar machines are available for development work in my house at school. My Grandfather is familiar with Word and has good keyboard skills, so should have no problem in entering the data but may need help in doing some of the more complicated functions. In the future he would like to improve his knowledge of Access so that he can perform new queries and reports as the need arises. Data Collection, Capture and Input Three data input forms are needed: 1. Customer Details This form will be used for several purposes so it needs to be able to: * Add a new customer * Look through the current clients and see what videos they have hired. Validations will be performed automatically. The Member ID field will be an integer and letter field so that it is more personalised. Wherever possible default values will be inserted automatically (e.g. most customers are from Ludlow so the relevant fields will default to those values). ...read more.

Conclusion

If I look at my my evaluation crtitera I can say whether or not I have completeed them. * It should take less than thirty seconds to establish whether a customer is already on file (Query member search) DONE * It should be possible to go directly from the Customer Details form to the entry of a video that that customer has hired, without having to re-enter the customer's name, etc. (Relationships) DONE * Data entry should be as fast and as easy as possible, particularly as there are several hundred existing customers and videos to be entered when the system is first installed. (Data flow) DONE * It be able to show who has rented what video and when. (loan table) DONE * There must be provision for more than one video to be hired at once by the same person. IMCOMPLETE * The new system is required to provide the following information: * A list of all rentals that are overdue and need chasing. (Date due back query) DONE * It should be possible to send a standard letter to selected customers, using criteria mentioned above. (Mail merge) DONE * The user must be able to create new letters whenever needed and perform a mail merge to selected customers. (Mail merge wizard) DONE Seeing as I have completed nearly all of my evaluation points I believe that I can say that my database project is a complete success. . GCSE Short course I T James. Dow Page 4 ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    You can not change the font or the size and it does not have a spelling and grammar check. Text is very important in a leaflet as it tells you all the important points that the leaflet is advertising. We could use the desktop publishing program to create a good letter template.

  2. ICT PROJECT

    Test that student list box is updated To check that list box correctly updates when new student is added to student list New student should added to student list sheet and should appear in list box User form 2: Add new student Test and data used Purpose for test Expected result Results after testing 34.

  1. Creating a computer system for a video rental shop

    Quantitative 1. It should be possible to rent a video without referring to video or member input screens. 2. It should be possible to input new videos, staff members, and customers in less than thirty seconds. 3. It should be possible to provide reports in less than 60 seconds in

  2. I will design a new video database for the video shop that will also ...

    All the data on the system will be able to be printed off so that the video shop can have copies of it stored in separately in case the system goes down. It also allows them to print off the rental lists for each week and clear the rental list

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

    They also require the facility to produce ad-hoc reports. You need to use appropriate Data Analysis and Database Design Techniques to structure your data and build the database system. Notes must be made in all stages of the process from Analysis through to Implementation and Testing.

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    They walk over to the game and take the envelope out of the front case. Once this is done they chuck that envelope away so there is no proof that they did it. Then they walk out and if a staff member questions them they say that it is there

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

    It would have been easier if there were screenshots or images Additionally I think the user guide needs to show how to use colour when printing. Open word Click on start then I am going to click on all programs then I will click Microsoft office then finally I will click Microsoft word.

  2. Computer project Alevels

    When you click on the button "DAILY APPOINTMENTS" on the Main Menu the switchboard which contains the following forms appear as shown below. * DAILY APPOINTMENTS * DAILY APPOINTMENTS When you click on the button "DAILY APPOINTMENTS" on the form "DAILY APPOINTMENTS" which links to the screen shown below.

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