• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Creating a database of computer games.

Extracts from this document...


I.T. Coursework Project 1b I am creating a database of computer games. It is intended to both aid the customer in choosing which game to purchase, if any. It is also intended to aid the staff of the store by easily providing them with any information that they need for whatever reason (for example helping a customer with an enquiry). They have the problems of there being a lot of different computer games available on a number of different 'platforms' (different hardware systems), this means that it will either take a long time for a customer to search through all of the games available to them and to find the look of one that they like, or they cannot see all the games that are in stock, for instance there could be some in the stock room that they do not know about. These problems all currently exist in the shop and there is no way of customers to know the information they require, they just have to ask members of staff. This database will help them, as it will display all the games in the shop and the stock room. It will also display the rating given to the game by a reputable independent magazine for that format (CUBE in this case). It will also display a hyperlink to a review for the game, so that they can find out if the game is suitable to their tastes. ...read more.


I created a couple of input masks so that information could not be entered incorrectly; fig 1.2 displays an error that was displayed if you entered text in a numeric field. Another one was to just check all entries by proof reading them, both as I entered them and then reading through again after entering them. The second was to run a spell check, to pick up on any spelling anomalies and allow me to check the manually. This picked up on a couple of mistakes which I was able to edit (see fig 1.1 below). (fig 1.1) (fig 1.2) Whilst validating my information picked up a difference between the information entered in the table and that on my data capture form. This first shot shows it incorrectly I then changed the information so that the platform is show as "All" rather than "GC", as the game is available on all consoles, rather than being a GameCube exclusive. I created a number of different searches, these would be able to easily different customers questions as well as advising them on what games they are likely to enjoy. I created eight different queries. These allow me to set the system up so that a customer could quickly and easily find the information that they need. There are a number of similar searches which allow you to find the information by entering the information for one field, these allow ...read more.


I was not required to find out all the information for it as a lot of it was found in the Directory of CUBE (tm) or on different websites such as www.hmv.co.uk where I found information such as the RRP . This shot shows the RRP for a game called "legend of Zelda". Results This is the design for a complex search. It finds the game that suits you most by asking you a question about each criterion, and if you don't know them you can leave it blank. This allows you to search for a game by developer. This allows you to search for a game by the number of players it caters for. This allows you to search for a game by the platform it is available on. This allows for the staff to find out the price of the game by entering the name of the game and the platform it is on. This allows you to find all the games released by a certain publisher. This query allows you to find all the games in a certain genre. Using this query you can find out all the information for a game by entering its name. With this I can find all the games which have a certain rating. Or you can find all the games which have a rating starting in 0.9 (which would bring up all games scoring 90% or above). David Reed 10 Blue IT Coursework Project 1B Page 1 of 7 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. The business I have decided to set up is RCS (Reg's computer systems.) This ...

    Are you male or female? Male Female 2. Which age group do you come into? 16-20 21-30 31-40 41-50 51+ 3. What is your current income bracket per annum? <15,000 15,000-20,000 20,000-25,000 25,000-30,000 35,000< 4. Do you currently own a personal computer?

  2. Evaluation of a database set up in microsoft access.

    With reports I could easily designed the way they looked my going into design view. In this I had three sections, header, footer and main section. I could put information in all three sections. The results were automatically put into the main section.

  1. Apple Incorporation - Case Analysis

    The mode forces increases in need for being innovative. Innovation and competitiveness cost the companies a considerable amount of money that has a direct affect on the profits. Matters worsen as competitors cut costs when providing their products to market.

  2. Estate agent.I will be creating a system that will help my client to let ...

    different things so I may not interpret the answers the right way and mess up. Existing documents Advantages: You get to see how the business is doing in black and white. You can see whether or not the business is making a profit or a loss quite easily and you can see how their business affairs are being managed.

  1. Report for StGeorges School computer system

    42 Monitors �2200 Can be either CRT or TFT depending on budget and how much the organisation has available to spend or left to spend, depending upon other options considered earlier. 2 x 24 Port 10/100 Mb Layered Switch Cabinet �282 Connects all PC together on the network 50 x

  2. College admissions computer system

    If there are fewer students than it is required, the officer might have to admit students with lower grades. Secondly, the dropping- out rate and number of graduates are important to the feedback. It reflects the quality of the students and whether the strategy has been set correctly.

  1. Will a game shop in the UK be successful?

    I will use both primary and secondary for my research, because both of these types of research have advantages and disadvantages. The only way is to combine and compare them together to get the perfect results of what customers really want.

  2. For my Coursework I have looked at how Steve Edwards at Airbus UK uses ...

    It was easy to attach the questionnaire to the email. I used Email to send my survey to Airbus. I chose to use email as there are many advantages to it, such as: ( Using an email is cheaper than sending by post as you do not have to pay the postal fee.

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