Day 21
Microsoft Access 2000
Lesson:
Calculate Statistics
As you can see on page A2.38, Access supports built-in statistics, such as COUNT, SUM, AVG, MAX, MIN, STDEV, VAR, FIRST, and LAST. To use any of these, just include it in a query in the Total row, found within the design view. The Total row routinely does not appear within the grid. To include this row, just right-click the grid, and then click totals on the shortcut menu. See the examples on page A 2.38-9.
Construction of the class session
10 to 20 minute – Project 2 |
70 minutes - Project 1 and 2 lab work Students work on Projects, raising their hands when they have a question.
|
10 minute Break |
10 minute Mini - lesson, when needed |
70 minutes - Project 2 lab work Students work on Projects, raising their hands when they have a question.
All projects are due by the test day. |
Lab Work:
Project 1
Problem 3 on page A 1.61-2
Project 2
Problem 1 on page A 2.44, (Second) Problem 1 on page A 2.44-5, problem 2 on page A2.46, Problem 3 on page A 2.46-7 and the first three Cases and Places.
You will need the document:
SideWalk Scrapers , which you should have on your Hard drive or click here to download it now.
All projects must be either e-mail to me at
or
given to me directly by the test day (Day 24)