Modifying an Access Form
When you create a Form you select the underlying object. A Form can be based on a table, or multiple tables, or a query, or multiple queries. When you create…
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 logic and almost identically named Access functions, we can create…
Creating Microsoft Access Forms
Just as the Table objects store data in your Microsoft Access database, the Form objects serve as the user interface between the user and your data. Allowing users unfettered access…
Getting locked up in an Access database
The Microsoft Access interface is a great deal more complex than say that of Microsoft Word or Excel and at times can seem downright impossible to master. Here is the…
An Access Form for data entry only
THIS POST IS “UNDER CONSTRUCTION” – PLEASE CHECK BACK SOON OR COMMENT BELOW! Modifying the properties of an Access Form falls outside the scope of the CAT curriculum. This very…
The Primary Key in a database table
The Primary Key of a table is the field that contains the value which uniquely identifies each record in that table. The Primary Key of a record: Is required (cannot…
Teaching database theory
At this stage, this post is a jumbled collection of thoughts that I am putting down in writing for the first time. Please feel free to comment or make suggestions/corrections!…
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. Quite honestly the hardest part about this type of Microsoft…
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 existing data. If you have a field storing the age…
An UPDATE query in Microsoft Access
To actually change the values in your table you can run an UPDATE Query against the table. You should always back your data up before running an UPDATE Query —…