Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: Add another employee to the list above and create a data validation rule or other procedure for each of the following for that employee:
Required: Add another employee to the list above and create a data validation rule or other procedure for each of the following for that employee: Be sure to add an appropriate and custom input message and/or error alert. \begin{tabular}{l|l|} \hline Field Check & Employee ID contains only numbers \\ \hline Size Check & Last Name cannot have more than 20 characters \\ \hline Validity Check & Pay type exists in a list of allowable values (salary or hourly) \\ Reasonableness Check & Hours worked allowed only if Pay type = "Hourly" \\ \hline Range Check & Hourly rate must be between $10 and $100 \\ Linit Check & Salary must be less than $10,000 \\ \hline Sign Check & Deductions must be a positive amount \end{tabular}
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