number and account type must be entered. To do this you will set the PhoneNumber and AccountTxpe fields as required fields.

Open the Customers table in Design view. Set the PhoneNumber and AccountType fields to Required. Save and close the table.

$4$ Paterson Credit Union only offers loans with interest rates between $2\mathrm{.}0\%$ and $10\mathrm{.}25\%.$ To ensure that no loans are offered outside of those constraints you will add a validation rule that will not allow loans outside of that range to the InterestRate field in the Loans table.

Open the Loans table in Design view. Establish a validation rule for the InterestRate field that requires the value to be greater than or equal to $2\mathrm{.}0$ but less than or equal to $10\mathrm{.}25.$ Create validation text for the InterestRate: Value must be between $2$ and $10\mathrm{.}25($no period$).$ Save the table and switch to Datasheet view. Change the InterestRate in the first record to $1\mathrm{.}9.$ The validation text appears. Press ESC to restore the original value. Close the Loans table.

$5$ You've made the PhoneNumber field required in the Customers table, but now you want to

$16$

ensure that phone numbers are entered in a specific format. To do this you will add an input mask to the PhoneNumber field in the Customers table.

Open the Customers table in Design view. Add a phone number input mask for the PhoneNumber field, storing the symbols with the data.

$6$

You would like to easily add the account type for each customer without typing anything on

your keyboard. To do this you will turn the AccountType field into a Lookup Wizard using the AccountTypes table, that you recently created, as the source.

Change the Data Type of the AccountType field to Lookup Wizard. Use the AccountTypes table for the values in the lookup field, select the AccountTxpe field from the table, accept the default sort, accept default column widths, and then accept the default name AccountTxpe. Save the table. Switch to Datasheet view.

xt Predictions: On

Accessibility: Investigate

Solve the above