[go: up one dir, main page]
Scribd
Upload
58 views2 pages

Data Validation (Assignment 12)

Uploaded by

26397ramyakrishna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
58 views2 pages

Data Validation (Assignment 12)

Uploaded by

26397ramyakrishna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

VALIDATION SHEET

Consider yourself as a manager you need to send this sheet to employees


to gather data. For proper data collection validate the columns

Emp_Code Birthdate Salary UserID Region Area

1.Give validation to Emp_code so that the user can enter only between 1 to 1000 without decimal
2.Give validation to Birthdate so that the date after 2002 should not be accepted
3.Give validation to Salary so that the salary is between 25000-85000
4.Give validation to User_Id so that the userid is minimum 5 character long
5.Give validation to Region so that the user will select the region from list
6.Depending upon the region selected the user will get the respective Area
Region Details

East West North South


Kurla Andheri Virar Churchgate
Ghatkopar Santacruz Bhyander Nariman point
Vashi Vileparle Mira Road Colaba
Thane Khar Vasai Kalbadevi
Mulund Bandra NallasoparaMasjid Bunder
Chembur GogeshwariNaigaon Dockyard

Indirect()-Area

You might also like