Testing for ICT A Coursework 2a

Authors Avatar

  1. TESTING        [TOTAL 7 MARKS]

  1. Describe the Testing        [4 marks]

  1. Evidence of Output Testing

Query     Test 1        [1-2]

This is a screenshot showing the design view of a normal query and shows what fields i am going to use and also more importantly the criteria to make the query.

These are the results of my query which show the exact information that i showed for which were games on Xbox 360. Because of this, their will be a small amount of data to show.

Test 2

This is the start of a multi table query that i am going to do. Which is basically a relational query and also shows me selecting fields from both tables so that a query that has significant fields can be done.

These are the results of my relational query or multi table query where i have tried to search for data that was in two different tables and showed me the correct information.

TEST 3

Here again this is my third query and my second normal one. Again it shows me using just one table but this time i also use three fields which are forename and surname and address in a certain town on the members table. This is so that i can get a certain type of data out from the system.

These are the results fron that query and the data again shows the exact fields and data that were required.

TEST 4

This is another multi table query or relational query which again shows me using two tables to get certain information. I have use the sales and employees table to link how many sales one employee makes.

This screenshot shows the results of the query and there a lot of fields with a lot of data due to the large amount of fields that were chosen.

TEST 5

This is my second last normal query and it is based on my sales table which shows me testing the query by searching for information such as the name of game and the quanitity sold which would have a certain value.

These are the results of my query and it shows again the exact information that i needed.

TEST 6

This is my last query in total and this may be the most important query of all as it will search for certain stock which may be important to the user so this would be very important. The query is searching for vital information such as the Stock ID- so the game can be identified, the name of game, quantity and Game ID.

These are the results of my query, which shows all the information that i have searched for.

Forms   Test 1

This is a screenshot showing my first user interface for my system which showed the data that was being entered for the game details datasheet. The form has two arrow buttons so that the user finds it easier to move one record to another.

Join now!

This is the actual datasheet for the game details table and it shows all the data being structured neatly so it can be shown easily on the user interface.

Test 2

This is the screenshot that shows my user interface  for my member details. These are important details as it allows the employees to get in touch with members for example to inform about a new game.

This is the actual datasheet for the members and as the datasheet has a lot of fields and records it is much more efficient to have a user interface ...

This is a preview of the whole essay