• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  • Level: GCSE
  • Subject: ICT
  • Word count: 1823

Choice of Software for a game and video rental shop

Extracts from this document...

Introduction

Analyse Current Resources Mario's Game and Film Master's Rentals already have a computer with the following specification: * A Pentium III 600 MHz processor * Windows 98 operating system * 32 MB of RAM * A 10Gb hard disk with 4.6Gb of free space * A floppy disk drive and a CD-ROM Drive * It has MS Office 97 Standard. This has Word 97 and Excel 97, but does not have Access * Internet, but requiring a modem Mr Anderson is willing to spend up to �750 on new hardware and software. Choice of Software The database packages that I could use to set up the new system are PinPoint and Access 2000. I have Access 2000, but not Pinpoint, but Mr. Anderson is willing to buy this for me if I decide to use it to make the system. Mr. Anderson does not have these packages on their computer, but they are willing to spend up to �750 on new hardware and software. PinPoint offers the following features: * Data can easily be entered using on-screen questionnaires * Questionnaires can be designed and formatted easily and quickly * The database is built up automatically as the data is input * Queries to search the database can be made and can be saved * A wide variety of graphs and chart can be generated very quickly and easily * Data can be saved in a variety of file formats and used in other applications Access 2000 offers ...read more.

Middle

The computers at school and my PC at home all meet the minimum specification and have Windows Access 2000 installed. I am OK for printers because every computer room in school has a laser printer and I have a DeskJet printer at home. This means I have all the resources I need to set up the new system. Input Data will be input about members, items, and loans. This data will be input when: * A new member joins * An existing member's detail changes * A new item is bought * An item is rented * An item is rented * An item is returned * Members ask questions about videos This information will be input using. This information will be input using a keyboard and on-screen data entry forms. Processing Data will be processed when: � New member details need to be saved � Changes to an existing member's detail need to be saved � New item details need to be saved � Changes to an existing item's detail need to be saved � New loan details need to be saved, when an item is rented � New loan details need to be deleted, when an item is returned � Videos matching a member's enquiries must be found � Details of members with overdue items need to be found � Letters to members with overdue items need to be generated � Details of members who are over 40 need to be found � Letters to member ...read more.

Conclusion

* You can find all the items that are overdue * Find all items by Type (DVD, Video, Game) * Find all items by Type and category * Find all items by Type and category and certificate * Find all items by Type and Certificate. * Find out the people over 40. These will have reports made out of them. The Overdue query will have a Mail Merge function, which will allow to type a letter without having to write the address lots of time. These reports should be viewable on-screen, and should have and option to print them. Backup / Security Strategy The computer containing the final system must be backed up on the School Portal and CD every week I would have liked to use a floppy disk but there would not be enough space on it. The CD should be kept away from the computer, in case of theft, fire on flood. On Access there is security that enable one to create a password, and the database may only be opened once you have typed in the password. I will put this function on the system, so that people cannot find out details about other members. Only the employees should be told this password, and it should be changed regularly to stop people from going in to the database, if they know the password. ...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. Hardware & Software Requirements for Database

    This contrasts with storage mechanisms such as tapes, magnetic discs and optical discs, which rely on the physical movement of the recording medium or a reading head. In these devices, the movement takes longer than the data transfer, and the retrieval time varies depending on the physical location of the next item.

  2. Creating a computer system for a video rental shop

    It is also not immediately obvious when a date is overdue because there is so much writing on the forms and so you cannot always see an overdue video. Seeing how well the staff are doing. There is nothing in the old system that tells Abdullah how well his staff are doing.

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

    spent on maintaining and storing information and more time is spent on dealing with customers. It will also prevent Staff from overbooking rentals as the system will only allow rentals in stock. If a Staff has inserted a rent for a customer, a message will notify anyone who tries to

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

    Also it will remind staff if anyone has overdue games so we can send them a fine and ask them to return it a.s.a.p. The current system The Manager or the employees complete the basic functions of the store everyday.

  1. Introduction for a Software

    it is written on paper and lastly it is easier to organise and sort masses of information on computer. Sub Problems Mr Carrington, the Master in charge of football has asked me specifically to include these fields for Fixtures: Name of School, Master in Charge, Teams run, Term played, Address,

  2. I have been employed as an ICT consultant for DVD rentals, a business that ...

    Fine Currency Currency e.g. �7654.32 None - These cant be used in this field This field holds the amount of money owed for an overdue DVD. Categories Table: This table will be used to store all the available categories for the DVDs.

  1. Implementation of my database for Emma's DVD rental shop.

    Now my business is doing well and more members are joining everyday. A new business park is due to open shortly. And I expect that lots of people who work there will come and use my rental shop and come and hire them during there lunch break and take them home in the evenings.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    Input and output devices make up the hardware interface between a computer and the user or external world. In general, any sensor which monitors, scans for and accepts information from the external world can be considered an input device, whether or not the information is under the direct control of a user.

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