/* 10-23-17 - Change ribbon text for pass/fail courses 09-06-18 - Commenting this out */
FF06: Building an App - Adding Relationships

FF06: Building an App - Adding Relationships

Create relationships between tables to effeciently manage and report on your data.

About this course

 

Building an App - Adding Relationships

Relationships are key to managing and reporting your data. In this course we discuss what relationships are and how they work. Then we build a few relationships to see them in action and along the way define some key terms and features.

This course will help you to:

      • Define how one-to-many relationships work and their benefits
      • Define relationship terminology
      • Review a relationship’s properties and components
      • Create and configure relationships to connect records from different tables
      • Create lookup and summary fields between tables

 View the Help topic on table relationships

Curriculum31 min

  • Relationships - The Basics
  • Introduction to Building an App - Adding Relationships 1 min
  • What Are Relationships? 3 min
  • Fields in a Relationship 6 min
  • Relationship Properties 3 min
  • Putting What You’ve Learned into Practice
  • Creating a Relationship 3 min
  • Using a Relationship to Relate Records from Different Tables 2 min
  • Creating a Details Table and Adding Lookup Fields 6 min
  • Leveraging a Relationship when Adding Records 1 min
  • Creating Summary Fields 6 min
  • Course Assessment
  • Assessment: Building an App - Adding Relationships
  • What Do You Think?
  • Please Rate This Course - FF06: Building an App - Adding Relationships

About this course

 

Building an App - Adding Relationships

Relationships are key to managing and reporting your data. In this course we discuss what relationships are and how they work. Then we build a few relationships to see them in action and along the way define some key terms and features.

This course will help you to:

      • Define how one-to-many relationships work and their benefits
      • Define relationship terminology
      • Review a relationship’s properties and components
      • Create and configure relationships to connect records from different tables
      • Create lookup and summary fields between tables

 View the Help topic on table relationships

Curriculum31 min

  • Relationships - The Basics
  • Introduction to Building an App - Adding Relationships 1 min
  • What Are Relationships? 3 min
  • Fields in a Relationship 6 min
  • Relationship Properties 3 min
  • Putting What You’ve Learned into Practice
  • Creating a Relationship 3 min
  • Using a Relationship to Relate Records from Different Tables 2 min
  • Creating a Details Table and Adding Lookup Fields 6 min
  • Leveraging a Relationship when Adding Records 1 min
  • Creating Summary Fields 6 min
  • Course Assessment
  • Assessment: Building an App - Adding Relationships
  • What Do You Think?
  • Please Rate This Course - FF06: Building an App - Adding Relationships