Displays the dynaset. Click on the Design View button. Returns us to Design view for the next step. You'll remember from the Grades table that we never calculated the students' total grades. Only their four original test scores have been recorded.
Queries are the best way to perform calculations in Access.
In this particular query, we will show you how to perform calculations based on table data. Term Definition Expression A combination of numbers and mathematical operators that results in a single, numerical answer. A tool that makes creating mathematical expressions from table data easier. Action Results Click on the field next to Test 4. Positions where we want the expression to be.