Field Properties

3. Try it: Review the Field Properties

Select a Field: HomePhone.

Look at the General Field Properties listed on the bottom of the Table.

 

What Do You See? The Design View has a robust set of Field Properties:

Field Size

Format

Input Mask

Caption

Default Value

Validation Rule

Validation Text

Required

Allow Zero Length

Indexed

Unicode Compression

IME Mode

IME Sentence Mode

Smart Tags

Text Align

 

What Else Else You See? The HomePhone is a Text Field. It is Required. Go on...

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View

Table Tools->Design