1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow to select the field type or enter it manually

Create a field for text or memos

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select CHAR or VARCHAR for text fields or select TINYTEXT, TEXT, MEDIUMTEXT or LONGTEXT for memos

NOTE: The default length for CHAR and VARCHAR fields is 50. You can change this by setting the Length property.

Create a field for numbers or currency

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER or BIGINT for integer type fields
   OR
   select REAL, DOUBLE, FLOAT, DECIMAL or NUMERIC for floating point fields

Create a field for dates and times

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select DATE, DATETIME, TIMESTAMP, TIME
   
   

Create a field that automatically increments numbers

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER or BIGINT as the field type
6. In the field's property box, select Auto Increment

NOTE: There can only be one Auto Increment field in a table and it must be defined as an index (key).

Create a field for sets and enumerates

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select SET or ENUM as the field type
6. In the field's property box, enter the available values for the field into Values

Create a field to store BLOB (Binary Large Objects)

1. Open the table in Design View
2. Select the Fields tab
3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
   To add a field at the end of the table, click Add Field from the Toolbar
4. In the Name column enter the name of the field
5. In the Type column click the arrow and select TINYBLOB, BLOB, MEDIUMBLOB or LONGBLOB for Binary Large Object fields

Define the number of decimal places in a field

1. Open the table in Design View
2. Select the Fields tab
3. Move to the floating point field
4. Set the number of decimals in the Decimal property of the field