use MS Access 2007/2010 List all the rows and columns for the L_employees table. Add a new column that says “Old Timer” for any employee

use MS Access 2007/2010 List all the rows and columns for the L_employees table. Add a new column that says “Old Timer” for any employee that was hired before the year 2000 and is blank for all other employees. Sort this by the employee_id column. List the last name, first name, and hire date of all the people in the L_employees table.  Divide the hire date column into two columns: one called “old timers” for people hired before the year 2000, and one called “newer hires” for people hired after that year.  Sort the result table by the last name and then by first name. The word document you submit should include the following: SQL statement for the first part of the assignment, with a column to specify employees hired before 2000. Results for the first part, ordered by employee ID. SQL statement for the second part of the assignment, with an “Old Timers” column with the hire_date for employees hired before 2000, and a “New Hires” column with the hire_date for employees hired in 2000 or after. Results for the second part, ordered by last name and then first name

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer