O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required