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, BINARY or VARBINARY 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.

The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they contain binary strings rather than non-binary strings.

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 BIT, TINYINT, SMALLINT, MEDIUMINT, INT, INTEGER or BIGINT for integer type fields
   OR
   select REAL, DOUBLE, FLOAT, DECIMAL or NUMERIC for floating point fields

NOTE: As of MySQL 5.0.3, a BIT data type is available for storing bit-field values. Before 5.0.3, MySQL interprets BIT as TINYINT(1).

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