Can someone add the formulas for the question thats all that is needed i believe Required: 1. Go to the Relationships screen and connect the 5 tables, enforcing referential integrity (to link the tables). (Hint: This was already done for you and you only need to check if the relationships have been established between the tables). 2. Calculate total sales for each customer. Include Customer ID and Company Name from the Customer Table and the calculated sale amount from the Sale_Amount_Calculation query. Name this query as Total_Customer_Sales. (Hint: you are to use the Salesitems table to find the calculated sale amount). 3. Generate an email username for each employee using the first letter of the employees first name and the first five letters of the employers last name, eg, Rod Smith => rsmith. Include Employee ID, Employee FirstName, and EmployeeLastName in the query. Name this query as Employee_Email_Generator. (Hint: Copy this expression/formula EmailUserName: Left([Employees]![EmployeeFirstName],1 & Left([Employees]![EmployeeLastName],5) to 6 your Builder). 4. Calculate the total sales for each month (Hint: watch the video and also go through the given handout). 5. Determine which customer had the highest average sales amount. (Hint: Use the Sale_Amount_Calculation query in task 2 to help you to process and finally, sort in descending order) 6. Assume the employees earn a 3.5% commission on sales. Calculate the total commission due to each employee. Use 2 queries to do these calculations. (Hint: First query find the total sales for each employee. Name this query as Employee_Total_Sales. Second query - Copy this expression/formula Commission: 0.035* [Employee_Total_Sales]![SumOfAmt] in your Builder)