FileMaker Pro 5.5 : Relational Databases for Windows

Course Description

Overview: In this course, you will learn powerful techniques for developing complex database systems containing multiple linked database files. You will learn about the various relationship types, link databases together, use field formatting options, and will create buttons and scripts to create a system that is ultimately easy and efficient for an end user to work with.

Prerequisites: To ensure your success, we recommend you first take the following Element K course or have equivalent knowledge:

·           FileMaker Pro 5.5 Basic Skills:

Course Content

Lesson 1: Advanced Field and Layout Options

Topic 1A: Advanced Field Definitions

Task 1A-1: Creating a New Database

Task 1A-2: Defining Fields

Task 1A-3: Defining Fields with Serial Number Auto Entry

Task 1A-4: Defining Fields with Date Auto Entry

Task 1A-5: Defining Value Lists

Task 1A-6: Defining Repeating Fields

Topic 1B: Creating Efficient Layouts

Task 1B-1: Arranging Fields on the Layout

Task 1B-2: Formatting Repeating Fields

Task 1B-3: Formatting Value Lists on a Layout

Task 1B-4: Making Final Layout Adjustments

Task 1B-5: Manually Entering Record Data

Topic 1C: Importing Records

Task 1C-1: Importing Records from Other Files

Lesson 2: Relating Databases

Topic 2A: Introduction to Relations

Topic 2B: Relationship Types and Terminology

Task 2B-1: Examining Database Files

Topic 2C: Working with One-to-Many Relationships

Task 2C-1: Defining Relationships

Task 2C-2: Placing Related Fields on a Layout

Task 2C-3: Defining a Bi-Directional Relationship

Task 2C-4: Creating a Layout to Display Related Records from the "Many"File

Task 2C-5: Creating a Portal to Display Related Records

Task 2C-6: Viewing Related Records with a Portal

Lesson 3: Many-to-Many Relationships

Topic 3A: Establishing Many-to-Many Relationships

Task 3A-1: Creating an Intermediate Database

Task 3A-2: Defining Many-to-Many Relationships

Task 3A-3: Displaying Related Fields in a "Bridge" Database

Task 3A-4: Entering Information into the "Bridge" Database

Topic 3B: Utilizing Related Data

Task 3B-1: Creating a Portal to Access Related Information in a Many-to-ManyRelationship

Task 3B-2: Defining Calculation Fields to Bridge a Many-to-Many Relationship

Task 3B-3: Creating a Portal to View Registrations

Topic 3C: Summarizing Portal Records

Task 3C-1: Creating a Count of Students

Topic 3D: Enhancing Portals

Task 3D-1: Setting Up a Relationship to Allow the Creation of RelatedRecords

Task 3D-2: Creating a Value List from Another File

Task 3D-3: Allowing the Deletion of Related Records

Lesson 4: Scripts and Buttons

Topic 4A: Creating Simple Buttons

Task 4A-1: Creating a Button that Adds a New Record

Task 4A-2: Creating a Button to Go to a Related Record

Topic 4B: Scripting

Task 4B-1: Creating a Script that Includes Find Requests

Task 4B-2: Creating the Final Script Layout

Task 4B-3: Creating a Script to Go to Related Records

Task 4B-4: Creating a Script to Omit Records

Task 4B-5: Creating a Script to Switch Layouts and Print

Task 4B-6: Chaining Scripts

Topic 4C: Combining Scripts and Buttons

Task 4C-1: Attaching a Script to a Button

Task 4C-2: Suppressing the Printing of an Object