Chapter 3. Understanding Relationships

In this chapter, you will learn about the various types of relationships and how they integrate your data. Three main kinds of relationships exist: one-to-one, one-to-many, and many-to-many. One-to-one relationships are by far the least important and interesting of the three, and I postpone discussion of them until the end of the chapter.

The other two relationships are central to creating powerful and effective relational databases. If you haven't had much exposure to them, you might find them difficult to understand and implement at first. I've tried to provide numerous examples of each type of relationship, in the hope that repetition will enable you to recognize them with ease and use them with confidence. ...

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.