Saturday 17 May 2008

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:

No comments: