What does single and double mean as field size settings?

[Guest]

I am taking an Access self paced computer course. (REF. PCL01-MOXAC--PR-204
Page 5-11) In this table labled "Field size property setting for Number
fields", it listed the terms "Single" and "Double". I do not understand the
explanation and my instructor did not either.

 

[Joseph Meehan]

I am taking an Access self paced computer course. (REF.
PCL01-MOXAC--PR-204 Page 5-11) In this table labled "Field size
property setting for Number fields", it listed the terms "Single" and
"Double". I do not understand the explanation and my instructor did
not either.

Single is big numbers and double is really big numbers.

Byte Stores numbers from 0 to 255 (no fractions). None 1 byte
Decimal Stores numbers from -10^38-1 through 10^38-1 (.adp)
Stores numbers from -10^28-1 through 10^28-1 (.mdb) 28 12bytes
Integer Stores numbers from -32,768 to 32,767 (no fractions). None 2
bytes
Long Integer (Default) Stores numbers from -2,147,483,648 to
2,147,483,647 (no fractions). None 4 bytes
Single Stores numbers from
-3.402823E38 to -1.401298E-45
for negative values and from
1.401298E-45 to 3.402823E38 for positive values. 7 4 bytes
Double Stores numbers from
-1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from
4.94065645841247E-324 to
1.79769313486231E308 for positive values. 15 8 bytes