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
Get step-by-step solutions from verified subject matter experts
