S R Computer Institute

Datatypes are the properties of each field. Every field has one datatype like text, number, date, etc.

1. Short Text:- This Data type is used for typing the simple Text, numbers which does not need calculation. (e.g., Mobile numbers).
   Size:- Up to 255 characters
2. Long Text:- This data type is used for lengthy text or alphanumeric data. Example: Type Address.
   Size:-Maximum 63, 999 characters.
3. Number:- Numeric data type used for storing the mathematical calculations.
   Size: 1, 2, 4, 8, and 16 bytes.
4. Date/Time:- This Data type is used for Store Date/time for the years 100 through 9999.
   Size:- Size of this data type is 8 bytes.
5. Currency:- This Data type is allow to store currency values and numeric data with one to four decimal places.
   Size:- Size of the currency data type is 8 bytes.
6. Auto Number:-This Data type is allow to Assign a unique number or assigned by Microsoft Access when any new record is created. Usually used as the primary key.
   Size:- Size of this data type is 4 bytes (16 bytes if it is set as a Replication ID).
7. Yes/No:-This Data type is used only for stores logical values Yes and No.
   Size:- Size of this data type is 1 Bit.
8. Attachment:- This data type is used to stores files, such as digital photos. Multiple files can be attached per record.
   Size:- This Data types size is Up to 2GB Data can be stored.
9. OLE objects:- OLE objects data type is used to store audio, video, other Binary Large Objects.
   Size:- Up to 2GB data can be stored.
10. Hyperlink:- This data type is used for Text or combinations of text and numbers stored. That text is used as a hyperlink address.
    Size:-This data types Each part of a Hyperlink data type allows you to store a maximum 2048 characters.
11. Calculated:- Helps you to create an expression that uses data from one or more fields. You can create an expression which uses data from one or more fields.
12. Lookup Wizard:- In this data type is used to creates a field that allows you to choose a value from the another table or list of values by using the list box or combo box after you complete the wizard MS access sets the data type based on the values selected in the wizard.
    Size:- Size of this data type is 4 bytes .