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. Likewise, a grand total at the bottom of a table is really a totals row.

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

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.