A Query Includes the DeptID and DeptName Fields from the Departments

question 32

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.

---

Definitions:

Income Sharing

An arrangement where generated income is distributed among participants or partners, often in proportion to their investment or contribution.

Capital Balances

The amount of equity in a company or partnership owned by shareholders or partners, respectively.

Interest

The cost of borrowing money, typically expressed as a percentage of the principal, paid to the lender over a period of time.

Cash Investment

A financial contribution made in the form of cash, often to purchase securities, assets, or fund business operations.