• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  • Level: GCSE
  • Subject: ICT
  • Word count: 2464

An I.T. System for a Video Rental Store

Extracts from this document...


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.


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.


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. Video Rental Shop I.T. System

    So with the use of the computer I hope that will all be a thing of the past. Would you let customers use the system on the computer? I don't think so as it's going to be too inconvenient as the computer will be behind the counter.

  2. Spreadsheet Project - computer system for a video hire shop.

    > Another advantage that Excel has is a variety of graphs can be plotted. Jack Challis can use this software for a number of things. He can work out how much he earns weekly and how much profit he has made after expenses etc.

  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. ICT car insurance quotation System Coursework

    I added validation rules also to the Customer's addresses by adding a presence check, so an error message would appear if the cell were left blank. I did this by following the steps I did above for the other validation rules.

  1. Moviezone video rental system.

    Information about each video is written down on a card that is kept inside its case. Information about each member is written down on a card. These cards are stored in a card index box in ascending order of member number.

  2. Smarts Leisure Park Database Booking System

    it then comes up with all of the people on the database with that surname: Query Two - "qryBookings" Now I have created my first query I must now create my second. This query will show all of the bookings made by different people, what they booked, when they booked it and more.

  1. System requirements analysis

    Explain what each macro does and include a copy of the code. If your system design does not include macros, give a full explanation of your use of data validation and cell and worksheet protection. If you have used some alternative software (e.g.

  2. ICT Case Study Coursework - Hull Daily Mail Publications Ltd.

    If disk 2 was to fail now, the data which was on that disk can be calculated using the sum DISK 2 = DISK 4 - DISK 1 - DISK 2. This can be done and the system can easily run with one disk short, although the performance of the system would be considerable poor.

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