FileMaker Pro 5.5 - Level 2 Days of Training: 1
 

Overview

In this course, you will learn powerful techniques for developing complex database
systems containing multiple linked database files.

Lesson 1: Advanced Field and Layout Options

 Advanced Field Definitions
 Creating a New Database
 Defining Fields
 Defining Fields with Serial Number Auto Entry
 Defining Fields with Date Auto Entry
 Defining Value Lists
 Defining Repeating Fields
 Creating Efficient Layouts
 Arranging Fields on the Layout
 Formatting Repeating Fields
 Formatting Value Lists on a Layout
 Making Final Layout Adjustments
 Manually Entering Record Data
 Importing Records Importing Records from Other Files

Lesson 2: Relating Databases

 Introduction to Relations
 Relationship Types and Terminology
 Examining Database Files
 Working with One-to-Many Relationships
 Defining Relationships
 Placing Related Fields on a Layout
 Defining a Bi-Directional Relationship
 Creating a Layout to Display Related Records from the “Many” File
 Creating a Portal to Display Related Records
 Viewing Related Records with a Portal

Lesson 3: Many-to-Many Relationships

 Establishing Many-to-Many Relationships
 Creating an Intermediate Database
 Defining Many-to-Many Relationships
 Displaying Related Fields in a “Bridge” Database
 Entering Information into the “Bridge” Database
 Utilizing Related Data
 Creating a Portal to Access Related Information in a Many-to-Many Relationship  Defining Calculation Fields to Bridge a Many-to-Many Relationship
 Creating a Portal to View Registrations
 Summarizing Portal Records
 Creating a Count of Students
 Enhancing Portals
 Setting Up a Relationship to Allow the Creation of Related Records
 Creating a Value List from Another File Allowing the Deletion of Related Records

Lesson 4: Scripts and Buttons

 Creating Simple Buttons
 Creating a Button that Adds a New Record
 Creating a Button to Go to a Related Record
 Scripting
 Creating a Script that Includes Find Requests
 Creating the Final Script Layout
 Creating a Script to Go to Related Records
 Creating a Script to Omit Records
 Creating a Script to Switch Layouts and Print
 Chaining Scripts
 Combining Scripts and Buttons
 Attaching a Script to a Button
 Suppressing the Printing of an Object