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…
Ucase in Access
Ucase is the Microsoft Access equivalent of Excel’s UPPER() function. This tutorial describes three different solutions to the same problem,…
Calculated field in an Access query
In Excel, calculations are performed on values contained in cells or cell ranges using cell or range references. In the…
A parameterised query in Access
A dynamic parameter in an Access query allows for criteria to be entered by the user at runtime. Download the…
A simple Select query in Access
A simple Access Select query is the primary method for returning records from a database table. In a real-world database,…
UPDATE query to split values in a field into 2 fields
We covered the Excel solution to this post’s scenario in the post Cleaning data in Excel. Using exactly the same…
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.…
An UPDATE query in Microsoft Access
To actually change the values in the records in your table you can run an UPDATE Query against the table.…
A DELETE query in Microsoft Access
OK so now you must tread lightly! DELETE queries are destructive — there is no “undo”! The Golden Rule is:…