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.
Access database tables
Tables are used to store data. They are similar to worksheets in that they store data arranged in tabulated form,…
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…
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…