MS Access Table

TABLE

            Stores related data about a specific subject.

Creating Tables

-          Field Name

-          Data Type

-          Description

-          Field Properties

Primary Key

-          Field or fields, which uniquely identifies individual records stored in the table.

-          Must not contain null values

-          Single-column primary keys should not have duplicate data.

Relationships

-          Describe how entities relate to and interact with one another. The ability to create (and later enforce) relationship allows developers to build some of the business functionality directly into the database.

3 Main Types of Relationships

1. One-to-One

2. One-to-Many

3. Many-to-Many

How to set relationships between tables?

                Referential Integrity

    - Referential integrity is a system of rules that MS Access will use to ensure that relationships between records in related tables are valid, and you don’t accidentally delete or change related data.