In your client’s company, the Telephone Allowance is paid as per the grade of an employee. This information is stored in a User Defined Table. The Row is set as the Grade name and the Column Value is set as the applicable amount of the Telephone Allowance. Your client wants to validate that the value entered in the column Value is between 0 to 300 USD.
How would you configure this validation?
A. In the Table Structure window, set the Match Type of the table as Range. Choose the Rows button to go to the Rows window and specify the lower and upper boundary values as 0 and 300 respectively.
B. In the Table Structure window, set the Match Type of the table as Match. Choose the Rows button to go to the Rows window and specify the lower and upper boundary values as 0 and 300 respectively.
C. Create a Formula Validation to return an error if the Entry Value is greater than 300. In the Table Structure window choose the Columns button to go to the Columns window. Associate the Validation Formula with the appropriate ColumnName.
D. In the Table Structure window, select the Range Validation check box. Choose the Rows button to go to the Rows window and specify the lower and upper boundary values as 0 and 300 respectively.
E. Create an Independent Value set to have values from 0 to 300. In the Table Structure window choose the Columns button to go to the columns window.
Associate the Value Set with the appropriate Column Name.
|
Download Printable PDF. VALID exam to help you PASS. |
 |