DB section has been updated to add some SQL code.
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).
This video will create the Database and create the Designer Table.
This video will set the field types and sizes of the Designer table.
This video will show you how to set the appropriate validation checks in the table (length check).
This video will create the Item Table setting the field names and types.
This table will add set the Primary and Foreign Keys and then add the validation rules (length, range and restricted choices).
We will now test the database to test that the validation rules we added.
This video will show how to generate documentation for coursework etc. to prove you have created the database correctly.