FileMaker Pro 5.5: Relational Databases (Windows)

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 course or have equivalent knowledge:

FileMaker Pro 5.5 Basic Skills:

Performance-Based Objectives:

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

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.

Hardware/software Requirements:

You will need:

Intel-compatible computer 486/33 or later.
At least 32 MB of RAM.
About 30 MB of hard disk space to install software, and an additional 5 MB for course data files.
A color monitor capable of at least 800 x 600 resolution.
A CD-ROM drive.
FileMaker Pro 5.5 software.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course duration:

1 Day(s)

Course outline:

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


FileMaker Pro 5.5 : Relational Databases for Windows

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

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.