10. Relating the Information in Your Database
In This Chapter
• What is relational database design?
• What are the goals and rules of relational database design?
• What is normalization, and why should I care?
• What types of relationships are available in Microsoft Access?
• How do I establish relationships in Microsoft Access?
• What are referential integrity, cascade update, and cascade delete?
A relationship exists between two tables when one or more key fields from one table are matched to one or more key fields in another table. The fields in both tables usually have the same name, data type, and size. This chapter first introduces you to relational database design. You then learn the types of relationships available in Access and how ...
Get Access® 2013 Absolute Beginner’s Guide 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.
