Access 2010


Modifying Tables
More table options
Calculated fields and totals rows
Adding calculated fields and totals rows to your table lets you perform calculations using your table data. A calculated field calculates data within one record, while a totals row performs a calculation on an entire field of data. Whenever you see a subtotal for one record, you are looking at a calculated field. Likewise, a grand total at the bottom of a table is really a totals row.

To learn how to create calculated fields and totals rows, review our mini-lesson located in our Extras section on How to Create Calculated Fields and Totals Rows in Tables.