Complete the following steps:

$(5$ pts$)$ Create a new field in Clients table named Client$\_$Phone.

$(5$ pts$)$ Set the Client$\_$Phone field to an appropriate data type and add a mask with symbols e$.$g$.(655)337-0776.$

$(5$ pts$)$ Make Client$\_$Phone a required field. Disregard any warning messages.

$(5$ pts$)$ Demonstrate that the field works correctly by adding a new record using your name in the ClientName field, AUM as the Street, and a sample phone number in the new Phone field e$.$g$.(123)456-7890.$

$(5$ pts$)$ In the Clients table, add a new field named Commercial. Assign this field a binary data type.

$(5$ pts$)$ Set the default value for the Commercial field to Yes.

$(5$ pts$)$ In the Clients table, add a new field named Service$\_$Years. Assign this field a number data type.

$(5$ pts$)$ For the Service$\_$Years field, set a validation rule that limits input values to less than $10.$

$(5$ pts$)$ For the Service$\_$Years field, if the user input is not less than $10,$ display $$Select a value less than $10.$

$(5$ pts$)$ Create a copy of the UnmatchedTasksquery. Name it UnmatchedTasks$\_$Your student ID $($e$.$g$.$ UnmatchedTasks$\_$jclaibo$1)$ and use this query for steps $11-14.$

$(5$ pts$)$ Add the ProjectID field from the ProjectLineItems table.

$(5$ pts$)$ Remove the existing criteria in theTaskID column.

$(5$ pts$)$ Limit the query results to those with a TaskID of $$CODE$04$ and ProjectID values less than $10.$

$(5$ pts$)$ Create a calculated field named Quantity$\_$Excess calculated by increasing the Quantity field by $50\%$

$(5$ pts$)$ Set the Navigation Pane to display the objects by Details.

$(5$ pts$)$ Set the Navigation Pane to sort by Name in descending order.

$(5$ pts$)$ Recreate the following data in Excel