access project

You are required to complete the Access relational database, by providing the following database functionality: a) A query of all orders that were cancelled by the customer, ordered by order date (customers can have more than one entry in the table). The query should show customer name, number of items ordered and order date. b) A query showing all the instances of late payment, together with the number of days late (customers can have more than one entry in the table), ordered by days late. Your query should show customer name and number of days late. c) A query of customers, ordered by the total number of items ordered (not the number of orders). Your query should show customer name and number of items ordered (only one entry for each customer). d) A query, ordered by value (one entry for each customer), showing the total value (purchase price) of all orders placed by that customer. The query should show, for each customer, the total value of the goods ordered, and the customer name.