FileMaker Pro
Relational Databases


Outcomes

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

FileMaker Pro 5 Basic Skills, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session




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


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
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-ManyRelationship
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 RelatedRecords
Creating a Value List from Another File
Allowing the Deletion of Related Records


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



    Performance-based objectives
    • Use advanced field definitions including calculation fields.
    • Apply auto-entry, value lists, and other field options to make data entry easier and more efficient.
    • Create efficient layouts that include repeating fields, portals, and merge fields.
    • Identify the three types of data relationships, and use them to build a relational database system.
    • Create buttons on a layout to execute commands and scripts.
    • Create scripts to quickly recall and execute a simple or complex series of steps.



    This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course


     
    About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2017