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.

Question

Quizplus · Accepted Answer

Since the DeptName is a field in the Departments table and is linked to multiple employees through the DeptID, changing the DeptName will affect all employees associated with that department.

A Query Includes the DeptID and DeptName Fields from the Departments