For Week of February 1

This week's anticipated knowledge acquisition activities:

• Top-values query
• Joining tables/Add table
• Join properties
• Restricting records in a join
• Zoom
• Creating calculated fields in a query
• Formatting/caption of calculated field
• Calculating statistics - simple & with criteria
• Grouping
• Crosstab queries

Upon completion, you'll find another online exercise for Project 2 here; and you'll be creating a series of queries for your Birds2U database from pages AC109-110.

Also known as synchronicity...

Windows 7 Upgrade

Cross-posting from MMS class because a few of you might be interested -

As requested by Jimmy J., here is the link to where I recently purchased two Windows 7 Home Premium upgrades:
http://www.shoparhive.com/Windows-7-Home-Premium-UPGRADE-Retail/product/364E823B

PLEASE READ THE ENTIRE PAGE, INCLUDING LINK TO COMPATIBILITY CHECK, BEFORE ORDERING!

Cost at the time (and still is, as of this posting) = $71.95

You get a digital download, and you should know how to burn an .ISO to DVD

Licenses pass Windows Genuine Advantage registration with nary a problem.

(this is the best price I know of - if you find a KNOWN GOOD price that beats this, please post your recommendation in the Comments)

For Week of January 25

This week in Access:

• Database design concepts reviewed
• Finish creating the Birds2U database - pp AC56-58 on Monday.
• Complete and submit online: Project 1 Reinforcements by 9 pm Tuesday.
• Remainder of week:
  - Select Queries
  - including all fields
  - clear the grid
  - using text criteria
  - wildcards
  - "show"
  - parameter queries
  - numeric data criteria
  - symbols of comparison
  - compound criteria
  - sorting in queries
  

For Week of January 18

New semester, new product. We move further into the world of databases by turning our attention to Access.

Your assignment this week will be to create and print the Birds to U database as instructed in class, if we make it that far.

For Week of January 11

Monday - Calc Quiz 4. You'll have Tuesday, if necessary to finish; otherwise it will be study hall - bring materials to study!

For Week of January 4

Something old, something new for the start of the New Year!

The old - Calc! The new:

• Lookups
• Countif
• Conditional formatting.
• Protections
• Headers, Footers, and Print Ranges.