steps to slove this question using database

6. Calculate the total sales for each month (hint: find the invoice for each month and calculate the total amount of invoice for each month) Save all the queries and send me the Access file with the queries. (Save the file as DB Deliverable 2-Name) Question: (10 points) Use the DB-Deliverable 2.accdb database to complete the following tasks: 1. What are the Invoice and Sales Person for customer "Lcs Industries Inc." 2. What are the names and addresses of customers buying vanilla between 10/01/2017 to 12/31/2017 3. Calculate the total sales for each inventory item. 4. a. What are sales amount for each invoice? b. Based on the sales amount for each invoice, what are total sales amount for each employee? 5. What are the total sales for each customer? 6. Calculate the total sales for each month (hint: find the invoice for each month and calculate the total amount of invoice for each month) Save all the queries and send me the Access file with the queries. 6. Calculate the total sales for each month (hint: find the invoice for each month and calculate the total amount of invoice for each month) Save all the queries and send me the Access file with the queries. (Save the file as DB Deliverable 2-Name) Question: (10 points) Use the DB-Deliverable 2.accdb database to complete the following tasks: 1. What are the Invoice and Sales Person for customer "Lcs Industries Inc." 2. What are the names and addresses of customers buying vanilla between 10/01/2017 to 12/31/2017 3. Calculate the total sales for each inventory item. 4. a. What are sales amount for each invoice? b. Based on the sales amount for each invoice, what are total sales amount for each employee? 5. What are the total sales for each customer? 6. Calculate the total sales for each month (hint: find the invoice for each month and calculate the total amount of invoice for each month) Save all the queries and send me the Access file with the queries