Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - What is the difference between short integer and long integer, double precision and single precision in access?
What is the difference between short integer and long integer, double precision and single precision in access?
integer

2-byte (16 bits) data type, storing numbers between-215 (-32,768) and 21(32,767).

Long integer long

4 bytes (32 bits) data type, stored in -2 3 1(-2 147 483 648) and 231-kloc-0/(2147 483 648).

Single precision floating point single precision

An approximate numeric data type with an accuracy of 7 digits. Positive values range from 1. 18E-38 to 3.40E+38, and negative values range from-1. 18E-38 to -3.40E+38, and can also be 0.

Double precision floating point floating point

An approximate digital data type with an accuracy of 15 bits. It stores positive values from 2.23E-308 to 1.79E+308, and negative values from -2.23E-308 to-1.79E+308, or it can be 0.