Eccess

1) Create a form for product table you have in your DB and Save the Form as Product Form 2) Create a form for the query No_Discount which display all the order details where there is no discount. Save the form as No_Discount Form e i Protected View an internet location C14 3) Create a report for the query Ordered_Date which display all records of Order except that ordered on 7/10/1996 and save the report as ordered_Date_Report Dataset vx (Protected View] A 1 D 2 1 4) Create a report for the query Mayumi's which display the product name that supplied by Mayumi's and save it as Mayumi's_Report 3 4 4 5 102481 10248 10248 10249 10249 10250 2 1 S $14.00 $9.80 $34.80 $18,60 $12.40 $7.70 $42.40 $16.80 12 10 5 9 6 7 40 5) Create a macro that display two actions: First, display an informative MessageBox with the message "Welcome in Final Lab" and then open the form Product Form. Save the macro as Product_Macro 0.00% 5.00% 5.00% 0.00% 10,00% 0.00% 15.00% 15.00% 8 10250 3 10250 10 35 15 2 10 11 6) Create a macro that enables the user to close any table in the database and save the macro as Table Macro 12 13 14 15 I 16 17 18 19 20 22 23 DLL W C14 led out of ANSEWR ALL QUESTIONS (6 x 0.5 -3 Marks) Dataset vx Protected View) B c D 1 2 10248 1 Q1) Display the product name that supplied by Mayumi's and save it as Mayumi's. 3 10248 4 10218 12 10 5 9 2 S 10249 1 Q2) Find the total/sum of quantity in the order 10255 and save the query as Total_quantity. $14.00 $9.80 $34.80 $18.60 $42.40 $7.70 $42.40 $16.80 6 10249 5 0.00% 5.00% 5.00% 0.00% 10.00% 0.00% 15.00% 15.00% 40 7 10250 4 8 10250 3 Q3) Display all records of Order except that ordered on 7/10/1996 and save the query as ordered_Date. 10 35 15 9 10250 2. 10 11 (4) Create query Max_Units_Stock' to find the maximum units in the stock. 12 13 Q5) List the details of the product (Product_ID, Product Name, and Supplier) where Unit price is less than 20 and save it as Product_price. 14 15 16 17 18 Q6) Create query 'No_Discount' to find the Order details (Order_ID, Customer, and Order Date) where there is no Discount. 19 20 21 22 23 1) Create a form for product table you have in your DB and Save the Form as Product Form 2) Create a form for the query No_Discount which display all the order details where there is no discount. Save the form as No_Discount Form e i Protected View an internet location C14 3) Create a report for the query Ordered_Date which display all records of Order except that ordered on 7/10/1996 and save the report as ordered_Date_Report Dataset vx (Protected View] A 1 D 2 1 4) Create a report for the query Mayumi's which display the product name that supplied by Mayumi's and save it as Mayumi's_Report 3 4 4 5 102481 10248 10248 10249 10249 10250 2 1 S $14.00 $9.80 $34.80 $18,60 $12.40 $7.70 $42.40 $16.80 12 10 5 9 6 7 40 5) Create a macro that display two actions: First, display an informative MessageBox with the message "Welcome in Final Lab" and then open the form Product Form. Save the macro as Product_Macro 0.00% 5.00% 5.00% 0.00% 10,00% 0.00% 15.00% 15.00% 8 10250 3 10250 10 35 15 2 10 11 6) Create a macro that enables the user to close any table in the database and save the macro as Table Macro 12 13 14 15 I 16 17 18 19 20 22 23 DLL W C14 led out of ANSEWR ALL QUESTIONS (6 x 0.5 -3 Marks) Dataset vx Protected View) B c D 1 2 10248 1 Q1) Display the product name that supplied by Mayumi's and save it as Mayumi's. 3 10248 4 10218 12 10 5 9 2 S 10249 1 Q2) Find the total/sum of quantity in the order 10255 and save the query as Total_quantity. $14.00 $9.80 $34.80 $18.60 $42.40 $7.70 $42.40 $16.80 6 10249 5 0.00% 5.00% 5.00% 0.00% 10.00% 0.00% 15.00% 15.00% 40 7 10250 4 8 10250 3 Q3) Display all records of Order except that ordered on 7/10/1996 and save the query as ordered_Date. 10 35 15 9 10250 2. 10 11 (4) Create query Max_Units_Stock' to find the maximum units in the stock. 12 13 Q5) List the details of the product (Product_ID, Product Name, and Supplier) where Unit price is less than 20 and save it as Product_price. 14 15 16 17 18 Q6) Create query 'No_Discount' to find the Order details (Order_ID, Customer, and Order Date) where there is no Discount. 19 20 21 22 23