• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part II: Building and Using a Database > Tapping the Power of Relationships

Chapter 6. Tapping the Power of Relationships

IN THIS CHAPTER

  • Learn how to add lookup fields to your tables

  • Run the Table Analyzer to get hints on making your design more efficient

  • Create and modify relationships between tables

  • Use referential integrity to protect your data

The average person might define the term relationship as a connection of blood or marriage. In the relational database world, the term relationship simply refers to an association between two records. That’s the good news—you don’t have to send your Access database flowers when you mess up. The bad news is that you might find Access relationships just as frustrating as your blood relations. An irate mother-in-law has nothing on an Access relationship run amuck.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint