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

The owner is called Craig and he needs an ICT program that will keep accounts of the members and loans taken, and Books or Videos/DVDs which are overdue.

Extracts from this document...


PART ONE - Identify Statement Of Problem The owner is called Craig and he needs an ICT program that will keep accounts of the members and loans taken, and Books or Videos/DVDs which are overdue. The program should also include information on the members such as their names and addresses. It should use formulas so that it would be easier to type if they have paid for their hire or not. He should also be able to make charts on his profits of every Month. 1) To know all the books, DVD's and video that are on loan and those that are overdue. 2) To know ALL the videos that are on loan and the videos those are overdue. 3) To have something that will help him look at his profits each month to check he isn't falling behind. 4) A profit warning that will tell him to change things like prices to increase the money he is making. 5) To advertise his shop so that it will do well for his shop and attract more people. Possible Alternate Solutions Book Universe could solve their information-handling problem by employing more staff to keep hold of this information and to upgrade it whenever it is needed. ...read more.


It takes up less space 5. It has many functions 6. It is long-lasting 7. It will print out what is needed 8. Computers can work continuously 24 hours a day. 9. Less paperwork involved, it is all stored and easily accessible from the computer. 10. Low risk of data being erased as it can be stored on various backups. 11. Data can easily be presented in tables, graphs etc. 12. Changes and corrections can be performed at the touch of a button. 13. Validation check minimizes the chance of any errors. The most suitable type of application package will be a Microsoft Office 2000 package because: 1. It takes less room than a filing cabinet full of information 2. It can keep information in table or records 3. It does clear and accurate calculations 4. Information can easily be updated (e.g. if a members address or name has changed) 5. The worksheets can easily be accessible using buttons that link up to other worksheets in one file. 6. Can easily generate graphs and charts. User Requirements The user needs to specify the following requirements: 1. The system must show averages of the profits/ loses he is making each month. 2. The system should be able to calculate how much money the customer needs to pay. 3. ...read more.


done this you will have to add a primary key, in your case you will have to add one to the 'Membership Number' field. After this you will have to save and name the table and finally close it. You then have to click on the table you have just created and this screen will appear Here you just add the members details After you have created the Members table you close it. If you want to find out which person has over due items then you click on Queries which is here Then you click on Create query in Design View then this box will appear and you click on the Members Table and then close it. After this you just add all the fields you need. You will definitely need the fields 'Returned' and 'Date of item due in' Under the field 'Date item due in' first you type in < then type in the Date. This symbol < tells the computer to search for all the dates before today's date. You also type 'NO' under the field 'RETURNED' after you finish that you click on the run button Then this screen will appear: This table will show all the overdue items. You can send out letters to those people by simply using mail merging. ...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

    Access has disadvantages as well as advantages these include: - * Access is more sophisticated than Excel and is therefore harder to use for a novice. * Access is used by professional system designers who design systems for end users.

  2. ICT Report 2b: ICT in Organisations

    and the dot matrix printer (at the checkouts in the store that provide customers with a receipt). Boots need to on occasions provide a hard copy (touchable document) of information processed on the computer. A printout is almost always produced on paper, from which ink is affixed from a mechanical device that receives electronic prompts from the computer itself.

  1. GCSE Excel Project ICT

    'Xl0000000(1).xlsm' the fields update to the current selection (be it present or not). This is the result of opening the file whilst 'Xl0000000(1).xlsm' is open it updates the fields which is not what I wanted. Solution The only appropriate solution for this issue is to change the macro to change

  2. The impact of ICT on a person with special/particular needs

    It is propelled via an electric motor in contrast to using manual power. This is perfect for Sarah as she is unable to propel a manual wheelchair. The motorised wheelchair works just like a normal wheelchair except that it's not manually powered.

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

    This field holds each DVD's unique ID number. Date Out Date/Time General Date e.g. 01/01/2000 None - These cant be used in this field This field holds the date of when each DVD was rented out. Date Returned Date/Time General Date e.g.

  2. GCSE Database Project ICT

    as it would pull up people aged 12 to 21 this is the suggested age for children to have braces. Report The only report needed is the report for the secretary to tick of people who have rebooked. It consists of the patient's title, Patient's forename, patients surname and telephone number, as it only needs these fields.

  1. System requirements analysis

    The advantages of an ink jet printer are that they have a very good resolution and they are small and cheap to buy as well. The disadvantages of having an ink jet printer are that they are quite slow and the cartridges are expensive to buy.

  2. a level ict project

    A Graphical User Interface (GUI) would be most preferable; windows will contain information relevant to one particular task, enabling the user to multi task with numerous different windows simultaneously. Icons (pictures) will symbolise commands, for example, clicking on one may bring up a customer data entry form.

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