How to define relationships between tables in an Access database

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb or .accdb).
For a Microsoft Access 2000 version of this article, see 304467 .
For a Microsoft Access 97 version of this article, see 304468 .

Summary

This article describes how to define relationships in a Microsoft Access database. The article includes the following topics:
  • What are table relationships?
  • Kinds of table relationships
    • One-to-many relationships
    • Many-to-many relationships
    • One-to-one relationships
  • How to define relationships between tables
    • How to define a one-to-many or one-to-one relationship
    • How to define a many-to-many relationship
  • Referential integrity
  • Cascading updates and deletes
  • Join types

More Information

What are table relationships?
Kinds of table relationships
How to define relationships between tables
Referential integrity
Cascading updates and deletes
Join types
คุณสมบัติ

รหัสบทความ: 304466 - การตรวจสอบครั้งสุดท้าย: 9 ส.ค. 2013 - ฉบับแก้ไข: 1

คำติชม