• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  • Level: GCSE
  • Subject: ICT
  • Word count: 4118

Green Associates is a seller of many games - design a computer based system

Extracts from this document...


Chapter 1: Identification General description of the task being undertaken A Mr. Green of Green Associates is a seller of many games, and at the moment archives all the information about the price of each game, the producer, and the genre using a pen and paper technique, which is to simply write on table in columns the information. This is tiresome and can be full of erroneous records as it is down to the human factor to make sure all data is correct, because of this it can be unreliable, it is not only tiresome to write all the information, but it also extremely hard to find a certain piece of information. The solution for this is obviously a computerized solution, which is to create a database in Access, which would allow for easy searching of data, and would allow for many other extra features, such as data validation which would prevent the entry of invalid data. Reasons for selecting the chosen approach A/B I have chosen to use Microsoft Access as it easily the most widespread database software in the world, and therefore the most compatible. It is extremely well suited for this as has many special features, in particular, I will be making use of Access's command buttons, to create a user friendly menu allowing the user to select different functions with ease. I will also be implementing data entry forms using Microsoft Access's "Forms" facility. Printing using Access is just as easy as the user must simply click on the print symbol in the toolbar. Possible alternative strategy for solving the problem B There are many other alternate strategies for solving this problem, for example, one could use Excel's table's and input data in a similar approach that Mr. Green is doing know, which is to write all the names of the other companies and their games, and prices, and update whenever necessary. ...read more.


Overall however I overall believe that the system will work, but needs to be easier to navigate in. Sincerely, Mr Green. Test plan Test No. 1 Item being tested Data Validation, this is used to prevent the user from typing in clearly erroneous data, this is used the entry of price, and checks to see if the user has typed a price between �4.99 and �39.99, if it isn't the computer will display an error message. Test Data �5.00, �4.99, �4.98 Reasons for choice of data. These will test that all data entered between the values is allowed, that data entered that is equal to the specified values is allowed and those that are outside the values are not. Expected result. Test 1: Allowed. Test 2: Allowed. Test 3 Disallowed + error message. Test No. 2 Item being tested. Price range query, this is used by the user to generate a list of games between a certain minimum and maximum price that he specifies. Test Data �6.99 - �12.99, �0.01 - �4.98. Reasons for choice of data. The first test will allow me to see whether it is showing the correct price range, and the second confirms this as the price range is below the data validation range, and therefore no games should appear. Expected Result 1st test: There should be a variety of games shown. 2nd test: There should be no games shown. Test No. 3 Item being Tested. Drop down menus in the forms. Test Data. To do this all we have to is attempt to add a new game to the database using the drop down menu, all this requires is a visual check. Reasons for choice of data. - Expected Result. It should allow the game to be added. Test No. 4 Item being Tested. The user should be able to specify a genre and the database should be able to display the games alphabetically. ...read more.


I am also pleased that it is enough for me to navigate in it without too much hassle. I am particularly pleased at the main menu you designed so that I would not have to use the usual access menus which are too confusing for me. The forms that you designed are also particularly useful with the added drop down menus. The report which shows all the out of stock items is particularly useful as it shows the addresses of the various developers of the game I am out of stock with so that I can phone them up and request more. However I would like a search function for developers, also new forms for films and applications would be good too. Sincerely, Mr. Green Response to customer feedback To create a search function for developers table would not be too difficult, I would have to create a new query similar to the one that searches for keywords in game titles and would display it. To create a new part of the database for films and applications it might be easier to create a new database altogether designed in the same way as the first but with differences such as data validation, which would have to change as some applications like visual basic cost a lot of money. Suggestions for further enhancements In a real situation this would probably only work for a small shop that doesn't stock many games, but in a large shop it would be extremely tedious to type in possible dozens of new games released every week, however it could be done by subscribing to a place that shows newly released games and importing that somehow into the database. The search functions for the model are also very refined in their parameters, for example there is not function to search for developers, for example, if Mr. Green wanted to look up a phone number for a developer he would have to search for it manually in the developers database, which would be extremely tedious. However on a small scale I believe that my model would work fairly well. ...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


    After my designed I realise both parent and summary report are the same. So I chose not to do it because it time consume. . There is a print, which is used to print the currently displayed report. The macro buttons and the list box are not printed.

  2. Creating a computer system for a video rental shop

    allows them to borrow and if the video is not in the library the member will make reservation. The library will send a notification to the borrower if he/she has not returned by the due date The library will hold the video once the other borrower has returned the video.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Making decisions Determine the feasibility (is it possible) of this new system, analysing potential solutions and makes a recommendation. A feasibility study shows: - nature of problem and overview of existing system - identifying problem - outline constraints (economical, cost vs. benefit; technical, technology requirements and demands; schedule, time wise; organisational, fitting the goal of organization)

  2. Database Design Guideline

    Form doctors form: Patient ID, ward and illness Query Design - this is what the 2nd query will look like in my Microsoft access database document: Field: Doctor ID Forename Surname Patients ID Ward Tables: doctors doctors doctors patient patient Sort: Show: ?

  1. Database design.

    Various methods of data modelling exist, each using a host of conventions and tools. The most popular approach is called the entity-relationship (ER) approach, developed by Peter Chen in the late 1970s. Although a number of authors and tool designers have modified and expanded ER concepts, most still have a strong Chen flavor.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    the ones where all the information can be edit and the others ones is where the user can enter new information without altering the information that is already store in the system, as we can see in picture 1.1 this form is the main form to enter new information and one of the commands is "edit existing information".

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    This tool can be used for when someone is renting out a game and you can easily enter their details. However Word does not have some of the crucial things needed in making the game rental service e.g. being able to check if a game is overdue and being able to import data.

  2. Benefits of using my IT system in the Travel Agents.

    Using Validation rules and text (gender) I am going to open Microsoft access then I will open a blank database and after that I will right click on table and click on design view. After that I will click on gender, additionally I will click on validation rule and type in ("MALE" Or "FEMALE").

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