Mastering Word’s Mail Merge
My “Golden Rule” for earning top marks in a Mail Merge assessment is simple: start with 2 files, finish with…
Creating TOTALS in Access queries
In Grade 12 one of the most advanced skills you will learn is how to aggregate data using a query.…
An Access table with a Calculated Data Type field
The rules of managing data tell us to store data once and not store data that can be derived from…
An UPDATE query in Microsoft Access
To actually change the values in your table you can run an UPDATE query against the table. You should always…
Creating a relationship between 2 tables in Microsoft Access
This post follows from the post: Creating & using a “lookup table” in Access. In that exercise, we created a…
Creating & using a “lookup table” in Access
The CAT curriculum includes using a finite Value List to create a Combo Box field in an Access database table.…
A DELETE query in Microsoft Access
OK so now you must tread lightly! DELETE queries are destructive — there is no “undo”! The Golden Rule is:…
Mastering spacing in Microsoft Word
The fine art of whitespace in documents, web pages, and more is an art form with many, many rules. Whitespace,…
Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test…
Excel’s Text to Columns command
There are a few super-handy timesaving tricks in Excel for when your data is not quite the way you need…