Every field in a database table has properties (or characteristics).
One of the properties is the Data Type for the field.
Here are some of the most common data types you will use in a database ...
|Type of Data||Description||Example|
|Short Text||Small amounts of text and numbers (e.g. phone numbers)||0116 4456677|
|Long Text||Lengthy text or combinations of text and numbers||it'sLearning 365|
|Number||Numeric data used in mathematical calculations.||4
|Date/Time||Date and time values||01-01-2021
|Currency||Prices with a decimal place||£2.99|
|AutoNumber||A unique number given to each record in a table||1,2,3,4 ...|
|Yes/No||Yes or No / True or False Values||Yes
Complete these two activities to test your knowledge of data types.
Data Types Matching
Print out this Page
Deciding on Data Types