BUS 201 Final Take Home Test - Access Scenario: This data base is about a Pizza Restaurant which serves pizzas to customers. Customers lives in three areas. Pizzas are delivered and a tip is charged per pizza based on the area delivered to For this database, create 1) a PizzaOrder Table showing Customer D. Name, Address, Quantity Ordered and Price. Enter 6 entries 2) a PizzaDeliverer Table showing Deliveret's ID Name, Area delivery is made to. (use three areas only) 3. An AreaTable showing Area ID, Value of Tips for each area. Create a relationship between the Pizza Order Table and PizzaDeliveryTable and AreaTable. a Create a Parametric Query (Query=1) showing Pizza Deliverer D Name, Quantity Delivered, Price and Tips and Total Price (Use an equation to multiply quantity by price then add the tips to it). b. Create another query (Query#2) from Query#1 showing orders greater than three pizzas c. Prepare a Form for ordering pizza. d. Prepare a Report of pizza delivered and the revenue earned e Create a parametric Bill that shows the Customer D. Customer Name, Customer Address. Quantity of Pizzas bought and Bill amounts and Total Bill Amount, Create a Switchboard for the Pizza Data Base showing all forms and reports NB: NB: Please turn in a printed copy of your all queries, forms, reports, joined tables in design view and switchboard, together with a [Blackboard] copy of your database. BUS 201 Final Take Home Test - Access Scenario: This data base is about a Pizza Restaurant which serves pizzas to customers. Customers lives in three areas. Pizzas are delivered and a tip is charged per pizza based on the area delivered to For this database, create 1) a PizzaOrder Table showing Customer D. Name, Address, Quantity Ordered and Price. Enter 6 entries 2) a PizzaDeliverer Table showing Deliveret's ID Name, Area delivery is made to. (use three areas only) 3. An AreaTable showing Area ID, Value of Tips for each area. Create a relationship between the Pizza Order Table and PizzaDeliveryTable and AreaTable. a Create a Parametric Query (Query=1) showing Pizza Deliverer D Name, Quantity Delivered, Price and Tips and Total Price (Use an equation to multiply quantity by price then add the tips to it). b. Create another query (Query#2) from Query#1 showing orders greater than three pizzas c. Prepare a Form for ordering pizza. d. Prepare a Report of pizza delivered and the revenue earned e Create a parametric Bill that shows the Customer D. Customer Name, Customer Address. Quantity of Pizzas bought and Bill amounts and Total Bill Amount, Create a Switchboard for the Pizza Data Base showing all forms and reports NB: NB: Please turn in a printed copy of your all queries, forms, reports, joined tables in design view and switchboard, together with a [Blackboard] copy of your database
