Question: Create a query using the tblEmployees table Add the following fields to your query a . EmployeeID b . FirstName c . LastName d .

Create a query using the tblEmployees table
Add the following fields to your query
a. EmployeeID
b. FirstName
c. LastName
d. Salary
Set the criteria to show employees whose salary is greater than $25,000.
Save the query as "qryMore_than_25"
Create a second query using the tblEmployees table
Add the following fields to your query
a. EmployeeID
b. FirstName
c. LastName
d. City
e. Salary
Set the criteria that list only employees from a specific city (your choice) and whose salary is greater than $30,000.
Save the query as "qryState_Salary.
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".
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".
 Create a query using the tblEmployees table Add the following fields

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 Databases Questions!