• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

IT system for local video store.

Extracts from this document...

Introduction

Background Mans video store, is a video store run by the Man Group. They have recently purchased 5 more video stores in the London area and already have 3 more stores including the one in Staines. We are focusing on the store that is in Staines, Middlesex; it is situated in a parade, near to many residential areas and is quite close to the town centre. The man group has run these video stores for approximately 2 years and have found that the previous owners system was not a feasible system. The store in Staines, which we will specifically be focusing on, has a large customer base, and as always as the local population is ever increasing in the popular area, it is attracting more and more customer, with its customer base increasing every year. The store is open 7 days a week, and its opening times are 10 am to 10 pm on Monday to Saturday, and on Sunday they are 11am to 10 pm. Statement of the Problem to be Solved With its increasing customer the store has found that it has had trouble with the amount of data that has to be handled manually through paperwork, thus it requires a system that can hold all customer details, a system, which the store can view all titles currently held by the store, and where the store can track customers that have not returned their rented purchases by the due back date. Searches will also be needed to be made to find a customer and/or to find a particular title; this will do through the keyboard through a simple graphical menu. The required information will be output directly onto screen or paper, this is in order to lessen waiting times for customers, and to become more efficient by reducing the likelihood of costly errors occurring. Investigation Interview So that I will be able to understand more about the new system I have decided that I will carry out an interview, so that ...read more.

Middle

* To be able to store a particular title against a member's name, so you can easily track titles that have been taken out by a certain customer. * So that you can use a search to see what titles have not been brought back by a member, and thus then you can track the members details and send a letter if necessary or contact the member by phone by looking up his details * You can search for a customer enquiry about a particular title in the store and see if they actually do have the title or whether they are out of stock. * Reduce costly errors that occur by a member not bringing a film back, or files being lost, this cannot happen with a computerised system. * The manager must be able to produce reports through so that he can see for example which customer have overdue titles and what are the most popular rented out titles * The new system must have a facility where letters can be sent out to the customers that have overdue video's this can be done by having a template, and only the necessary details will be changed such as the customer's details and the particular titles. * A password must be on the system so that no unauthorised personnel can access it; there must also be the facility to change the password if necessary. * The system must be user friendly, so a graphical interface is necessary. Looking at the objectives it seems that a database package such as Microsoft Access will be the most viable option, however we must consider other solutions as well first lets look at Microsoft Access. The first viable option as mentioned before is the database system, such a system is Microsoft Access, which is a database program, first lets define a database; a database is a large collection of data stored together and organized for rapid search and retrieval, now Microsoft Access is a program that manages ...read more.

Conclusion

, I have decided that the fields marked (x) in show will be shown Field: Film Num Member Num Return Due Date Member: [Forename] & " " & [Surname] Date Returned Table: Order Details Order Details Order Details Movie Order Details Sort Ascending Show x x x x x Criteria: [Film Num] Is Null Or: Query Total Loans - This is so that the store manager can see the most popular films that are currently being taken out by members. The query counts each time the loans have been taken out and the results are put into descending order, so that the most popular films appear at the top. I have decided that the fields marked (x) in show will be shown. Field: Name Format "Total Loans": Member Num Table: Movie Order Details Order Details Total Group By Group By Count Sort Descending Show x x x Criteria: Or: Macros I have realised that for my update queries to work I will need to have some macro's that will actually run the update query this is because by default access sets up many warning parameters, this will mean that the user will be asked questions that they don't understand, so the macro will disable the parameter before the update query is ran and then will enable it after the update query has been run. Macro Loaned Copies Set warnings: Off - All warning parameters are disabled, to the user when the update query is run. Open Query - Update query copy loaned is run. The update query subtracts 1 from the films particular stock field held in the movie database. Set warnings: On - All warning parameters are switched back on. Macro Returned Copies Set warnings: Off - All warning parameters are disabled, to the user when the update query is run. Open Query - Update query copy returned is run. The update query adds 1 to the films particular stock field held in the movie database. Set warnings: On - All warning parameters are switched back on. Anup Bansal - 1 - IT COURSEWORK ...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. Creating a computer system for a video rental shop

    each of the following areas: * Videos rented * The staff that rented the videos out * Staff currently employed * Videos owned by the store * Customer details System the video shop is using now: They have files in a filing cabinet in alphabetical order of name and ID

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

    It also has to be easy to use so that people without much IT knowledge could also use it. Rentals have to be booked quickly but kept as accurate as possible at the same time whilst also preventing overbooking for rentals.

  1. ICT Coursework (MarcoS)

    This will help when you have to print the invoice copy for the customer, just choose to print only the selection, when you open the print options. Materials * In this worksheet you will be able to calculate the amounts spend on the materials the company need for built the buildings.

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

    This is costing the company a lot of money to pay for all these lost games. Sometimes when a staff member has messy hand writing then it is hard for anyone else use information that he/she has written down.

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

    Adding details I will choose the exact details I need from the database then I will right click it. After that I will click on copy then I will open my template letter then paste the details. The details were added to the letters successfully.

  2. I am now going to analyse my clients current system in order to get ...

    I am going to ask them all to take part in one-on-one interview, will ask them to participate in a questionnaire. This is because I will be able to figure out any problems as I will be using a range of techniques, and can find out how severe they are.

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

    Also you could think of the slogan as well. The advantage of this is that you can draw exactly the way you want it to be. The disadvantage is that it will not be as neat as it should be. Also it will be much cheaper to do it by hand than computer because you do not have to pay the bills.

  2. Database Coursework

    It's important to make sure that you have queries because without them, you'd have to go through all your records one by one and this could take a very long time. Printing reports: Also another useful function that's available when using access.

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