Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Paterson Credit Union only offers loans with interest rates between and 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 but less than or equal to Create validation text for the InterestRate: Value must be between and no period Save the table and switch to Datasheet view. Change the InterestRate in the first record to The validation text appears. Press ESC to restore the original value. Close the Loans table.
You've made the PhoneNumber field required in the Customers table, but now you want to
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started