• 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. Different types of technology How I use ICT at home and at school

    What Facebook essentially does is make you think you have a social life and makes you depend and become addicted to Facebook using this illusion of a social life. It becomes addictive, distractive and hard to stop using. It distracts and causes me to procrastinate on my work and causes

  2. GCSE Excel Project ICT

    appears around the cell which is referenced to in =IF(D4>0,VLOOKUP($D$4,Shells,2),""). In addition, whenever a reference (usually a cell reference) is preceded by '$' signs, it means that the cell encapsulated within them is locked and if the figure or the formula is moved the reference cell remains the same.

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

    be sold, that a car matching the customer's specific requirements may not be available. Buying cars off the internet makes This new method can reduce the cost of cars by nearly 30% compared with the tradition mass production methods. The car is only made to the customer's order so there is no stock piling of unsold cars .

  2. Free essay

    security issue

    In the computing world the Whitehat hacker is know as the good guy. Worm - Is a computer program which sends copies of its self to networks, designed to cause harm to the network that they have targeted.

  1. 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.

  2. 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.

  1. ICT helping someone with special needs

    In his social life he calls back to his town to ask if everyone is okay and every day from 3:30 pm to 4:50 pm he reads story to small children the age on 7 and under and sometime he reads his story too and in the library he sells his new and old books too.

  2. System requirements analysis

    in to protect the data on the computer from being lost or corrupted by foreign viruses. It is very useful as this means that viruses would protect the booking system and it will keep all the data on the system safe from corruption.

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