1. Text: used to input data of text or a combination of text and numbers. Is one of the most commonly used field types, which is divided into short text and long text. The difference is that the character length of short text does not exceed 255 characters (bytes). 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, that is, data related to currency, accounting for 8 bytes, and rounding is prohibited during calculation.
When the requirements are not strict, numerical fields can be used.
3. digital type ($ Number): data used to store digital data 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. The most commonly used are long integer and double precision.
4. Date/Time Type: used to store date and/or time values, accounting for 8 bytes.
5. Automatic numbering type: if an automatic numbering field is designed in the table, after a new record is added in the table, the system field will add a serial number to it, thus ensuring the uniqueness of the data record. The default value is a long integer, and automatic numbering cannot be updated.
6. Yes/No type: also known as Boolean type, used to store logical values (Yes/No, True/False, On/Off), accounting for 1 byte.
7.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).
8. Attachment: Attachment type is the preferred data type for storing binary files (such as digital images).
9. Hyperlinks: Windows objects used to store hyperlink links, such as jumping to documents and web pages through hyperlinks.
10. Lock Wizard: With the query wizard, you can build a combo box to enter a field value, which can be a reference in a table or query or a manually entered value.
Extended data:
For the autonumber type, the autonumber field "ID" will be available by default when the table is created quickly. Its main purpose is to act as a primary key if there is no suitable field in the table as a primary key.
When using the automatic numbering field, every time a record is added, the system automatically adds a serial number, which will not be updated even if it is deleted, thus ensuring the uniqueness of data records. So it can act as a primary key.