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 as a Splash Screen that opens automatically when the database…
productivity through technology
A really easy addition to any Microsoft Access database application is a Display Form, or what is commonly referred to as a Splash Screen that opens automatically when the database…
Microsoft Access allows you to export data from any of its 4 main objects (tables, queries, forms & reports) as HTML — another example of the advantages of Microsoft Office…
This little gem finds its way into Matric finals over and over again. It takes some practice to get your head around the logic, so let’s begin! It is also…
« Previous step: Phase 2 Excel Charts The Grade 11 & Grade 12 PAT requires you to create a database using Microsoft Access. You have already captured your questionnaire data in Excel. Rather than…
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this is the Import Excel spreadsheet function for importing Excel data…
« Previous step: Phase 2 Questionnaire Once you have administered your PAT questionnaire (25 responses for Grade 12), you must capture and analyze the data. You can create the Microsoft…
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can easily be mastered with practice. Imagine the following scenario: you…
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The table below is searchable and sortable, and some of the…
Word’s automatic page numbering feature can become quite complicated very quickly! The complexity results from the various options available combined with the possible existence of Sections in your document. Your…
This is a collection of literal and figurative shortcuts that I find invaluable when marking practical assessment files (Word documents, Excel workbooks, HTML files, etc.). I also teach my Learners…