I'm very new to access and taking a class currently to learn more however i'm stuck with the part with making a query and then adding extra stuff to it ill attach the file and the instructions that i have maybe someone can help or explain what its suppose to look like
Instructions
1. Use the Simple Query Wizard to create a query that will display the fields from the Employees, Employee Dates and Salaries, and Employee Benefits tables as follows:
Employees Employee Dates and Salaries Employee Benefits
Emp No Hire Date Life Insurance
FirstName Annual Salary
LastName
2. Accept the default Detail query and then key Salaries and Life Insurance as the title for the query. View the query results datasheet and then close the query.
3. Open the Salaries and Life Insurance query in Design view. Sort the query results by the LastName field in ascending order.
4. Add a criteria statement in the Annual Salary field that will extract the records of employees who earn more than $44,000.
5. Create a calculated field in the column after Life Insurance that will divide the Annual Salary column by 12 to display the monthly salary. Label the new column Monthly Salary.
6. Format the Monthly Salary column to display the calculated values in Currency format.
I think i got the query thing made but the part im not understanding are steps 4-5