Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

 

Data Validation

Data Validation compares what you type into a field and determines if it matches what you should enter.

 

For example, if the field asks for a date and you type "Michigan", there would be a mismatch.

 

Data validation compares data type (text or numbers), field size, and properties.

 

Try It: Build an Expression

1. Create a new Text field

Field Name: eMail.

Data Type: Text.

Go to Table Tools -> Design ->Builder.

 

Keep going....

 

Table Tools -> Design ->Builder

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.4.2.  Modify field properties: Set data validation rules