Deciding on Data Types
When you add a new field to a database, you need to decide on the most appropriate data type for the field.
After you have typed in the field name, click on the Data Type list for the field.
Select the most appropriate data type from the list before moving onto the next field.
If you do not decide on a data type, you database software will assume the field will store Short Text data.