This is an introduction to creating relational databases in Access. It covers why to relate tables and how.
These videos cover basic query creating and demonstrates creating and using Access queries based on related tables. It also demonstrates how to use a table field as the criteria for a query.