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

Introduction

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.

Middle

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.

Conclusion

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. This project is designed to help non-computerized library to easily keep track of their ...

    * There should be formulas in the system that can be used by the librarian for working out budget calculations. * There should be use of paper and pencils extensively and there should be vast amount of paper and pencils.

  1. ICT Report 2b: ICT in Organisations

    The most common liquid-crystal displays (LCDs) in use today rely on picture elements, or pixels, formed by liquid-crystal (LC) cells that change the polarisation direction of light passing through them in response to an electrical voltage. As the polarisation direction chang es, more or less of the light is able to pass through a polarising layer on the face of the display.

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

    The Beatle electric wheelchair offers high performance and excellent usability.' This is what allows Sarah to live and perform as naturally as possible in her condition. She works from home and the ability to manoeuvre in an eased manner is extremely helpful in allowing Sarah to go on with her daily life in a normal function.

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

    Field Name Data Type Field Size (Text/ Number Fields) Field Format (Date Fields) Validation/lookups/ combo boxes/input masks Rental ID Auto Number Long Integer None - These cant be used in this field Rental ID will be the primary key for this table. This field holds each rental's unique ID number.

  2. GCSE Database Project ICT

    Printed The information can be displayed in a hard copy printed format, as the secretary needs to print out a report for the mail merge information. Therefore, the secretary does the query for the patients due for a check up and prints out a report, which has all of the

  1. GCSE Excel Project ICT

    Printed The information can be displayed in a hard copy printed format, purely for Alex's purposes. So that it gets printed out, the customer then gives Alex the sheet, then Alex would charge correspondingly and put that piece of paper into his 'inbox' for manufacture.

  2. System requirements analysis

    The resolution is between 300 to 600 dots per inch and the cheapest ones are well under a �100 and also they are quite small. However they are quite slow printing 4 pages per minute and expensive to run. * Which output devices would you recommend and why (A01.54)

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