Table Relationships
The goal of any business is to have many customers return many times to buy many things. The Database has to represent a many-to-many relationship and summarize that data in Reports.
In Access, a Table is used to:
Add data to another Table.
Filter Data in another Table.
Select Specific Data based on your criteria.
Separate Tables: A Normalized Database
By definition, Normalizing a database defines the Tables and how the Tables are related.
The Rules are Simple:
Minimize duplicate data entry
Protect data integrity
The purpose is to prevent repeating groups or redundant data.
Data should be entered once: not here, here and here. Data should also match the collection. So tblProducts has product information only: No customers.
This is just an artist's sketch of Tables. There is a lot more in our course on Microsoft Access.
Click on Quit Microsoft Access and return to Excel.
