Design a table

See Also

To design a table open the table in Design View.

Designing a table may consist of any one or more of the following actions:

· Add the fields you require to the table
How ?

· Delete the fields from the table you don't require
How ?

· Modify existing fields by:
Changing a field's name
Changing a field's type
Changing a field's default value
Changing a field's size

· Add an indexes to the table to
Find and sort records faster
Prevent duplicate values from being entered into a field
Prevent duplicate values from being entered in a combination of fields

· Delete an index

· Set or change the primary key of the table

· Remove the primary key of the table

· Change the table type of the table