Testing Tables
Black Box Testing
Test description Test Results (Expected) Test Results (Actual) Fix
Do all Tables,Queries, I expect all of All opened without a No fix required.
Forms and Reports Tables,Queries, Forms and problem.
open. Reports to Open.
Does the order form I expect it to be able to All orders had a No fix required.
calculate the cost of calculate the cost of all calculate total.
the order. orders.
Does the order form I expect it to charge for All orders had a No fix required.
charge for delivery if delivery on orders which delivery charge
the total is less than require it. applied when
£8. required.
Does editing I expect the data to update The data was not I had to fix the
information on forms in the tables. updating. relationships between the
change the information tables in order for the
in tables. information to update.
White Box Testing
Item to improve Suggestion How Notes/URL for tutorial
The suspended It would be better if all I could produce a new table which https://
feature. people who were stores the suspended customer support.office.com/en-
suspended were placed in a information however not have that ie/article/create-a-
different table and were
unable to place orders. table linked to the order form so table-8fdc65f9-8d40-
that customers in that table 4ff5-9212-
cannot make any orders. 80e6545e8d87
Adding more It would be better if there By using a random number https://
orders. was a larger amount of generator I could quickly fill the www.random.org/
orders in the database to table with new orders using the
see how it would run if it
was used by an actual random number to get the
business. product id and quantity amount.
Adding more In a usual business I could add more fields to the staff https://
information database there would be table which show more support.office.com/en-
about staff. more information about staff information about the staff such gb/article/add-a-field-
that needs to be stored.
as address or how long they’ve to-a-table-c4b7c90c-
been working at the company. c842-47be-8e2b-
b85f3546f6b0
Payment At the moment there is no I could add another table for
Information way to track the payment payment information which links
method used such as them to the order form.
paying by cash or card.
Importing/Exporting Data
The below screenshots show me importing data from an excel document into my access
Black Box Testing
Test description Test Results (Expected) Test Results (Actual) Fix
Do all Tables,Queries, I expect all of All opened without a No fix required.
Forms and Reports Tables,Queries, Forms and problem.
open. Reports to Open.
Does the order form I expect it to be able to All orders had a No fix required.
calculate the cost of calculate the cost of all calculate total.
the order. orders.
Does the order form I expect it to charge for All orders had a No fix required.
charge for delivery if delivery on orders which delivery charge
the total is less than require it. applied when
£8. required.
Does editing I expect the data to update The data was not I had to fix the
information on forms in the tables. updating. relationships between the
change the information tables in order for the
in tables. information to update.
White Box Testing
Item to improve Suggestion How Notes/URL for tutorial
The suspended It would be better if all I could produce a new table which https://
feature. people who were stores the suspended customer support.office.com/en-
suspended were placed in a information however not have that ie/article/create-a-
different table and were
unable to place orders. table linked to the order form so table-8fdc65f9-8d40-
that customers in that table 4ff5-9212-
cannot make any orders. 80e6545e8d87
Adding more It would be better if there By using a random number https://
orders. was a larger amount of generator I could quickly fill the www.random.org/
orders in the database to table with new orders using the
see how it would run if it
was used by an actual random number to get the
business. product id and quantity amount.
Adding more In a usual business I could add more fields to the staff https://
information database there would be table which show more support.office.com/en-
about staff. more information about staff information about the staff such gb/article/add-a-field-
that needs to be stored.
as address or how long they’ve to-a-table-c4b7c90c-
been working at the company. c842-47be-8e2b-
b85f3546f6b0
Payment At the moment there is no I could add another table for
Information way to track the payment payment information which links
method used such as them to the order form.
paying by cash or card.
Importing/Exporting Data
The below screenshots show me importing data from an excel document into my access
