• 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
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  • Level: GCSE
  • Subject: ICT
  • Word count: 2472

Testing for ICT A Coursework 2a

Extracts from this document...

Introduction

1 TESTING [TOTAL 7 MARKS] 1.1 Describe the Testing [4 marks] 1.1.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. ...read more.

Middle

This should include: Labelled printouts of all error messages This is the validation rule that doesn't not allow the user to enter in data like the age that is under 18 for members. As you can see when i have entered in correct data no error message comes up saying the data typed is wrong. When i have entered in the data that is wrong against the validation rule that is set, a message comes up telling me the message i had customly put there which says age not valid. So this was wrong data. This validation rule is done on male and female t check that all the data entered in the Gender Column is either male or female and nothing else. It check to see if my data is correct. This is a screenshot that shows when the correct data has been entered, no error message comes up and the data is allowed. This is a screenshot that shows when the wrong data is entered into the Gender column, a error message comes up saying that the Gender is not recognized which is the own personal message that comes up. It tells me that the data is not valid. 1.1.3 Critical Feedback [4] Describe the Results [2 marks] 1.1.4 Expected Results [1] 1. Games that are on Xbox 360 By just looking visually at the data, i can expect to see at least 9 games that are on xbox 360 which are: correct Fifa ...read more.

Conclusion

The validation rule would only me to put data from above 5 so i decided to choose this data because it was an extreme value for checking if all games with quantity of 5 or above were listed there. Invalid Data: In the members table i entered in a value that wasn't value for the gender field like "man". I chose this value because it was invalid data and it should generate the error message which was set by the validation rule. Normal Data: In the members table, in the gender fields i entered a value that was either male or female. Seeing as my validation rules were primed only to accept male and female values, i expected the system to accept my data which it did. Invalid Data: In the employee table, i entered a text value in the age and because the age field only takes number data values, the error message came up saying the data entered was incorrect. Extreme Data: In the game table, a validation rules was set for games not to be higher then 35 in quantity, and when i entered this data because i wanted to see if this value was accepted, the system did accept it. Normal Data: When entering prices i entered just the 4 digits, e.g 40.00, as i set the data type to currency it would recognize and automatically change it, as it was normal data ?? ?? ?? ?? GCSE ICT - Coursework Task 2 Name: Ashley Koya ...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. Computer Systems Assignment 2

    You can print it off in advance of your journey and take it with you to refer to on the way. b) The hardware needed to use such websites and a sat nav system would be either a sat nav, or a phone with sat nav app or a

  2. Ict coursework full

    Data input When the a customer, or staff, wants information on an item sold by the store, a member of staff will use the keyboard to search for the information given to them (e.g. the item name). Once the information is found, all of it will be displayed to the member of staff that requested it; pricing, stock, brand .etc.

  1. User Documentation for ICT A Coursework 2a

    For instance you can click on any field and delete the information or overwrite it with new data that is required. It is very easy and you can do this for any field in any record in any table. The only exceptions are the ID of the tables which can be changed but then this will affect the whole system.

  2. ICT coursework, AO2cd

    Creating Switchboard: To create the switchboard, click forms from the left column, and then click create form in design view. Click the command button from the toolbox. Make a rectangle or any other shape using the command button. Click Cancel when this window appears.

  1. ICT Report 2b: ICT in Organisations

    With VDT technology and electric keyboards, the keyboard's keys could now send electronic impulses directly to the computer and save time. By the late 1970s and early '80s, all computers used electronic keyboards and VDTs. Nevertheless, the layout of the computer keyboard still owes its origin to the inventor of

  2. gcse ict unit 2a

    * To provide jobs and produce high quality goods to all people no matter what age, sex, religion and skin colour at affordable prices. Needs There are many challenges facing Asda and these include: * To further their global buying and selling * To create smaller Asda stores on high

  1. GCSE ICT Coursework Booklet

    The list of stock would be recorded by the tills sending a list of sales to the manager's computer; the manager will then re-order stock when he feels it is necessary. The list of customers will be recorded by taking down the customers details after each sale.

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

    It is also quite slow going up Sarah's long stairs. While this can be seen as an advantage due to the safety it provides, Sarah views it as a time waste as she is impatient and very conscious of the time she wastes every time she goes up and down the stairs.

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