Saved uestion 33 (1.25 points) Sissy A query includes the DeptID and DeptName fields from the Departments table and the
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Saved uestion 33 (1.25 points) Sissy A query includes the DeptID and DeptName fields from the Departments table and the
Saved uestion 33 (1.25 points) Sissy 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) Comedy family Babyz Avna laddu a) Access changes the DeptID field value in the same record. Family buzzz welche b) The DeptName field value changes for all employees in that department. Srishti Srinivas PPM was join c) Access displays an error message and does not accept the update. Deepika UMD d) The DeptName field value changes for that one employee only. nhle and the EmployeeLast field from the DeptID field value
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!