Create an Access database
All of your Access databasing will start by performing this function. Unfortunately, most textbooks (and teachers) use existing databases and…
An Access Form for data entry only
Modifying the properties of an Access Form falls outside the scope of the CAPS CAT curriculum. This very simple exercise…
The Primary Key in a database table
Understanding the Primary Key (“PK”) concept is critical to learning about Relational Databases. A table can exist without a PK,…
Teaching database theory
At this stage, this post is a jumbled collection of thoughts that I am putting down in writing for the…
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:…
Phase 2 Access database
« Previous step: Phase 2 Excel Charts The Grade 11 & Grade 12 PAT requires you to create a database…