Step to Open Microsoft Access and Create Table in Design View

Change View

Query Wizards

List Of All Field and Its Description

Input Mask :
A pattern for all data to be entered in this field

Caption :
The label for the field when used on a form. If you dont
enter a caption, the field name is used as the label.
F1 for help on captions.

Default Value :
A value that is automatically entered in this fields for
new records.

Validation Rule :
An expression that limits the values that can be entered
in the field. F1 for help on validation rules

Validation Text :
The error message that appears when you enter a value
prohibited by the validation rule. F1 for help on
validation text.

Required :
Require entry in this field?

Allow Zero Lenght :
Allow zero-length strings in this field?

Indexed :
An index speeds up searches and sorting on the field ,
buta may slow updates. Selecting "Yes- No Duplicates"
prohobits dupicate values in the field. F1 for help on
indexed fields.

Unicode Compression :
Allow unicode compression for this field?

IME Mode :
Which IME mode do you want ti set when the focus is moved
to the field?

IME Sentence Mode :
Which IME sentence mode do you want to set when the
is moved to the field?

Smart Tags :
Smart Tags to be applied to this field.

Text Align :
Alignment of text in control