Create a field for numbers or currency

See Also

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 select Insert from the Field menu, or right-click on the field and select Insert
To add a field at the end of the table, select Add from the Field menu, or right-click in the fields grid and select Add

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
For more information on MySQL field types, click