Building an Access database usually begins to work on the table first and getting the correct data type specified in the request early saves you a lot of time and headaches later on, when referring to calculate the numerical value elsewhere.
Currency and of species differ from each other, and flexibility, scope and use of the program will help you make the right choice.
Here is a quick list to get your started:
- is the monetary value will be the process?
- How many decimal places are needed for the area?
- To a large range of values will be needed?
- Where you intend to use this type of data in other cases?
to answer simple questions and get you started, but the next element is choosing the right type of data in Microsoft Access and, where applicable, the field size.
The following figures show the type of your field size and scope:
- Currency data type has no possibility of field size and fixed to 'double up to 4 decimal places
- of the field size is set to an integer has a different range with no decimal places
- of the field size is set to a different range of up to 6 decimal places
- of the field size is set to decimal has a different range of up to 14 decimal places.
There are other technical factors that are not listed in this post, but data types in Access are crucial for saving memory and improving performance, as well as providing a reasonable solution for this process .
Final Thought! Would the telephone number to be captured as of or text types of data into an Access database?