Preparatory Training for the FileMaker Certified Developer Exam Training – Live Online or Classroom

Claris Authorised Course

Preparatory Training for the FileMaker Certified Developer Exam

Claris Authorised
Training Provider

FileMaker Pro Introduction

My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!
The White Wall Company
October 2024
FileMaker Pro Introduction

We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.
Mondrian Investment Partners Limited
October 2024
FileMaker Pro Advanced

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.
Hannah Griffiths
November 2024
FileMaker Pro Introduction

I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.
Beaulieu Motor Museum
November 2024
I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.
Paresh Dudhaiya
October 2024
FileMaker Pro Advanced

We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.
Rebecca F
October 2024
FileMaker Pro Introduction

The set up was very professional and my trainer was very knowledgeable. Highly recommended.
Bladeroom
October 2024
FileMaker Pro Advanced

I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!
Trinitas Consulting
November 2024
I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!
Julian Support
October 2024
An enjoyable and productive day. A flexible content and pace of work which suited our needs.
Guardian News & Media
October 2024
Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!
Lucie M
November 2024
Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.
Techedology
November 2024
An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

November 2024
Great delivery, enjoyable training session.

October 2024

Course Facts

5 day course
Our Trainers are Authorised Professionals
Live Online or Classroom-based
Certificate of completion
Maximum class size of 6 for scheduled courses
Unlimited support after your course
Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses

Course Outline

Defining Database Schema
Building Layouts
Working with Calculations
Working with Scripts
Securing FileMaker Systems

FULL OUTLINE

Related Courses

FileMaker Pro Introduction

My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!
The White Wall Company
October 2024
FileMaker Pro Introduction

We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.
Mondrian Investment Partners Limited
October 2024
FileMaker Pro Advanced

The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.
Hannah Griffiths
November 2024
FileMaker Pro Introduction

I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.
Beaulieu Motor Museum
November 2024
I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo.
Paresh Dudhaiya
October 2024
FileMaker Pro Advanced

We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.
Rebecca F
October 2024
FileMaker Pro Introduction

The set up was very professional and my trainer was very knowledgeable. Highly recommended.
Bladeroom
October 2024
FileMaker Pro Advanced

I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!
Trinitas Consulting
November 2024
I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!
Julian Support
October 2024
An enjoyable and productive day. A flexible content and pace of work which suited our needs.
Guardian News & Media
October 2024
Thank you for organising my FileMaker training day. I learned so much with my trainer, Nick, and have come away with such a great database. Thank you Transmedia for being so helpful!
Lucie M
November 2024
Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.
Techedology
November 2024
An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

November 2024
Great delivery, enjoyable training session.

October 2024

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Enquire Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Enquire Now

Team Training and Bespoke Sessions

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

Sessions can be run online or in person, on your site or at our London training centre.
We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
We offer a free consultation service to work out every detail of your course.

Prices for bespoke sessions with our expert trainers start at £525 + VAT.

Overview

This five day course is based on the curriculum of the official Claris FileMaker Certification Study Guide (see https://www.claris.com/resources/certification/docs/claris_fm_certification_study_guide_en.pdf). The Study Guide covers 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 Claris FileMaker Certified Developer. For further information, see https://www.claris.com/certification/.

Course Outline

Defining Database Schema

Identify the characteristics and implications of using various auto-entry options
Identify the characteristics and implications of using various field types available in FileMaker Pro
Identify the mechanisms and behaviours of validation options and describe the possible outcomes when one is triggered
Use a storage option to achieve a desired result
Use a container storage option to achieve a desired result
Given a particular Relationships Graph and scenario, define a result
Given a scenario, define the appropriate relationship
Use ESS to integrate data from external data sources and properly design a schema

Building Layouts

Describe the implications of tying a layout to specific table occurrence
Identify characteristics and behaviours that can be assigned to a portal
Describe which field/layout object behaviors can be modified
Describe the types and attributes of script triggers
Given a scenario, identify the implications of choosing a particular trigger type
Identify the properties, use, and capabilities of themes, object styles, and states
Describe the setup and behavior of layout parts
Identify the implications of layout design across different clients

Working with Calculations

Identify proper expression syntax, logic, and order of operations
Describe the behaviour and use of core calculation functions
Describe the behaviour and use of specialised calculation functions
Describe the behaviour and use of custom functions

Working with Scripts

Given a scenario, identify the use of core algorithm techniques
Identify the use of core scripting features
Describe how context and context changes can affect script behaviours when retrieving or updating data in related or unrelated tables, and/or navigating between tables or windows
Describe the considerations required when writing scripts for a multi-user environment
Describe the tools and techniques for troubleshooting scripts
Identify the implications of writing scripts for different clients or environments

Securing FileMaker Systems

Describe how accounts, privilege sets, and authentication interact
Describe how to control access and manage security in custom apps through privilege sets
Describe how encryption and external file protection is used to protect FileMaker data
Describe how to secure an app for deployment

Deploying FileMaker Systems

Describe the available configurations, location, and administrative options for all FileMaker Server and FileMaker Cloud components and services
Describe the key elements of FileMaker Server and FileMaker Cloud installations and deployments, configuration and administration, troubleshooting and monitoring
Describe best practices for effective and secure back-ups
Describe the key elements of using server-side scripting
Describe the options for deploying a custom app to FileMaker Go
Describe the differences between deploying for FileMaker WebDirect, FileMaker Pro or FileMaker Go
Describe the available web publishing options for FileMaker Server

Data integration

Describe the formats and methods to import data into FileMaker files
Describe the formats and methods to export data from FileMaker files
Describe the methods for integrating FileMaker with web services
Describe which live back-end data sources are supported for ESS
Describe how to connect to external data sources and how to integrate them into a custom app