Step Number 1

Select Tables from the Objects Panel. Right Click on the table and select Design View.

Step Number 2

Now the table should be opened in Design View.

Step Number 3

Select the field whose properties you want to modify. In the General tab select either Yes or No for the required field. The Required attribute is set to Yes when the field cannot be blank, and No when blank entries are acceptable

Step Number 4

Next select the Allow Zero Length Attribute. If you do allow it, the user can get by without putting any data into the field.

Step Number 5

In the Indexed field select Yes(Duplicates OK) to allow fro duplicate values in the field. Fields are indexed to address performance ssues when the database is in use.

Step Number 6

Enter a caption. It is the label for the field when its used on a form.

Step Number 7

Save the changes made to the table.