• 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
  9. 9
    9
  • Level: GCSE
  • Subject: ICT
  • Word count: 3253

Database Coursework Identify the User's Needs. I have been asked to create a game rental service on the computer. It should be made so people who use it know what to do and it is clear.

Extracts from this document...

Introduction

The Identify By Arun Bir 9H 05/10/2010 Langley Grammar School GSCE ICT COURSEWORK - Database Project The Identify Introduction to the problem The name of the company I work for at the moment is "HMV". The person who owns the company is a man called Raj Bir. He works at the game rental office making sure that everything is satisfactory. The owner is known to me as he is an old school friend of my father. The company is a game rental service. They lend games out to customers for a small charge and fine them if they are overdue. The company I work for has existed for three years. The company is not a huge company; it's just not very small either. The rent we pay for the office we work at, where "HMV" is run proves to be a huge financial demand. The address is 2 Clifford gardens, Hayes, Middlesex, UB3 1NX. The company at present has seven employees, including the staff and the cleaners. The company has a reasonable amount of members although more finances would help them to expand this clientele. The company is successful; it brings in enough money to pay off all the employees and allows the manager to make a profit. It is just not as extensive as the manager has hoped yet. The company is a local game renting service providing members with all the latest and up to date games to rent. We have a variety of members from all from all ethnic communities and for this reason we have every genre of game there is. We make most of our money from our rental service, however we also make a bit from fining for overdue games. At the moment it is a very time consuming effort to run our game service. It currently takes about twice as long as needed and hopefully with shorter wait times we will get more customers. ...read more.

Middle

If we use a stronger one hopefully people won't be able to rip it off. However this will cost the company a lot more money to buy it. Non ICT Solution 2. A non ICT solution for storing the cards away is that you could store all of these documents in a closet or in a filing cabinet instead of the computers memory. The problem with this though is that it will take up a lot of space whereas if you keep it saved on the computer it wont take up much space at all. ICT Solution 1. An ICT solution for creating the Game Rental Service is that you create it on Microsoft word. Word specialises in inputting text, making tables and formatting it to make it look nice. It contains many tools like Mail Merge, Templates, and Fill-in fields with promote boxes, macro fill-in fields and an auto date. They also have basis features such as changing the colour and font of text, inserting word art and clip art, making tables, inserting shapes and having a spelling and grammar checker. A mail merge is useful for writing letters or invitations to people. All you have to do is write the letter you want and then type a list of recipients. The list of recipients is stored in your computer where you choose to save it. In the list you can put their details and whatever information about them you want. Once you have finished writing the letter and recipients list all you have to do is insert a field e.g. "firstname" and if you press preview results you can see the name you typed in the list. You can change the person by clicking an arrow on the toolbar. This is very useful as you only need to click an arrow to change the information instead of changing the text by deleting the old one and typing a new one in. ...read more.

Conclusion

These can be useful when navigating through the records. This will be helpful on the game issue form as they allow you to go through the records with ease. Filtering is used so you can choose how your table results appear e.g. having overdue games at the top of the list. This can be helpful as you can set the table out how you want it. End User Requirements The system should look very appealing to and it should be very easy for anybody to use. It should have a feature that works out automatically if anyone has an overdue game. Every document in the system should have the same house style. The system should have buttons in it that do certain commands. Once the button is clicked the command should be done straight away without the end user having to do anything else. There should be a charge used to calculate the fee for overdue games. The drop down menus should show the right information for its specific task. From the drop down menus when the membership or game number is picked or the rest of the appropriate details should appear. There needs to be a query made that has popup windows with commands e.g. type first name here. When you type it in it should be inserted into the document in the correct place. Objectives There needs to be a complex query which is made that shows who is overdue and that works. A report needs to be made based on the query to show overdue games and who is overdue. A game issue form needs to be made with combo boxes and command buttons that work. A parameter query needs to be made that works that uses post code to search for members There needs to be a charge field that works out a fee for overdue games. There needs to be three tables, one members table, one games table and one loans table. ?? ?? ?? ?? GCSE Coursework Spreadsheet Project Arun Bir 9H ...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. GCSE Excel Project ICT

    other fields, leaving the fields looking like this: Moreover, they are checked with the tables and sought to that they are correct. The buttons are then inserted which takes the customers to the relevant pages enabling them to make their choice.

  2. The use of ict has changed the way in which people work. Explain the ...

    effects drugs have on the body and in different doses .Instead of writing letters from local GP`s to consult doctors at hospitals they use NHSnet which transfers information between them. It connects computerised surgeries around the country which will link them to the hospitals and provides a fast and secure method of transferring data.

  1. Different types of technology How I use ICT at home and at school

    Facebook is also completely free to use, other than simply needing the internet. It can be accessed from a computer, a phone and many other things. It has become so popular to use that it has been made into lots of apps compatible with various technology.

  2. a level ict project

    by their surnames: * Macro Action is to be OpenQuery * The query name to select is Customer sort (last name) * The view should be set as Design * The data mode shall be set as Edit Macro design to ask the database to find jobs according to the

  1. Spreadsheet Project - computer system for a video hire shop.

    My findings are as follows: Test Name Test What? How? Test Data? Expected Outcome Actual Outcome Valid Membership Test that only numbers between 0 and 2000 can be input Inputting valid and invalid numbers and text 39 2930 horse 605 Allow input Validation error message Validation error message Allow input

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    Then adding both singles and doubles profit together to get an overall profit. To work out if I make an overall profit or loss I will add the total profit from the food and drink, plus the total takings from player entries.

  1. System requirements analysis

    - The receptionist will need to create something that wil store the patients records and also the appointments. - He/She will need to have the name, address, doctor, d.o.b, date of the app. - If there is a new patient the receptionist will need to make give them a paper based form.

  2. Creating a computer system for a video rental shop

    The ATX motherboard rotates the orientation of the board 90 degrees. This allows for a more efficient design, with disk drive cable connectors closer to the drive bays and the CPU closer to the power supply and cooling fan, an ATX motherboard is required to use the newest Intel processors.

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