Chapter 5. Working with Relationships and Lookups

Working with Relationships and Lookups

Relational databases are powerful because they can contain multiple related tables. You can create relationships between tables directly in the Relationships window, or you can create relationships by building lookups that populate a field in one table with values from another table.

  • Understanding Relationships

  • Create a Relationship between Two Tables

  • Edit a Relationship

  • Remove a Relationship

  • Arrange the Relationships Window

  • Print a Relationship Report

  • View Object Dependencies

  • Document the Database

  • Understanding Lookups

  • Create a Table for Use As a Field Lookup

  • Create a Field Lookup Based on a Table

  • Create a ...

Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial