Conclusion

In this chapter, you learned about the various types of relationships in a relational database. You discovered how to recognize one-to-many, many-to-many, and one-to-one relationships. You also learned how to resolve many-to-many relationships. The chapter introduced you to the various types of tables, as well as the rules of normalization. In the next chapter, you'll focus on formally creating the relationships you learned about here.

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.