Question: Open the RVS Employees database file created in assignment 1 1. Create a query using the tblEmployees table 1. Add the following fields to your
Open the RVS Employees database file created in assignment 1 1. Create a query using the tblEmployees table 1. Add the following fields to your query a. EmployeeID b. FirstName c. LastName d. Salary Marks: 15 2. Set the criteria to show employees whose salary is greater than $25,000. 3. Save the query as "qryMore_than_25" 2. Create a second query using the tblEmployees table 1. Add the following fields to your query a. EmployeeID b. FirstName c. LastName d. City e. Salary 2. Set the criteria that list only employees from a specific city (your choice) and whose salary is greater than $30,000. 3. Save the query as "qryState_Salary. 3. Create an employee report based on your "queryMore_than_25". Make any changes that you feel would improve the appearance of the report. Save the report as "rptMore_than_25". 4. Create a mailing label report for your employees based on tblEmployees table. Only include relevant fields in your report (i.e. name, address and zip fields). Save your report as "rptLabels
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
