What sort of validation rule would you add to a Salary field with a Number data type? Why?
What will be an ideal response?
At the very least, a validation rule of >=0 would make sense since people cannot make a negative salary. If there is a maximum salary for the company (say, $150,000), you may want to consider Between 0 and 150000 to ensure it falls in the correct range.
You might also like to view...
____ is a format used with Microsoft products and associated clip art.
a. PNG b. TIF c. JPG d. Windows Metafile
A(n) ________ is a dynamic subset of a table that selects, sorts, and calculates records as specified in a query
Fill in the blank(s) with correct word
A(n) ________ can be used in or returned by a function to indicate the position of a value in a series
A) parameter B) serial number C) auto number D) index
The ____ protocol is nonproprietary and is a standard supported by the Internet Engineering Task Force.
TLS TSL SSL SLT