Understanding number field sizes

When you assign the datatype number to a field you've several considerations…to take into account.…Understanding the different number field sizes can help keep your file size down.…The first question is what is a number?…Your phone number, or ZIP code are made up of numbers, but they're truly text fields.…You don't add your ZIP code and my ZIP code together to create a new location.…We use the Number datatype when you'll potentially perform some sort of…mathematical calculation on the field.…A good example would be the Quantity field where you would add or subtract your…numbers or inventories.…

It's important to choose the most appropriate number field size for your data,…because each number option reserves space in the database and that space is set…aside, even if it's not used.…Let's take a look at our orders table in design view and see how this works.…Click on the Quantity field and I can see that it's a Number datatype, and down…in the Field Properties the Field Size is by default Long Integer, but if I…