Data Types

Diving Line

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

Your Name : 


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.

DoIT  Data Types Matching

PrintIT  Print out this Page

Next  Deciding on Data Types

Last modified: Wednesday, 11 November 2020, 11:36 AM