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

new format.

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

feature.

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

=[@Salary]*1.05

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.