Open the Permanent Employees table in Design view and set SSN as the primary key field. Switch to Datasheet view, then save and close the table.

Make a copy of the Append Permanent Employees Table query and save it as Delete New Employees. Open the Delete New Employees query in Design view. Convert the append query to a delete query.

Modify the criteria to delete all employees from the New Employees table where the DateOfHire is $<10/1/2021.$ Run, save, and then close the query.

You want to determine how new employees are distributed by the type of degree they have earned. You will create a crosstab query that displays the count of HighestDegreeType for employees hired in June through December.

Use the query wizard to create a crosstab query based on the New Employees table that counts the total SSN by HighestDegreeType $($row heading$)$ and DateOfHire $($column heading$)$ by month intervals. Accept the query name as New Employees$\_$Crosstab.