How do I post the data base? It is the same from this question https://www.chegg.com/homework-help/questions-and-answers/8-use-accesspracticeaccdb-database-complete-following-tasks-access-q85189570

For each of the queries below, you may use Access QBE or SQL statements. Using QBE, you could use the expression builder to set up the calculations. Format the resulting amounts as currency, and create display totals for the query (to serve as a check figure).

2. Calculate the total sales for each customer (in dollars). Include CustomerID and CompanyName from the Customer table and the calculated sales amount from 3-Invoice Totals. Save this query as 8-Sales by Customer.
3. Generate an email user name for each employee using the first letter of the employee's first name and the first five letters from the employee's last name, e.g. Rod Smith => rsmith. Include EmployeeID, EmployeeFirstName, and EmployeeLastName in the query. Save this query as 9-Email Generator.
4. Determine which customers had the highest average sales amounts (average of all invoices for a customer). A sorted list will work for this. Save this query as 10-Customer Average Sales.
5. Employees earn a 5% commission on sales. Calculate the total commissions due to each employee. You might want to use two queries for this report. Save your final query as 11-Employee Commissions