Modifying Access tables is simple. Use these tips to modify tables in Access to suit your database's needs.
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.