Learn to use the correct data type for optimal performance.
Use Correct Data Type for Optimal Performance in MS Access
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.
Designing a table is a multistep process. By following the steps in order, your table design
can be created readily and with minimal effort:
Create the new table.
Enter field names, data types, properties, and (optionally) descriptions.
Set the table’s primary key.
Create indexes for appropriate fields.
Save the table’s design.
Generally speaking, some tables are never really finished. As users’ needs change or the
business rules governing the application change, you might find it necessary to open an
existing table in Design view. This course describes the process
of creating tables as if every table you ever work on is brand new. The truth is, however,
that most of the work that you do on an Access application is performed on existing objects
in the database. Some of those objects you have added yourself, while other objects may have
been added by another developer at some time in the past. However, the process of maintaining
an existing database component is exactly the same as creating the same object