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 must you change before you can reassign the DeptID field value for a particular employee in the query results? Departments (DeptID, DeptName)
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)
A)Set DeptID as the primary key field in the Employees table.
B)Add the DeptName field to the query.
C)Remove the EmpID field from the query.
D)Replace the DeptID field from the Departments table with the DeptID field from the Employees table.

Question

Quizplus · Accepted Answer

To reassign the DeptID field value for a particular employee in the query results, you need to ensure that the DeptID field being manipulated is the one that links the employee to their department, which is the DeptID field from the Employees table. The DeptID in the Departments table is used to identify departments, not to assign employees to departments.

A Query Includes the DeptID and DeptName Fields from the Departments