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

    Weekly food product sales figures * Expenditure and overheads At present, the rental and sales figures come from a sales book. When a video is rented or purchased, Jack Challis records the date, membership number, video number and amount paid in this book.

  2. I will be analysing the problems defined by the management in the old system ...

    Hence, I first interviewed Mr. Nathan Fernandez, the manager of the showroom. I also intended to find out what Mr. Fernandez intended with regard to the computerisation of the business. Q: How would you rate the current system that is being implemented in the branch?

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

    This results in customers being messed around as they have wait for longer periods of time than they should have to rent a movie. Requirements The end-user has made the following requirements for the system. * Faster than current manual system.

  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. Introduction to information skills and system. An information system is a system that accepts ...

    However it uses sequential memory access, which takes a lot of time. e.g. video tape. Good for back up. Magnetic disk works the same as magnetic tape, but with a circular piece of plastic/metal. E.g. hard disk / floppy disk.

  2. The aim of this project is to propose a possible solution for information handling ...

    Opportunity An introduction of a computer database system will solve the client's current problems. Database system can store vast amount of data, which can be accessed immediately and processed accurately without delay. By creating a system that is user orientated it will make it easier for the end-users to use

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