Database Relationships  «Prev  Next»

Lesson 1

Defining Database Relationships in Access

In a relational database such as Microsoft Access, you break various subjects, such as clients and projects into separate tables. Relationships specify how you want those tables to relate to each other. For example, each project belongs to a client, and each client can have many projects. Relationships in Access, like relationships in real life, can be somewhat complicated. In Access, as in life, you can have a
  1. one-to-one,
  2. one-to-many, or
  3. many-to-many relationship.

Up until now, you may have used relationships to enhance query performance or perhaps worked only with the Access default relationships. Relationships are maintained using the Relationships option from the Tools menu. You can see the base set of relationships for our course database here in this figure:

The base set of relationships for our course database

By the end of this module, you will know how to:
  1. Identify different types of relationships used in Access
  2. Create one-to-one and one-to-many relationships
  3. Create a many-to-many relationship
  4. Use relationships to manage referential integrity
  5. Set the Cascade Update and Cascade Delete options for relationships
Relationships can greatly affect the integrity of the information going into your database. Let us get started.
In the next lesson, you will learn how to identify different types of relationships used in Access.