Database: Create, Tables and Relation.

Here are five short videos showing you how to create a new Access database, two tables, and then relate them. The final video gives a quick demo of a query taking information from the two related tables. Each video will open in a new window, and will start automatically, so DON'T click on them or else you'll get loads of youtube windows up... be patient ...

1. Create new database file
   
   
2. Create a table - with a primary key
   
   
3. Create a second table, with a reference for the others primary key
   
   
4. Relate the two tables
   
   
5. Introduce a method of displaying data from two related tables

Support documents:

• PowerPoint Presentation
• Support sheet - pages 1 -> 3
• Support sheet - pages 4 -> 6
• Worksheet