• 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

Design a computer system for a video hire shop.

Extracts from this document...

Introduction

I work for a video shop called 'Vinnie's Vid's' and he has been moaning about the files. He is complaining that he needs a better way to store files about the users, videos and who has what video on loan. I will make a database for each of the problems and connect them. I will collect the information about users and videos from Vinny. His current system is a paper and pen system, which is too slow and inefficient. It could be lost at any time with only the one copy he will have to start the records all over again. A PC based system is fast, accurate and good for presentations. He has asked me to create a database by using Microsoft Access Objectives: * Make a database, which can find a certain type of film in 30 seconds. * Make a database which can automatically show who has the rented videos. * Make a database which shows who has overdue videos and how much they owe Introduction Choice of Problem: I have noticed that keeping customer records on paper can be time consuming and neither practical or easy to use. ...read more.

Middle

203 Green Lanes N8 HFD 8292 4130 YES 20.01.02 Trees Lawn 08 Susan Croft 13 Durahm Road N11 9GJ 8340 4813 NO Vegatables Lawn Hedhe 09 Cherri Benn 98 South view road N13 9HY 8888 8182 YES 2.11.01 Trees Lawn 10 Microsoft Excel: * You can enter information into separate fields * You can get a print out. * You can collate some of your information into a pretty graph. * You can put some of your information into alphabetical order. * You can't query. * You can't carry out searches. * You can only enter data in one format. * It is not easy to add fields or records. * You can only look at it in one view. * It has limited features and is a spreadsheet program Microsoft access: * Easy to search for information * You can bring up one specific field * You can enter information into separate fields * You can get a print out. * You can sort the information. * It is easy to add fields or records. * You can look at the information in several views. * It is a database program with many useful database-making features. ...read more.

Conclusion

The database will have an encrypted modification password and it will be write-protected so it cannot be deleted. If a staff member needs to access the database to modify it, then a staff password is needed. It will not open until the password is correct Information Flow Error Checking To ensure that the information is correct the staff will send the members an invoice with their details they have inputted and attached is another form to fill in the correct information and then collect it and update the database. For the videos the staff will do daily checks on the database to see any obscure looking information in the database and will edit this info by getting the video and re-entering the video data again. Or the staff will do two copies of information identical to each other because the information will be inputted twice and if they are not identical then one or the other or both are changed with the correct information. Skills The user is a competent pc user and will not need any sort of training, he would like it to be user friendly though, so if any new staff join, it will be easy to pick up. ICT coursework 2. Database Project ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information 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 AS and A Level Management & Manipulation of Information essays

  1. Marked by a teacher

    Information Retrieval tools. I have used a database to carry out my searches. ...

    3 star(s)

    The strengths of Emerald are that it has reduced redundancy, which is great because nobody wants unnecessary data. This also prevents information overload. The weakness is that if the database is hacked or changed, it will affect the whole system .

  2. ICT coursework: Designing and implementing a book rental system

    The reason why I would say it is the best way is because it would solve Book Zone's problems. The disadvantage of this is that it is very expensive Book Zone might not be able to pay for it. I think that Book Zone would need a program such as

  1. Home Office LTD company. Database

    Moreover, the conditional formatting and validation of cells is programmed to work when a quantity remaining cell falls below three, as shown in screen shots above i.e.

  2. ICT Solutions for people with Special Needs.

    When researching for information regarding legislation I have discovered that I will need to put my focus upon the meaning of 'disability', as shown from above. Disability in the UK Facts and figures * There are approximately 8.7million disabled

  1. Designing a booking system for an Estate Agent.

    at the office of Herne Hill as this is the branch that I will be creating a bookings system for. The system is only for these internal users. My main contact for the client is Raj Tevari. He will be one of the users of the proposed booking system as

  2. Background and investigation for designing a database for a DVD rental shop.

    When an overdue DVD is returned they are charged �2.99 for each days the film is overdue. All in all the overdue process is overly inefficient and time consuming.

  1. Uses of ICT in Varndean

    They use Sage Instant Accounts software, which is used for purchase and sales ledger, bank reconciliation, which lets the company know how much money they have in their bank account. It also does a pay roll, which pays the employees their wages.

  2. Video World Database as ICT project.

    Software Video World's Applications Suite is the Microsoft Office 97 Professional, which includes Word 97, Excel 97, Access 97 and PowerPoint 97. The development will be performed at school using Access 97 as part of the total Office 97 Professional suite.

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