Access Queries   «Prev  Next»
Lesson 6 Taking advantage of data types
Objective Learn to use the correct data type for optimal performance.
Learn to use the correct data type for optimal performance in MS Access
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.