How to add a Splash Screen in Access
A really easy addition to any Microsoft Access database application is a Display Form, or what is commonly referred to…
Access’ Export HTML Document function
Microsoft Access allows you to export data from any of its 4 main objects (tables, queries, forms & reports) as…
Nested IF Statements in Excel
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
Phase 2 Access database
Previous step: Phase 2 Excel Charts The Grade 11 & Grade 12 PAT requires you to create a database using…
Access’ Import Excel spreadsheet function
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this…
Phase 2 Excel data capture
Previous step: Phase 2 Questionnaire Once you have administered your PAT questionnaire (25 respondents for Grade 12), you must capture…
Conquering Excel’s VLOOKUP
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can…
Excel functions you need to know for CAT
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The…
Page numbering in Word
Word’s automatic page numbering feature can become quite complicated very quickly! The complexity results from the various options available combined…
Shortcuts for marking CAT practical assessments
This is a collection of literal and figurative shortcuts that I find invaluable when marking practical assessment files (Word documents,…