The following are the different data types:
1. Text: It is used for a string of character: Words or numbers that are not to be used in arithmetic calculations. The maximum length for a text field is 255 characters. It is the default data type. For example – Job name, Job department, Job type.
2. Memo: It is used for storing comments and is capable of accommodating 65,536 characters.
3. Number: It is meant to store numbers, which could be integers, long integers, bytes, single, double or decimal types. For example – Job unit, Job ID.
4. Date / Time: It is used to store dates, time or a combination of both. For example – Job time.
5. Currency: It is used for storing numbers in terms of Dollars, Rupees or other currencies.
6. Auto Number: It is a numeric data automatically entered by access.
7. Yes / No: It is to declare a logical field which may have only one of the two opposite values alternatively given as: Yes or No, On or Off, True or False.
8. OLE object: OLE stands for Object Linking and Embedding. It refers to an object that could be a photograph, barcode image or another document created in another software application.
9. Hyperlink: This data type is meant to store a Universal Resource Locator (URL) and e-mail addresses.