Using SQL in Access
This post is for teachers mastering Microsoft Access for the DBE CAPS CAT, IEB IT, and Cambridge International IGCSE &…
productivity through technology
Posts and tutorials related to queries in Microsoft Access.
This post is for teachers mastering Microsoft Access for the DBE CAPS CAT, IEB IT, and Cambridge International IGCSE &…
Access offers a tool to analyse objects. In this example, we analyse a query in a database. In this tutorial:…
Queries can be based on a table or tables, another query or queries, or a combination of the tables and…
One of the incredibly powerful features of SQL-based databases is the ability to write queries with very specific criteria to…
Ucase is the Microsoft Access equivalent of Excel’s UPPER() function. This tutorial describes three different solutions to the same problem,…
In Excel, calculations are performed on values contained in cells or cell ranges using cell or range references. In the…
A dynamic parameter in an Access query allows for criteria to be entered by the user at runtime. This tutorial…
This post is aimed at Information Technology (“IT”) students in DBE and IEB schools. When learning the Structured Query Language…
A simple Access Select query is the primary method for returning records from a database table. In a real-world database,…
We covered the Excel solution to this post’s scenario in the post Cleaning data in Excel. Using the exact same…