Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Leading The Internal Audit Function

Authors: Lynn Fountain

1st Edition

0367568004, 9780367568009

More Books

Students also viewed these Accounting questions

Question

Discuss how to use job evaluation to build job structures.

Answered: 1 week ago

Question

Discuss why unions exist.

Answered: 1 week ago

Question

Discuss the alternative types of health care plans.

Answered: 1 week ago