not to be used in any arithmetic calculations. The maximum length for a text field is characters. It is the default data type because of being used most frequently. Memo : It is used for storing comments and is capable of accommodating , characters.
But a field with this data type is not amenable to sorting or filtering of data records. Number : It is meant to store numbers, which could be integers (-32768 to 32767), long integers (– , , , to , , , ), bytes ( – ), single (to store values with decimal point up to a certain limit), double (to store values in decimal point with greater magnitude and more precision) or decimal types. Date/Time : It is used to store dates, times or a combination of both. Currency : It is used for storing numbers in terms of Dollars, Rupees or other Currencies.
AutoNumber : It is a numeric data automatically entered by Access. It is of particular importance in a situation where none of the fields individually or a set of fields as a combination in a table is unique. 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. OLE Object : OLE stands for Object Linking and Embedding.
It refers to an object that could be a photograph, bar code image or another document created in another software application. Hyperlink : This data type is meant to store a Universal Resource Locator (URL) and e-mail addresses. (c) Properties : Once the data type of a column is specified, Access allows the designer to define the properties of each column. These properties are of two types General and Look up.
(i) General : In the context of text data type the general properties are : Field Size : This property, in case of text fields, refers to the maximum number of characters allowed in the column. The same property, in case of numbers, refers to the type of numbers being stored as per requirements.