Case Study related to the access test: CASE$16,$ Susan..

$1.)$ Create a list of products with the five largest expected daily demand. Indicate the name of the product and the expected daily demand! $(3$ point, Question $1)$

$2.)$ Calculate the expected daily production price of each product! Generate a report of the answer! Edit the report according to your taste! $(3$ point, Question$3)$

$3.)$ Create a query about all dressing type products. Indicate the products code, name, and price! $(2$ point, $7.$ Question query$)$

$4.)$ Create a new table. The name of the table should be Order. It should contain the following fields: OrderID field counter, primary key, Quantity field, byte, required, ProductID field, long integer, required! $(1$ point, Order table$)$

$5.)$ After solving question $5,$ use the lookup wizard and connect the Order and the Product table! Enable all integrity and cascade options! $(2$ point$)$