You have been hired by a local small manufacturing company to analyze employee compensation. There have been several complaints that employee salary and bonuses are completely arbitrary and not tied to their years of service, job title, or annual review score. You will analyze data by creating several queries to help substantiate or disprove the complaints. Create a Query with a Calculated Field
You will create a new query that returns each employee’s total compensation along with a total for all compensation.
a. Open the file Access_Problem1 and save it as Access_Problem1_LastFirst.
b. Create a new query named qryTotalCompensation that includes all fields (six fields totally) from tblCompensation
c. Add a new calculated field named Total Compensation, which is a total of Salary and Bonus
d. Set the format of the new field to Currency with One decimal place.
e. Add a new Total row to qryTotalCompensation query for the Salary, Bonus, and Total Compensation fields to find the sum of each field.