As you specify the correct data type for input purposes, remember always to assign the correct data when creating your database so that the data is easier to work with all around.
An example of using the wrong data type would be assigning a date-formatted piece of data to a text field.
Through a text field, Access would not be able to handle the data as a Date/Time data type and would therefore not be
able to perform the normal built-in validation of Date/Time values.
Access would also take a long time to process the data, because the data would have to be converted from a Text value to a Date/Time value.
Drag your mouse over the various data types in the MouseOver below to get an idea of which data type you should use for which type of information.
Data Types Available
When you have chosen the data type, you can further optimize your database by specifying the
Field Length property
In the next lesson, we will conclude this module.