Byte (byte) An integer between 0 and 255.

Integer (integer) is a short integer between–32,768 and 32,767.

Long (long integer) is a long integer from–2,147,483,648 to 2,147,483,647.

Currency? From-922,337,203,685,477.5808 to 922,337,203,685,477.07.

Single (single-precision type) single-precision floating-point number. When it is negative, the range is -3.402823E38 to-1.45438+0298E-45.

And when it is positive, it is from 1.40 1298E-45 to 3.402823E38.

Double (double precision)? Double precision floating point number. When the range is-1.75438+0348621e308 is negative.

-4.940656454 1247E-324, positive numbers range from 4.940 1247E-324 to.

1.797693 13486232 e308

Decimal? Exact numeric data type.

The variable is stored as a 96-bit (12 bytes) signed integer and divided by the power of 10.

This scale factor determines the number of digits to the right of the decimal point, ranging from 0 to 28.

：

Microsoft Office Access is a relational database management system published by Microsoft. It combines the characteristics of MicrosoftJet database engine and graphical user interface, and is one of the system programs of Microsoft Office.

Microsoft Office Access is a database management system that Microsoft combines the graphical user interface of database engine with software development tools. It is a member of Microsoft office and sold separately in versions of OFFICE, including professional version and later version. 20 12 On February 4th, Microsoft Office 20 16 released the latest Microsoft Office Access 20 16, and Microsoft Office Access 20 13 was the previous version.

MS ACCESS stores data in its own format in the database engine based on Access Jet. It can also directly import or link data (stored in other applications and databases).