Start Access $2019.$ Download and open the file Access$\_01\_$Departments$\_$HW$.$accdb. Save the file as Last$\_$Access$\_01\_$SR$\_$Departments$\_$HW$.0$

$2$ Open the Employees table in Datasheet view. Change the ID field name to EmployeeID and its caption to Employee ID$.6$

$3$ In the second and third columns, insert the Name QuickStart fields. $12$

$4$ In the fourth column, add a field named DateHired with the Date & Time data type. $6$

$5$ In the fifth column, add a field named DeptID with the Short Text data type, a field size of $5.$ Save, and then close the table. $8$

$6$ Import the records contained in the Employees worksheet in the file Access$\_01\_$Employees$\_$HW$.$xlsx$.$ Append the data to the Employees table without saving import steps. $10$

$7$ In the Employees datasheet, set the column widths to Best Fit, and then sort by the DateHired column in ascending order. Filter the data sheet so that only records from the HR department display. $8$

$8$ For the datasheet, set the font size to $10$ and the font to Verdana. Use the Datasheet Formatting dialog box to set the cell effect to Raised, the background color to Automatic, and then gridline color to Blue, Accent $1.$ Save and close the table. $10$

$9$ Create a new table in Design view. Add a field named DeptID with the Short Text data type. Set the field as the table's primary key, the field size to $5,$ and the caption to Department ID$.$ Add a second field named Department with the Short Text data type, field size $50.$ Save the table with the name Departments. $14$

$10$ In the Departments table datasheet, enter the following records:

Department ID Department

BG Buildings and Grounds

CD Community Development

CI Capital Improvement

F$2$ Fire

HR Human Resources

PR Parks and Recreation

$12$

$11$ Set the Departments table column widths to Best Fit. Save and then close the table. $0$

$12$ Create a one$-$to$-$many relationship between the two tables using the DeptID field as the common field. Enforce referential integrity. $($Do not select the Cascading delete or update options.$)10$

$13$ Create a relationship report. Save the report as Relationship Report, and then close the report. $4$

$14$ Save and close any open objects. Close Last$\_$Access$\_01\_$SR$\_$Departments$\_$HW$.$accdb. Submit the file as directed by your instructor.