• 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

    Facebook has become a web of socialising. The need to socialise outside of the virtual world is eliminated and whether that causes a negative or positive effect on our current generation is shown directly by how it has affected me personally and my social life.

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

    But it's not just the chair; she also requires a stair lift to carry her on her chair. This takes more money and more electricity. Summary of advantages * Motor powered, much easier to use for Sarah * Easily manoeuvrable and user-friendly * Good support for staying upright * Adjustable/replaceable

  1. Ict Powerpoint Coursework

    The Samsung C31 printer is the best printer available. It takes laser ink cartridges which are pricey, the printer is also quite expensive, but everything is worth the quality and the outcome as this is one of the crucial pieces of hardware Mr Akram would need to sample his work etc...

  2. Database coursework

    * Needs basic math knowledge Paper and calculator This can be done if the company uses paper and pen as well as fillet cabinet. This alternative does not include that the company has a working computer system the company records data in papers sorted by name this data will be

  1. Database Coursework

    This would be different from the other methods, because you can be quite sure that the customer's feedback won't be biased and will be an honest remark about what they think. But on the other hand, the customers tend to talk about the bad service that they get rather than the cause.

  2. Designing a database for a supermarket. The current main problem is that the manager ...

    I'm being asked to create or to find some kind of solution to solve this major problem. There are many problems with the method that the employees are using now which is to go around checking each and every product for there date of expiry.

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

    Relationships: Because the database is a relational database the tables will be linked together. The Customer ID in the Customer details table will be linked to customer ID in the DVD rentals table. The reason is because you cannot enter a customer ID in the DVD rentals table, which doesn't exist in the Customer details table.

  2. Implementation of my database for Emma's DVD rental shop.

    Print membership cards. 6. Allow a quick search of member's details. 7. Hold the necessary details for 50,000 DVD'S and 2,000 members, to allow for expansion of the business.

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