Question: Create a new database called AccessLab Create a table with fields: Employee ID, First Name, Last Name, Address, Home Phone, Cell Phone Social Security Number,

Create a new database called AccessLab

Create a table with fields: Employee ID, First Name, Last Name, Address, Home Phone, Cell Phone Social Security Number, Date Hired, Title, Salary, email address and Department

Create a form named frmEmployees that you can use to enter in employee information.

Enter at least 8 records using your form.

Create a query that only lists employees whose salary is greater than $25,000

Save and name your query qryMore_than_25

Create another query that lists only employees from Virgina state and whose salary is greater than $30,000. Save the query qryMore_than_30_VA

Create an employee report based upon your qryMore_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 upon your employees tables.

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