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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!