• 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 can collect this data from his sales book. All of the data and information that I need will be coming from Jack Challis. The methods I shall use are interviewing and shadowing. Implications of data types There are three different data types that can be entered into a spreadsheet.

  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. System administration report

    The important offices such as HRM and the ICT office all have door locks where only the employees of the hotel know the code and can access the room. They're some employees that were kidding around about the issue of security and were joking about a face scanner and retina scanner like in Mission Impossible.

  2. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    * Data can be easily updated or changed, changing all data in database. For example a booking change in a members records would change a booking in the tutors records, with only putting the data in once. I have fulfilled this requirement as I can do this.

  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 ...

    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.

  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. Benefits of using my IT system in the Travel Agents.

    Create template letter I will open Microsoft word then I will type whatever a letter needs then I will insert lines/dots where all the personal information goes. The template letter was created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes.

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