Test NumberWhat are you testing?EvidenceDoes it work?Fixtures?(Yes/No)

1The first test I am doing is to check that the input mask for the order number is working and only allows the correct format. To test that it works I will enter an incorrect format to see if the input mask does not allow it. I also tried a correct format to make sure that it allows it.This does work as when I tried to enter the incorrect format it would not allow it however did allow the correct forma to be entered.No

2The second test I am doing is to check that the validation rule for the post code field works correctly and as expected. To do this I will attempt to enter an incorrect post code and then try to enter a correct one.When I entered a Post code it only allowed me to enter it in the correct format so this shows that it is working correctly.No

3The third test I am doing is to check that the Input Mask for CD Number on the product table works correctly and will only allow an entry that matches that certain format. To test this I will enter a correct format and an incorrect format to ensure that they both work.When entering the correct format this worked perfectly and it also didnt allow the incorrect format to be entered so this shows it works correctly.No

4The fourth test is to check that the field size for the first name field on the Orders table works correctly. This should only allow a first name to be entered that is equal to or below my chosen field size of 20. To test this I will attempt to enter more than 20 characters into that particular field.When I tested the First Name field I attempted to enter more than 20 characters however due to the correct fields size I was unable to do this. This shows that it works.No

5The fifth test I did was to check that the input mask for the Card Number field was working correctly. The input mask that I entered should only allow 12 numbers to be entered as this is the standard length and format for all card numbers. To test that this works I will attempt to enter a letter and also go over the field size limit of 12.When entering 12 numbers which is the format of a card number this worked correctly. I attempted to enter more than 12 which it would allow and it also didnt allow me to enter a letter so this shows that it works correctlyNo

6The sixth test I did was to check that the dropdown I created for the card type was working correctly. When creating a new record the user should have options of the card types the company takes to choose from rather than typing it in where errors could occur. To test this I will check that when creating a new record all the different card types are available to be selected.When I tried to create a new query I was able to use the dropdown box to select the card type. The dropdown box displayed all the correct card types that the company offers so this shows that this works correctly.No

7The seventh test I did was to check that my Artist query works correctly. When running the query a particular artist can be entered into the dialogue box and then the correct results should be shown. To test this I will enter a valid artist and ensure that the results shown match the parameters I entered. When I entered Lime Light into the dialogue and ran the query, the results shown were the ones that matched the parameters so this shows it is working.No

8The eighth test I did was to check that the card type query I created works correctly. When running the query a particular card type can be entered into the dialogue box and then the correct results should be shown. To test this I will enter a valid card type and ensure that the results shown match the parameters I entered. When I entered Vista into the dialogue and ran the query, the results shown were the ones that matched the parameters so this shows it is working.No

9The ninth test I did was to check that last name query I created works correctly. When running the query a customers last name can be entered into the dialogue box and then the correct results should be shown. To test this I will enter a valid Last Name and ensure that the results shown match the parameters I entered.When I entered Izzard into the dialogue and ran the query, the results shown were the ones that matched the parameters so this shows it is working.No

10The tenth test I did was to check that the report I created for Artist works correctly. When I run the report a dialogue box appears where an artists name can be entered and then the report will display all the records matching that particular set of parameters in a professional way. To test this I will enter an artists name and ensure that the results that are displayed match the particular parameters. When I entered Lime Light into the dialogue box and clicked ok the report displayed all the records that matched the parameters I entered. This shows that the report is working correctly.No

11The eleventh test I did was to check that the report I created for Card type works correctly. When I run the report a dialogue box appears where a particular card type can be entered and then the report will display all the records matching that particular set of parameters in a professional way. To test this I will enter a valid card type and ensure that the results that are displayed match the particular parameters.When I entered Vista into the dialogue box and clicked ok the report displayed all the records that matched the parameters I entered. This shows that the report is working correctly.No

12The final test I did was to check that the report I created for Last Names worked correctly. When I ran the report a dialogue box appears where a particular last name can be entered and then the report will display all the records matching that particular set of parameters in a professional way. To test this I will enter a customers last name and ensure that the results that are displayed match the particular parameters.When I entered Izzard into the dialogue box and clicked ok the report displayed all the records that matched the parameters I entered. This shows that the report is working correctly.No