Course Solutions Uncategorized (Answered) : How would you write a Data Validation rule for a 7-digit phone number? Whole Number between 1111111 and 9999999 Text Length

(Answered) : How would you write a Data Validation rule for a 7-digit phone number? Whole Number between 1111111 and 9999999 Text Length

How would you write a Data Validation rule for a 7-digit phone number?

Whole Number between 1111111 and 9999999
Text Length = 7
List of all possible 7-digit numbers
Whole Number less than 9999999

Expert Answer


A validation rule of 1111111 and 9999999 will force entries to 7 digit.Hence First Option is the Correct Option

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

(Answered) : Which one of the following statements about packaging is TRUE? Select one: A. A package doesn’t have much promotion impact(Answered) : Which one of the following statements about packaging is TRUE? Select one: A. A package doesn’t have much promotion impact

Which one of the following statements about packaging is TRUE? Select one: A. A package doesn't have much promotion impact at retail stores. B. Better packaging almost always increases total distribution cost. C. A

Imagine Director Health Information Large Hospital Director Sit Various Institutions Wide Q34188109Imagine Director Health Information Large Hospital Director Sit Various Institutions Wide Q34188109

<p dir="ltr"><img src="https://media.cheggcdn.com/media%2Ffa8%2Ffa8ced42-66a3-443a-956d-873391459d40%2Fimage.png" alt="Evaluate, implement and manage electronic for clinical classificatior and coding Select two (2) applications/systems for clinical classification and coding (e.g., encoders, computer assisted coding (CAC), etc.) and