|
::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map
|
Microsoft Access - Class 2 - Part XII
|
>
Back |
Field Size for Number fields
The size of a number field is based on the amount of computer memory
needed to work with different types of numbers.
You can select any of these sizes from the Field Size list :
|
Byte
|
Holds numbers between 0 and 255 with
no fractions or decimals. |
|
Integer
|
Holds numbers between -32,768 and
32,767 with no fractions or decimals. |
|
Long Integer
|
Holds numbers between -2,147,483,648
and 2,147,483,647 with no fractions or decimals. |
|
Single
|
Stores numbers times 10 to the -38th
to +38th power. It includes fractions and the calculations are
accurate to six decimal places. (-3.4x1038) to (3.4x1038). |
|
Double
|
Stores numbers in the range of 10 to the -324th
to +324th power. It includes fractions and the calculations
are accurate to 10 decimal places. |
Print this page
|
