Creating a Relational Database
You can use Access 2016 to create relational Databases. The following thumbnail videos will go through creating the furniture and designer database that we have used earlier in the site (link).
1 - Creating New Tables
This video will create the Database and create the Designer Table.
2 - Designer Table Field Types and Sizes
This video will set the field types and sizes of the Designer table.
3 - Setting the Designer Table Validation
This video will show you how to set the appropriate validation checks in the table (length check).
4 - Setting Item Table types and sizes
This video will create the Item Table setting the field names and types.
5 - Item Table Validation
This table will add set the Primary and Foreign Keys and then add the validation rules (length, range and restricted choices).
6 - Testing the Database
We will now test the database to test that the validation rules we added.
7 - Generating Documentation
This video will show how to generate documentation for coursework etc. to prove you have created the database correctly.