Table Types
You saw in trying to resolve all the relationships among the tables in the database examples that you had to create another type of table, the join table. Four types of tables exist:
Data tables are the primary tables where most of your data is stored.
Join tables, or linking tables, create a connection between two tables in a many-to-many relationship.
Subset tables are data tables that contain fields that describe a specific subject and, thus, are better suited to having their own tables.
Validation tables, or lookup tables, are used to validate data entered into other tables.
I've already discussed data tables and join tables at some length. I briefly discuss the other two types of tables so you can recognize them and know what they ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
