• 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. Spreadsheet Project - computer system for a video hire shop.

    I shall use both of these books as the source of data collection. In addition to financial data, I shall be collecting data on the videos and members of the shop. Jack Challis would like clearer information concerning: which are the most popular videos, which videos have not been rented for some time, who his most frequent customers are etc.

  2. System requirements analysis

    They can also print continuous copies again and again. The disadvantages of having a dot matrix are that they have low resolution and they can be very low and they are very noisy as well and they cannot be used near a phone.

  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

    This illustration shows the customer worksheet, containing some filled in quotes suing the save quote macro: Setting up macros to get around my system: On the quotes worksheet, I set up macros, that would let the user access the groups worksheet, the multipliers worksheet, view saved quotes and a macro that will let the user print the quote off.

  1. Creating a computer system.

    The data from the invoice must be transferred to the database storing all invoices, at the click of a button, before a new invoice can be created 5. Products prices must be changed easily 6. Products and new stock must be added easily 7.

  2. Moviezone video rental system.

    The names of members with overdue videos are written down on a piece of paper and reminder cards are filled in and posted to them. The current system causes the following problems: � Members sometimes forget or lose their membership cards; � The video details cards often go missing from

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

    We also have problem with storage. Currently there are cards all over the place and they take up a lot of space. It is also a messy process and there is not a lot of organisation. Also all the members details are on printed papers and take up a lot space.

  2. Smarts Leisure Park Database Booking System

    I must decide how many forms that I need. I am going to have four forms. * Customer details * Activity details * Booking details (not included with customers) * Cancellation details. Processes Process One To extract a customer details query.

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