Types of data_1

Types of data_1

1. Alphanumeric or Text - This allows you to type in text, numbers and symbols

2. Number- This allows a whole number or a decimal number Only numbers can be entered, no letters or symbols

3. Currency This automatically formats the data to have a £ or $ or Euro symbol in front of the data and also ensures there are two decimal places.

4. Date/Time This restricts data entry to 1-31 for day (28 or 30 in appropriate months) and 1-12 for month. It checks that a date can actually exist, for example, it would not allow 31/02/06 to be entered. It formats the data into long, medium or short date/time

5. Autonumber This datatype will automatically increase by 1 as records are added to the database

6. Logical, Boolean, Yes/No This datatype is often referred to as different things, you may hear it called 'logical', or 'boolean' or 'yes/no'. All it means is that the data is restricted to one of only two choices