• 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

    In addition, on the sheets which have the unallocated buttons we allocate macros to them. The macro for selecting a product will look like this: Sub Seagate100() ' ' Seagate100 Macro ' ' Sheets("Sheet1").Select Range("D7").Select ActiveCell.FormulaR1C1 = "2" Range("D8").Select End Sub The macros purpose (in this case selecting the Seagate 100GB Hard Drive).

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

    Computers are used to assist in the training of doctors and nurses by being used to describe and show the different symptoms of diseases so that doctors can practice diagnosing the different illnesses . They also use this idea to help with training by showing on simulation software the different

  1. Free essay

    security issue

    Whitehat - Is the name given to a hacker, who's purpose is to prevent a breech of security within a company or organization. They are normally employed by a company to protect against there counterparts blackhat hackers who want to hack and steal information and data that does not belong to them.

  2. a level ict project

    be OpenQuery * The query name to select is Employee/Customer address search * The view should be set as Design * The data mode shall be set as Edit Macro design to find specific garage jobs: * Macro Action is to be OpenQuery * The query name to select is

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

    Allow input Validation error message Validation error message Allow input Valid Transaction 1 Test that only one of the transaction types can be input Inputting valid and invalid words Rental Elephant Food mushroom Allows input Does not allow input Allows input Does not allow input Allows input Does not allow

  2. Creating a computer system for a video rental shop

    This is board that hold the core components of a computer and connects them together. The CPU, graphics card, sound card, Hard drives all connect to the motherboard. ATX power Supply This is the power supply that powers the computer.

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

    The customised seat feature works a charm for this. If the seat does not match Sarah's needs, she can easily replace it to one that would suit her need. However, seats aren't the only adjustable feature. The backs, backrests, leg supports also co-operate with Sarah's needs as they are also completely adjustable.

  2. ICT car insurance quotation System Coursework

    It then displays the word which it has looked up. The If section of the formula, makes the cell blank when the Clearscreen macro is ran, instead of displaying #N/A =IF(E17="","",VLOOKUP(E17,Multipliers!A19:C20,2)) This formula below looks up the number in E19, and then looks up what number it represents in the Multipliers worksheet from cells A8:C15, in column 2.

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