Understanding number field sizes


show more Understanding number field sizes provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

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 th...

Understanding number field sizes
Video duration: 3m 2s 3h 43m Intermediate

Viewers:

Understanding number field sizes provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...