A$.$ Open the Relationships window. Create a join line between the Call Types and Calls tables, ensuring that you enforce referential integrity and cascade update related fields. Set a relationship between Reps and Calls and between Customers and Calls using the same options. Save and close the Relationships window.

B$.$ Create a multitable query, following the steps below:

$$Add the following fields $($in this order$)$: CallID $($from Calls$),$ Description $($from Call Types$),$ CompanyName $($from Customers$),$ and RepFirst and RepLast $($from Reps$).$

$$Run the query, and then modify it to add HoursLogged $($from Calls$).$

$$Sort the query by HoursLogged in ascending order. Set the criteria of $$the HoursLogged field to Is Not Null and run the query again.

$$Modify the criteria of $$the HoursLogged field to $>=5$ and the Description to Disaster Recovery, and the RepFirst to Barbara $($do not enter RepLast criterion$).$

$$Save the query as Complex Disaster Recovery Calls$\_$Barbara. Run and close the query.

C$.$ Create a copy of $$the $$Complex Disaster Recovery Calls$\_$Barbara query and modify it following the steps below:

$$Save the copy of $$the query as Complex Network Installation Calls$\_$Barbara.

$$Modify the query so that the description displays Barbara$$s network installation calls that logged between $5$ and $10$ hours.

$$Save$,$ run, and then close the query.