• 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
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  • Level: GCSE
  • Subject: ICT
  • Word count: 1941

Video Store ICT Investigation

Extracts from this document...


ICT Coursework Specification Identification of Problem A video rental store has been letting out videos for 2 years. At the moment the records are kept on paper. These records include, videos rented out, videos back in, members details and account details. The problem is that paperwork has been known to get lost and there is no way of recovering these details. Also it takes a lot of time to rent out and return the videos and searching the records for overdue videos takes a lot of time. Background Letters video rental is a small time shop in Howe Green; it consists of 2 owners and the business is steady. It is open 8am to 8pm. It is also a general store and it sells the basics of milk, bread etc. There was a need in the village for video rental as the residents did not like going to Chelmsford and therefore the business is expanding Statement of Problem Paperwork has been going missing gradually over the two years, at first this was not a problem but then they lost financial information, this has encouraged them to get a computer. The Current System and problems with the current system At the moment each member has a membership card, this membership card has their name and their member number on. When they go to hire out a video there number is put down on paper and the number of the hired video/DVD is put down beside there name. ...read more.


created Make A report rpt_reciept report is made along with qry_reciept Add records to tbl_member Added records to tbl_member Add records to tbl_borrowing This is tbl_member this table will hold the details of the members; the key field of the table is Member ID. The Field size for all text types is 20. Apart from Postal Code, the field size is 7 and its format is > this means all text entered will be in upper case. This is tbl_borrowing, all the details of what people have borrowed will be held in this table. It has to key fields DVD ID and Member ID This is tbl_dvd/video it will hold all the information of the DVD's i.e. name, age rating etc. The key field is DVD ID This is tbl_member_dvd/video this is a link table, the key fields a Member ID and DVD ID This is my relationships window, it shows the relationships between the tables, it also shows that referential integrity has been enforced. This is tbl_member this is showing that the data has been entered but is also showing erroneous data being rejected. This is tbl_dvd/video in datasheet view it shows all the data that has been entered Testing Module Testing Forms This is the main form, the first button of the form goes to the members form The buttons at the bottom of the page allow the user to go through the different record, add record and delete records. ...read more.


Be able to track how much money a person owes The table will show you how much each DVD costs and from this you can add up what they owe. But this could take time. Be able to rent out and return videos quickly This has been achieved, the borrowing form has been made as user friendly as possible, the user has to select the members ID and the Video they wish to borrow then the amount of days, and the computer will work out the rest, this is a very quick system. The only bad thing about this is that the current system only allows the user to hire out one video at the time. Be able to print out a list of overdue videos This can be done by looking at the videos hired out and the videos over due can be worked out from this. This could have been made easier for the user but it has not. Enhancements The first main enhancement I would make is being able to hire out more than one video at a time, as this a serious limitation. This is do-able. Another enhancement that I would make is making it easier to see what is over due and how much the person owes, this would make the system much more stress free for the user as at the end of the day the last thing the user wants to do is to work out if a video is overdue or not or how much a person owes, if this was all computerised there would be less room for error. ?? ?? ?? ?? 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. Different types of technology How I use ICT at home and at school

    It seems trustworthy as Sony is in charge and so, you feel safe about putting in your details and even your credit card details. This proved badly not too long ago as PSN was hacked and thousands of credit card details stolen and credit card fraud taking place.


    Entering data for form and gender is made quicker by the use of combo boxes. These save the user time because he does not have to type out the data. When the "OK" button is clicked on the user form unloads and the user is taken to the front-end menu,

  1. Creating a computer system for a video rental shop

    Connects the main 240V and converts it 16V. It powers components inside the case, such as the motherboard, hard drives, DVD drive, and floppy drive. Gold plated connectors provide perfect conduction. Also it is noiseless. Intel Pentium III 1GHZ Processor This is the main part of the computer.

  2. ICT Report 2b: ICT in Organisations

    is attached to an item. The tag is then deactivated, or taken from an active state where it will alarm an EAS system to an inactive state where it will not flag the alarm. If the tag is a hard, reusable tag, a detacher is used to remove it when a customer purchases the item it's attached to.

  1. GCSE ICT Coursework Write-up

    all you must do is click on the save button as indicated by the hand. Alternatively you can hold "control" and press "s". This will replace your originally saved document with the one that you are working on under the same name (the same in both Word and Excel).

  2. The impact of ICT on a person with special/particular needs

    Sarah's sister and carer helps set everything up for her, which is extremely easy to do thanks to the iPhone's user-friendly system. Sarah can then send calls by going to her address book by saying 'Contacts' and then saying the name of the contact she wants to call.

  1. Database Coursework

    This can be any length as it linked to the numbers customers. Title Text 4 Letters I have set this as Text and the customer can only enter text that is valid. This is only 4 Letters long as the longest title is only "Miss" which is four.

  2. I have been employed as an ICT consultant for DVD rentals, a business that ...

    Field Name Data Type Field Size (Text/ Number Fields) Field Format (Date Fields) Validation/lookups/ combo boxes/input masks Categories Text 50 Characters None - These cant be used in this field Categories will be the primary key for this table. This field holds all the categories for each DVD.

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