Soliant Consulting
Services Clients Training About Us
FileMaker 9 Core Essentials - Authorized FileMaker Training Series

This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.

Who Should Attend
You should consider taking this course if you are:

  • Familiar with the basics and want to acquire a stronger foundation on key FileMaker development principles
  • Comfortable with FileMaker Pro and want to advance your development skills
  • An expert developer and want to fill in any gaps in your knowledge
  • Planning to become a FileMaker 9 Certified Developer

We encourage attendance by anyone who regularly uses FileMaker Pro and wants to customize their database to enhance the user experience.

Classes
Classes are held from 9:00 a.m. to 5:00 p.m. (the coffee's on at 8:30 a.m., so feel free to come early). This course is also offered in a "split" version, wherein the 4 days are spread across 2 different weeks. This version is more convenient for local students who find it difficult to dedicate most of a week to a class. To attend the split course, please register for both parts 1 and 2 from the main training page--or call Adrienne at (800) 582-0170 to register.

FileMaker 9 Core Essentials (4 days, $1595)
Authorized FileMaker Training Series
9:00 a.m. - 5:00 p.m.
Chicago, IL
 · September 9, 10, 11, 12 - 2008
 · October 14, 15, 16, 17 - 2008
 · November 11, 12, 13, 14 - 2008
 · December 16, 17, 18, 19 - 2008
San Francisco, CA
 · October 21, 22, 23, 24 - 2008
 · November 18, 19, 20, 21 - 2008
 · December 9, 10, 11, 12 - 2008
Philadelphia, PA
 · September 23, 24, 25, 26 - 2008
 · December 2, 3, 4, 5 - 2008
 
You may register online with a credit card by clicking the date of the class you want to attend. To register and pay by check or purchase order, please contact us at (800) 582-0170 or via email.
 
Setting
· Chicago Training Facility
· San Francisco Bay Area Training Facility
· Philadelphia Area Training Facility
 

Curriculum Overview
The FileMaker Training Series (FTS) Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in the FTS training materials. While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.

The FileMaker Training Series modules:

  1. Using FileMaker Pro
  2. Working with Fields
  3. Data Modeling
  4. Working with Layouts
  5. Calculation Functions
  6. Scripts
  7. Reporting
  8. Security
  9. Intermediate & Advanced Techniques
  10. FileMaker Server
  11. Connectivity
  12. Web Publishing
 
Classroom Topics
Following are some of the knowledge areas we cover in class:

Working with Fields
Learn practical skills required to define FileMaker data tables and fields. Understand data types and options for auto-entry, validation, indexing, and field storage. Discover how to manage images and other objects in container fields

Data Modeling
Learn how to construct one-to-many and many-to-many data relationships, ensure data integrity, and implement multiple-table solutions. Learn techniques for using portals.

Layouts
Understand how layout objects are formatted and controlled. Learn how to modify the behaviors of fields, labels, portals, tab controls, Web viewers, and other layout objects. Learn to create dynamic value lists and helpful, informative tool tips. Acquire techniques for applying the conditional formatting and auto-resize features new in 9.

Calculations
Learn how to use the calculation engine in FileMaker to create or transform numbers, text, dates, graphics, and other types of data. Explore in depth some of the hundreds of built-in functions. Learn how to build your own custom functions.

Scripts
Discover how to automate workflows and interact with users. Learn how to build navigation and window controls, study logical branching and looping routines, and absorb scripting best practices.

Reporting
Practice building reports, using a variety of techniques. Create sub-summary reports that group information by break fields. Explore other ways of sharing or printing data as text, email, Adobe PDF and Microsoft Excel documents.

Security
Learn FileMaker's unified security model. Create user accounts, and learn how to grant or restrict privileges. Enforce control of both access and authoring rights, and extend security with scripting.

FileMaker Server
Learn the process of hosting files, to better share data with more users. Understand how to prepare files for hosting, and manage databases and clients through the Server Admin Console new in 9.

Web Publishing
Understand the capabilities of both Instant Web Publishing (IWP) and Custom Web Publishing (CWP), and learn how to develop solutions to publish databases live via the Web.

We Wrote the Book(s)
The FileMaker Training Series is the third consecutive set of authorized training materials developed for FileMaker, Inc. by the Soliant team. Soliant's other books make excellent companions to the FTS. In particular, our latest effort--the FileMaker 9 Developer Reference, published by Que--is a handy compendium of commands, calculation functions, scripting steps, and more. You'll receive a complementary copy as an additional benefit of attending the 4-day FTS Core Essentials course.

To register now, click an available class date on the schedule above.

 
Class Descriptions
Intro to FileMaker Pro
FileMaker 9 Core Essentials
Advanced Techniques
Training Locations
Chicago
San Francisco Bay Area
Philadelphia Area
FileMaker Training Series Authorized Trainer
FileMaker Authorized Trainer Foundation Series III
FileMaker 9 Certified Developer
FileMaker 8 Certified Developer
FileMaker 7 Certified Developer