Practical lesson
In the practical lesson you create a table with Create – Table (Datasheet view) or Create – Table Design, give each field a suitable type and enter data. To calculate on a numeric field, open the table in Datasheet View and press the Σ Totals button on the Home tab: a “Total” row appears under the table. Click the cell of that row in the column you need and choose Sum, Average, Count, Maximum or Minimum from the list. The result shows at once in the cell and updates when the table changes. The Totals row only displays: it does not change the records or add a new record. Making several independent tables prepares you to link them in the next lesson.
In a class paper-recycling drive the kilograms are written down every week. The “Total” row under the table gives the overall amount, the average and the largest in one click. Preparing the report takes a few minutes.
Bookkeepers, stock controllers and sports coaches get the summary figures of a table column quickly.
As you pass five classrooms at school, count the chairs in each, write the numbers on paper and find the total and the largest.
| LengthKm |
|---|
| 12 |
| 8 |
| 15 |
| 20 |
| 10 |
“The calculation master”: each student makes a table with 5 invented numbers, gets five results in the Totals row and compares them with the matching Excel formulas.