/* 7/12/18 - enhance Back arrow that appears in course summary page */ /* 8-30-17 Move search on Catalog page */
FF06: Building an App - Adding Relationships (28min)

FF06: Building an App - Adding Relationships (28min)

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

Curriculum

  • Relationships - The Basics
  • Introduction to Building an App - Adding Relationships
  • What Are Relationships?
  • Fields in a Relationship
  • Relationship Properties
  • Putting What You’ve Learned into Practice
  • Creating a Relationship
  • Using a Relationship to Relate Records from Different Tables
  • Creating a Details Table and Adding Lookup Fields
  • Leveraging a Relationship when Adding Records
  • Creating Summary Fields
  • 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

Curriculum

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