Create an Access database
All of your Access databasing will start by performing this function. Unfortunately, most textbooks (and teachers) use existing databases and…
Advanced UPDATE query to manipulate a string
This tutorial is specifically for CAT PAT students completing the Access phase of their projects. This is an advanced tutorial…
Using SQL in Access
This post is for teachers mastering Microsoft Access for the DBE CAPS CAT, IEB IT, and Cambridge International IGCSE &…
Analysing a query in an Access database
Access offers a tool to analyse objects. In this example, we analyse a query in a database. In this tutorial:…
Querying multiple tables in Access
Queries can be based on a table or tables, another query or queries, or a combination of the tables and…
Many-to-many relationships in a database
This is a story about a relationship, much like that of Romeo & Juliet, that was doomed from the start…
Creating a Validation Rule in Microsoft Access
A lot of work must be put into planning and applying techniques to ensure ease of accurate data input. Microsoft…
VBA to truncate or delete Access database tables
Access SQL does not have anything like TRUNCATE table. There is also no way to run a DROP table query.…
Adding fields to an existing Access Report
In this tutorial: Required knowledge: 1. Scenario You have created a report and the underlying object has changed. This could…