Field Properties: Required

Validation means the the right data is in the right place.  In Front Row Video, the customer's phone number is essential to our business. You can use the Table Tools to make a Field Required.

 

5. Try it: Review the Data Validation

Go to Table Tools ->Fields and review the Field Validation. The options include:

Required

Unique

Indexed

Validation

 

Try This: Make a Field Required

Select a Field: Home Phone 
Go to Table Tools ->Fields.

Go to Field Validation->Required.

 

What Do You See? Selecting Required changes the Field Property. Microsoft Access will prompt you to confirm, again.

 

Please click on Yes. Keep going...

Table Tools ->Fields->Field Validation->Required

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Data Validation