Date+types+for+a+given+set+of+data+for+Boolean,+alpha+numerical,+numeric+and+date.

 Data typed for a given set of data for Boolean, alpha numerical, numeric and date. by Zainab Aboobaker


 * Boolean fields - a field of this data type will only let you enter a 'Yes' or a 'No'. This may be as text (YES/NO or TRUE/FALSE) or as a tick/blank.
 * Alpha numerical - a field of this data type will accept both numbers and text.
 * When to use - if you want to enter text or a mixture of text and numbers.
 * When NOT to use - if you want to store only numbers or only dates. You can enter numbers or dates into text fields but they would get sorted as if they were words and could not easily be used for any calculations.

** Numeric ** - a field of this data type is used to store numbers. Number fields are used to store numbers because:
 * the data will be **sorted** correctly (i.e. the numerical data 2,3,20,30 would be sorted as 2,20,3,30 if it was stored in a text field)

> Date fields can display the date information in different formats such as the full name of the day/month (//28th August 1961//) or the numerical versions (//28/08/61//)
 * Date - a field of this type stores days, months and years so that records can be sorted correctly and easily validated using range checks.
 * When to use - for any field which will be used to store date information.