Creating Relational Databases

MS Access - Creating Relational Databases

Creating Relational Databases Understanding Table Relationships Creating Relationships Between Tables Enforcing Referential Integrity Testing Referential Integrity & Printing and Deleting Table Relationships Understanding Relationship Types Review

This tutorial covers what many people agree is one of the most difficult database conceptshow to create and work with . A relational database contains two or more tables that are related to each other in some way. For example, a database might contain a Customers table and an Invoices table that contains the customer's orders.
In this tutorial you will learn how to link tables in an existing database together in a one-to-many relationship to create a relational database. You will also learn how to enforce referential integrity between those tables to keep records in related fields valid and accurate.
Relational databases can be confusing at first, so we'll take things slowly and explain everything in great detail as we go. Let's get started!

[Next]