• 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


    38. Type Female into gender combo boxes instead of F Verify that only data currently in combo box can be entered Data should not be modified Test and data used Purpose for test Expected result Results after testing 39.

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

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

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

    PICTURE 1.1 The command "edit existing information" is where the information for the managers is stored. The reason for doing this is that only the manager will be able to edit any information that has already been stored in the system, so I achieve this by creating a username and password form and we can see in picture 1.2.

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

    In the case if a fire we will lose all our files and card as we have no backup. There is also a bit of crime that goes on in `HMV`. Some people come into shop with the intention of stealing a game.

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

    The work was saved successfully. I found it a bit problematic since this was the first time I saved a file. It would be easier if there were screenshots or images. Printing I am going to choose what I want to print then I am going to click on file then print.

  1. Computer project Alevels

    How to enter, edit, and save data. The following diagrams show the buttons used for navigating and editing data in a data entry form. When you open the system, the login form automatically appears as shown below. This requires your username and password.

  2. Producing a database and standard letters - difference between computerised and manual systems

    Create a letterhead and design letter templates I can do this by hand by writing different single templates and using a stamp for the letterhead. I can have different templates, which will make my work easier and saves space. It is very infuriating if one had to make a letterhead for each letter that he writes.

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