Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

Chapter 2. Joins and Cascades

Chapter 1 explored sound database design principles. You learned that you might need to break up a large table into smaller tables for better efficiency and data integrity. This chapter focuses more on the relationships between tables. To properly understand the way Access handles relationships between tables, you need to understand joins and cascades. To be more specific, you learn

  • what joins are and why you should use them

  • what referential integrity is

  • what cascading updates and deletes are

  • how to define referential integrity and cascades in the Relationships window

What are joins and why use them? Before these questions can be answered, you need to understand where to use them. The primary places in Access that ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book