Deciding on Data Types

Diving Line

If you need to print this page out, type your name in the box below.

Your Name : 


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.




Complete the activity below to test your understanding of different data types.

DoIT  Choosing Data Types

PrintIT  Print out this Page

Next  Creating a Database Table

Last modified: Thursday, 5 November 2020, 12:45 PM