Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Name the imported table School. Note: Because of the way missing data are handled in the file being imported, there will be some import errors
Name the imported table "School." Note: Because of the way missing data are handled in the file being imported, there will be some "import" errors in the data. Provided that you have made the changes specified above, these import errors can be ignored safely. Modify the newly imported table as follows: a. Change the length of the state column to 2 characters. b. Change the length of the zip column to 5 characters. c. Change the length of the zip4 column to 4 characters. d. Change the length of the phone column to 10 characters. e. Add an input mask to the phone column for phone numbers
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