From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Understanding number field sizes - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Understanding number field sizes
When you assign the data type number to a field you have 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 data type when you'll potentially perform some sort of mathematical calculation on that field. A good example would be a Quantity field where you would add and subtract your orders, or your inventories. Let's take a look at our Orders table in Design View. Click on your Quantity and you can see that it has a Number data type. Look down in the Field Properties, and the default Field Size is Long Integer. But if I use this dropdown arrow I have many different options. Let's take a look at what each of these means. You have different options because it's important to reserve the space in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
Creating a table using table templates1m 19s
-
Setting data types2m 15s
-
Understanding number field sizes3m 43s
-
Setting default field types2m 30s
-
Using validation rules2m 1s
-
Using flag fields2m 6s
-
Using an index1m 58s
-
Using a datasheet Totals row1m 47s
-
Filtering by selection1m 22s
-
Resizing columns and rows1m 50s
-
Removing gridlines and shading from tables1m 27s
-
Hiding and unhiding table fields1m 16s
-
Freezing fields when scrolling51s
-
Analyzing your table for redundant structure5m 14s
-
-
-
-
-
-
-
-
-