Microsoft Office Tutorials and References
In Depth Information
Tables: Adding User-Friendliness to Your Database
If you add a new field (or column) to the table, it too will display the
This one is important. If a field has formulas in it, any new records
added to the table will automatically receive the formula, too (with the
appropriate absolute or relative cell addressing figured in).
For example, suppose our pre-table database had a Raise field, in which every salary
was awarded a boost of 5 percent (see Figure 7–27).
Figure 7–27. Pay day. Note the formula in the formula bar.
Once those raise formulas are in place and the database is then converted into a table,
any new records you enter will also display the 5 percent raise, because the formula in
the Raise field will write itself. Moreover, if you edit any one of the formulas in the Raise
field, the table will rewrite all the formulas in the column correspondingly—a very cool
NOTE: The preceding example assumes you’ve written the raise formulas before you converted the
database into a table. But if you write them after converting to a table, they may look very different.
For example, if you transform your database into a table and then add the Raise field, and proceed
to write the raise formulas by clicking in the cells in the Salary column, they’ll all read
without a specific cell reference. That’s how tables write formulas—they refer to fields, not cell
references. But however the formula appears, its mathematical outcome will be identical.