Data Types

Data Types

1. Number

   • This allows a whole number or a decimal number
     • Only numbers can be entered, no letters or symbols
   • Age 15
     • 21.35

2. Text

   • This allows you to type in text, numbers and symbols

3. Date/Time

   • This restricts data entry to 1-31 for a day and 1-12 for months

4. Currency

   • This automatically formats the data to have a £ or $ or euro symbol in front of the data and also ensures there are teo decimal places
   • £5.75
     • $54.99

5. Autonumber

   • Record 1:1
   • The datatype will automatically increase by 1 as records are added to the databases

6. Boolean

   • Data is restricted to one or two options
   • Yes or No
   • Male or Female
   • Hot or Cold
   • On or Off