Nine types of data that access allows in Design view

In the Design view of a table, each field has a design type, and access allows nine types of data: text, notes, numeric, date/time, currency, AutoNumber, yes/No, OLE object, Hyperlink, Query Wizard.

Text: This type allows a maximum of 255 characters or numbers, the default size of access is 50 characters, and the system saves only the characters entered into the field without saving the null characters on the unused position in the text field. You can set the FieldSize property to control the maximum length of characters that can be entered.

Note:

This type is used to hold long lengths of text and numbers that allow a field to store content up to 64,000 characters. However, access cannot sort or index the memo fields, but you can sort and index the text fields. Although you can search for text in a Memo field, it's not as fast as searching in an indexed text field.

Digital:

This type of field can be used to store numeric data for arithmetic calculations, the user can also set the FieldSize property to define a specific numeric type, and any font specified as a numeric data type can be set to "byte", "integer", "Long Integer", "single number", "Double number", "Synchronous copy ID", " Decimal "five types. Typically, in Access, the default is double precision.

Date/Time:

This type is used to store date, time, or date time, and each date/Time field requires 8 bytes to store space.

Currency: This type is a special type of numeric data type, equivalent to a numeric field type with a double attribute. When you enter data into a currency field, you do not have to type a comma between the renminbi symbol and the thousand, Access automatically displays the RMB symbol and comma, and adds two decimal places to the Currency field. When the decimal part is more than two digits, access rounds the data. The accuracy is 15 digits to the left of the decimal point and 4 digits to the right.

Automatic numbering:

This type is special, and each time you add a new record to a table, Access automatically inserts a unique order or random number, that is, specifying a value in the AutoNumber field. Once the AutoNumber is specified, it is permanently connected to the record. If you delete a record in the table that contains an AutoNumber field, Access does not renumber the table AutoNumber field. When you add a record, access no longer uses the value of the AutoNumber field that has been deleted, but instead restarts the value by the incremental rule.

Yes/No: This field is for fields that are set up to contain only two different optional values in a field, and the user can select a Yes/No field through the format attribute of the Yes/No data type.

OLE object:

This field refers to a field that allows you to "link" or "Embed" OLE objects individually. When you add data to an OLE Object field, you can link or embed an OLE object in an Access table by using an object created in another OLE protocol, such as a Word document, Excel spreadsheet, image, sound, or other binary data. OLE Object fields can be up to 1GB, which is primarily limited by disk space.

Hyperlinks: This field is primarily used to hold hyperlinks, contain text that is a hyperlink address, or a combination of characters and numbers stored as text. When you click a hyperlink, the Web browser or access will reach the specified target based on the hyperlink address. A hyperlink can contain up to three parts: one is the text that is displayed in the field or control, the other is the path to the file or page, and the third is the address in the file or page. The easiest way to insert a hyperlink address in this field or control is to click the Hyperlink command on the Insert menu.

Lookup Wizard:

This field type provides the user with a list of the contents of the field, which you can select from the list as the content to add to the field.