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 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…
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.…
Creating a relationship between 2 tables in Access
This post follows from the post: Creating & using a “lookup table” in Access. In that exercise, we created a…
Creating & using a “lookup table” in Access
The DBE CAPS CAT curriculum includes using a finite Value List to create a Combo Box field in an Access…
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:…
How to add a Splash Screen in Access
Add a custom Splash Screen to your Access database with steps for creation, automation with a timer, property settings for…
Access’ Export HTML Document function
Microsoft Access allows you to export data from any of its 4 main objects (tables, queries, forms & reports) as…
Access’ Import Excel spreadsheet function
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this…