1. Text: used to input data of text or a combination of text and numbers. The maximum length is 255 characters (bytes) and the default value is 50. In Access, every Chinese character and all special characters (including Chinese punctuation marks) are counted as one character.

2. Currency: used to store currency value, accounting for 8 bytes, and rounding is prohibited during calculation.

3. number type ($ Number): used for data that can be calculated by numbers, except currency. According to the size of the field, the number field can be divided into seven situations: byte, integer, long integer, single precision, double precision, synchronous copy ID and decimal, accounting for 1, 2, 4, 8, 16 and 12 bytes respectively.

4. Date/Time Type: used to store date and/or time values, accounting for 8 bytes.

5. Automatic numbering: used to automatically insert the serial number when adding records (1 or random number every time). The default value is long integer, or it can be changed to synchronous copy ID. Automatic numbering cannot be updated.

6. Yes/No type: used to represent logical values (yes/no, true/false), accounting for 1 byte.

7.Memo: used for long text or a combination of long text and numbers (more than 255 characters), with a maximum length of 65,535 characters.

8.OLE objects: OLE objects (such as Word documents, Excel spreadsheets, pictures, sounds, etc. ) created in other programs using OLE protocol, with the maximum storage capacity of 1GB (limited by disk space).

9. Hyperlink: used to store the hyperlink address, with a maximum of 64,000 characters.

10, Lock Wizard: allows users to select values from other tables or value lists through combo boxes or list boxes. The actual field type and length depend on the data source.

Baidu encyclopedia-Microsoft Office Access

Baidu Encyclopedia-Data Type