1. Create a Microsoft Access database that has two tables. · One table is employee information and contains the employee’s social security number, name, address, telephone, email address, job title code, hire date and salary. · The second table is job title information and contains job title code, job title, exempt or non-exempt status, minimum salary and maximum salary. Enter 10 employees and five job titles. 2. Write three SQL queries: · The first query joins two tables in the example database and uses BETWEEN to restrict record selection. · The second query joins two tables in the example database and uses LIKE to restrict record selection. · The third query uses UNION of two tables to produce a third table. · Print out each query and its results to a file 3. Using SQL, add 10 more employees to example database using SQL. · First, group employees by job code. · Then group employees by salary. · Then group employees by salary within job code. · Print out SQL statements and the results. 4. Using SQL: · Group employees by salary within job titles that are grouped into exempt and non-exempt. · Then use UNION to create a third table of employee names, job titles and salary. Print out SQL statements and the results to a file.. 5. Using SQL: · Calculate the average salary for exempt employees and the average salary for non-exempt employees. Print out SQL statements and the results to a file or report.
## Deliverables
Complete ownership and distribution copyrights to all work purchased. important: This project has 5 parts that should be saved independently as follow: part1 part 1 and 2 part 1,2,3 Part 1,2,3,4 Part 1,2,3,4,5 So I can understand the parts step by step. A brief explanation of how the project was built is needed. Thanks.
## Platform
Access 2000, Win 2000/98/xp