• 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. 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. ICT car insurance quotation System Coursework

    I set up macro buttons to make it easier and quicker for the user to run the macros. I did this by selecting the button icon on the forms Toolbar at the bottom of the screen and then drawing the button on at an appropriate point on the worksheet.

  1. Explain the difference between primary and secondary sources of data, with examples.

    Quantitative data is all to do with numbers and statistics. This type of data is designed to collect al lot of it and then analyse so that conclusions can be drawn. Research methods, which are classed as quantitative, include questionnaires.

  2. Creating a computer system.

    The resource requirements * The company I am designing a system for have a Dell OptiPlex GX270 computer. It has an Intel Pentium 42.60GHz processor. There is 38GB of hard drive space left and 256MB of RAM memory. The operating system on this computer is Windows 2000.

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

  2. Smarts Leisure Park Database Booking System

    Processes Process One To extract a customer details query. I will extract all customer details from the Customer Details Table. To locate the correct customer I will enter [Please Enter Surname] in the criteria box of SName Field. Process Two To extract all of the booking details query. I will extract all of the booking details from the customer and activity data tables.

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