Microsoft Access
This sticky post simply aims to organise and group all the Microsoft Access-related posts on the blog as well as…
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…
Changing field properties during import into Access
One of the steps of the Import Data Wizard in Access allows you to modify the field settings during the…
Being more selective in an Access query
One of the incredibly powerful features of SQL-based databases is the ability to write queries with very specific criteria to…
Split table Database Tool
If you consider the average Excel spreadsheet, you will commonly see instances of repeated groups of data. What is happening…
Create a Search box on an Access Form
In this tutorial, we create a Form based on a table and then add a search box on the search…
Creating a Record Validation Rule in Access
A Record Validation Rule in Access compares values in the fields of a record to validate the entire record.
Checking the accuracy of data
This is a block of theory that best fits in with Microsoft Access but could be applied to data anywhere.…
Ucase in Access
Ucase is the Microsoft Access equivalent of Excel’s UPPER() function. This tutorial describes three different solutions to the same problem,…