Modifying Tables

Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.

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. Similarly, whenever you see a grand total at the bottom of a table, you're looking at a totals row.

Example of a calculated field and totals row in a table of orders

To learn how to create calculated fields and totals rows, review our lesson on How to Create Calculated Fields and Totals Rows.