A Query Includes the DeptID and DeptName Fields from the Departments

Multiple Choice

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What happens when you update the DeptName field value for an employee? Departments (DeptID, DeptName)
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

A) Access displays an error message and does not accept the update.
B) The DeptName field value changes for all employees in that department.
C) The DeptName field value changes for that one employee only.
D) Access changes the DeptID field value in the same record.