Preparatory Training for the FileMaker Certified Developer Exam

Duration: 5 Days


This five day course is based on the curriculum of the official FileMaker Training Series (see The FileMaker Training Series (FTS) consists of thirteen modules that cover a comprehensive set of topics that provide the building blocks for successful FileMaker solution development. The topics include beginner, intermediate and advanced content to help any level of FileMaker developer improve their development skills, master the essentials of the FileMaker product line and become a FileMaker Certified Developer. For further information, see


Intermediate level FileMaker Pro knowledge.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Introduction to the FileMaker Training Series

  • Approaching FileMaker Pro from the perspective of users
  • Techniques for working with FileMaker data
  • Performing Quick Finds
  • Saving Find requests
  • Printing and exporting data
  • Setting up recurring imports
  • Using features for working with email, PDF Excel documents

Working with Fields

  • Defining FileMaker Pro data tables and fields
  • Understanding data types
  • Options for auto-entry, validation and field storage
  • Managing images and other objects in container fields
  • Working with the Database Design Report in FileMaker Pro Advanced

Data Modelling

  • Constructing different types of data relationships
  • Ensuring data integrity
  • Implementing multiple-table solutions
  • Building layouts using related data fields and portals

Working with Layouts

  • Using the principle tools and techniques for creating layouts in FileMaker Pro
  • Using the Inspector tool palette
  • Using Conditional formatting
  • Auto-resize of layout objects
  • Web Viewers
  • Using portals
  • Using tab controls
  • Organising layouts into groups
  • Using Script Triggers
  • Creating and using static, dynamic and relational value lists

Calculation Functions

  • Understanding how the calculation engine works and how to use FileMaker Functions in various contexts
  • Custom functions and how to use them in database solutions


  • Exploring the Script Trigger features of FileMaker Pro
  • Best practices for writing scripts
  • How to build navigation and window controls
  • Studying logical branching and looping routines


  • Creating reports in FileMaker Pro
  • Exploring sub-summary reports that group information by break fields
  • Using the Charts feature of FileMaker Pro
  • Building a cross-tab report (with data-driven columns) and an HTML report that is displayed via the Web Viewer


  • The account-based security features of FileMaker Pro
  • How to implement privilege sets
  • Tying access to database solutions to external authentication servers
  • Controlling both access and authoring rights to systems
  • Extending security controls with scripting

Intermediate and Advanced Techniques

  • Implementing custom menu sets in FileMaker Pro
  • Advanced techniques with portals, including portal sorting and dynamically controlling the contents with a portal filter
  • Using advanced scripting techniques and Script Triggers to implement an audit trail

FileMaker Server

  • Best practice for setting up and maintaining FileMaker Server and FileMaker Server Advanced
  • Understanding how and why to use server-side scripts
  • Review of hardware and networking requirements
  • Effective backup routines and configuration processes


  • Integrating FileMaker with SQL systems, through ODBC connections and External SQL Data Source capabilities (ESS)
  • Configuration processes and using other data systems in tandem with your FileMaker Pro databases

Web Publishing

  • Understand the capabilities of both Instant Web Publishing (IWP) and Custom Web Publishing in FileMaker Pro
  • How to develop solutions to publish via the web
  • Reviewing the PHP Site Assistant and gaining hands-on experience with IWP

FileMaker Go

  • Using the FileMaker Go application environment for iPhone and iPad
  • Understanding the functionality offered through the menu commands
  • Understanding the differences between FileMaker Go and FileMaker Pro
  • Understand tools and behaviours to start building solid and stable mobile applications for the iPhone and iPad

Live Chat

Course Dates

RemoteLondon CentralLondon GreenwichBristol

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Exams and Certification

The knowledge gained on this course is a valuable contribution towards passing the Developer Essentials for FileMaker 12 exam, allowing a successful candidate to become an FileMaker Certified Developer.

"Fantastic! Everything was explained very clearly."


"An excellent course."

Vodafone Ltd

"Very enjoyable, well-paced tuition, tailored and relevant to my workplace demands."


© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy