Creating a QR code to connect to Wi-Fi
I am seeing more and more QR codes popping up, especially now that COVID has encouraged people to pursue contactless methods of performing common tasks. I have recently seen restaurants…
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. Quite honestly the hardest part about this type of Microsoft…
Chrome’s QR Code generator
As of January 2021, Google Chrome added the ability to generate a QR Codes for any URL visited in the browser (this could previously be done using various Chrome extensions).…
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 existing data. If you have a field storing the age…
Hyperlink to a location on the same page
It is a common practice on very long web pages to create a link from one part of a web page to another location on the same page to avoid…
Printer Queues
The Printer Queue concept is introduced in Grade 10 as part of the computer hardware devices module. This post deals with the basics as laid out in the curriculum, as…
Icons & logos you should recognise
Here is a list of icons and logos that you should be familiar with. These images may appear as stimuli in a formal assessment and it will be to the…
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 back your data up before running an UPDATE Query —…
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 table with the details of some Learners, tblLearners, and 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. This is appropriate where your list of options is finite,…