Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Data type in Microsoft Access

Data type Length Description
BINARY 1 bytes per character Saves any data type. Does not transform data.
BIT 1 byte integer 0 or 1 and fields that contain only one of two values.
TINYINT 1 byte integer from 0 to 255.
MONEY 8 Financial data type from -2^63 (-922 337 203 685 477.5808) to 2^63-1 (922 337 203 685 477.5807) with the precision of one ten-thousandth unit.
DATETIME 8 Data type representing date and time from 1.1.1753 to 31.12.9999 with precision about 3ms. Values are rounded to .000, .003 and .007.
UNIQUEIDENTIFIER 128 bits A unique identification number used with remote procedure calls.
REAL 4 A single-precision floating-point data type with a range from –3.402823E38 to –1.401298E-45 for negative values, from 1.401298E-45 to 3.402823E38 for positive values.
FLOAT 8 A double-precision floating-point data type with a range from –1.79769313486232E308 to –4.94065645841247E-324 for negative values, from 4.94065645841247E-324 to 1.79769313486232E308 for positive values.
SMALLINT 2 integer from -2^15 (-32 768) to 2^15-1 (32 767).
INTEGER 4 integer from -2^31 (-2 147 483 648) to 2^31-1 (2 147 483 647).
DECIMAL 17 Numeric data type with fixed precision and scale (precision 1-38, 18 by default and scale 0-p, 0 by default).
TEXT 2 bytes per character Char string of variable length from 0 to 2.14 gigabytes.
IMAGE n Binary data of variable length from 0 to 2.14 gigabytes.
CHARACTER 2 bytes per character Char string of fixed length from 0 to 255 characters.
 
See msdn.microsoft.com/en-us/library/ms714540%28VS.85%29.aspx
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice