Test plan 3
I will be testing on my drop down menu which I have set up for my instock in Internal product table. I would be if my lookup wizard works. I expect my drop menu should work when I select different values
Testing 3
In this screen shot I am checking if my menu works. The menu shows two values 0 and 1, 1 being instock and 0 being not Instock. So I will be selecting 0 in the drop down menu which means the stock would change to No. In the screen shot below the result have changes and I have achieved my expected result which means my lookup wizard works
Test plan 5
Now I would be carrying out my testing on my criteria which I have set upped. I will be adding a parameter value in the query managers title and then relating the result from the customer table. I expect that the result I get are correct
Testing 5
In the screen shot above I have opened the managers title query and inserted my parameter value Mrs. Then I hit enter my results could be seen below. My result show that 2 record in customers table now I need to be cross checking from the customers y results from my customer table
As seen before I have only two record in the query record I got only two record of mrs in the table as well which means that my parameter value works perfectly☺
Testing plan 6
Now I would be carrying out my testing on my criteria which I have set upped. I will be adding a parameter value in the query company’s Name and then I would be relating the result from the customer table. I expect that the results I get are correct
Testing 6
In the screen shot above I have opened the company’s name query and inserted my parameter value emirates. Then I hit enter my results could be seen below. My result shows that I have 1 record in customers table now with the name of emirates. I need to be cross checking from the customers y results from my customer table
Test plan 7
I would be carrying out a testing on a query that I made which was Price. I would be testing the result I get if they are correct or not
Testing 7
In this screen shot I have opened my price query. I have highlighted my criteria as these criteria would display the product which comes in this price range. After getting my result I would be cross referencing the result from the external product table, to check whether my query works or not
In this screen shot I am in my print view mode It shows that only to external product lie within the criteria. To check If my query works I have crossed referenced from the external product table and in the screen shot below it shows that only two products lie within the range
Testing plan 8
Now I would be carrying out my testing on my criteria which I have set upped. I will be adding a parameter value in the query external product delivery date and then relating the result from the customer table. I expect that the results I get are correct
Testing 8
In the screen shot above I have opened the external product delivery date query and inserted my parameter value. Then I hit enter my results could be seen below. My result show that 1 record in customers table now I need to be cross checking from the customers y results from my external table. I would be checking it from the external table as it would also display my relationship created
In this screen shot I have also checked my relationship and it also shows that emirates have only bought on product from external table
Test plan 10
In this testing I would be adding in a invalid data, this would show If added an invalid the system wont recognize the system. I expect that my parameter value displays no results
Testing 10
Here I have added an invalid data which was random characters and my result bleow displays no results which means that I have achieved my expected results which also means that my system works.
Testing plan 11
Now I would be carrying out my testing on my report and I would be seeing that the
Report parameter value works, I also need to change the title of the report from the design view
Testing 11
I have opened the my PIA product detail report, so when I double clicked the report the parameter value came up so I opened it by typing in PIA. My results are shown below
Know I would be editing the report firstly I am going to change the parameter value to emirates and also changing its heading as it was in the desired outcomes, My emirates records showed up which I knew from the previous testing it only had one record which can also be seen below
+-
In this screen shot I have changed the title to emirates product details the new report could be seen below.