Microsoft Office Tutorials and References
In Depth Information
Close the property sheet by
clicking its Close button.
Click the Current Due fi eld in the
design grid, and then click the
Property Sheet button on the
Design tab.
Click the Caption box, and then
type Due as the caption.
Close the Property Sheet by
clicking its Close button.
View the query results
(Figure 2–65).
Click the Close ‘Query1’ button to
close the query.
When asked if you want to save
your changes, click the No button.
What would happen if I clicked
the Yes button instead of the
No button?
If you had saved the query, the
changes you made to the
properties would be saved in the
database along with the query.
Figure 2–65
Other Ways
1. Right-click fi eld in
design grid, click
Properties on
shortcut menu
Calculating Statistics
For group calculations, Microsoft Access supports several built-in statistics: COUNT
(count of the number of records), SUM (total), AVG (average), MAX (largest value), MIN
(smallest value), STDEV (standard deviation), VAR (variance), FIRST (fi rst value), and
LAST (last value). These statistics are called aggregate functions. An aggregate function is
a function that performs some mathematical function against a group of records. To use any
of these aggregate functions in a query, you include it in the Total row in the design grid.
The Total row routinely does not appear in the grid. To include it, click the Totals button on
the Design tab.
Search JabSto ::

Custom Search