Home > Articles > Data > Access

Relationships: Your Key to Data Integrity in Access 2007

  • Print
  • + Share This
  • 💬 Discuss
This chapter is from the book
Alison Balter explains relational database design principles — specifically the types of relationships that you can define. She also discusses the details of establishing and modifying relationships between tables and describes all the important aspects of establishing relationships.

In This Chapter

  • Why This Chapter Is Important
  • Introduction to Relational Database Design
  • Establishing Relationships in Access
  • Establishing Referential Integrity
  • Looking at the Benefits of Relationships
  • Examining Indexes and Relationships
  • Practical Examples: Establishing the Relationships Between the Tables Included in the Time and Billing Database

Why This Chapter Is Important

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. Relationships are a necessary by-product of the data normalization process. Data normalization, which was introduced in Chapter 1, "Access as a Development Tool," and is covered in additional detail in this chapter, is the process of eliminating duplicate information from your system by splitting information into several tables, each containing a unique value (primary key). Although data normalization brings many benefits, you need to relate your application's tables to each other so that your users can view the data in the system as a single entity. After you define relationships between tables, you can build queries, forms, and reports that combine information from multiple tables. In this way, you can reap all the benefits of data normalization while ensuring that your system provides users with all the information they need.

  • + Share This
  • 🔖 Save To Your Account

Discussions

comments powered by Disqus