Preparatory Training for the FileMaker Certified Developer Exam

Duration: 5 Days

Objectives

This five day course is based on the curriculum of the official FileMaker Training Series (see http://www.filemaker.com/uk/learning/training/fts.html). 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 16 product line and become a FileMaker Certified Developer. For further information, see http://www.filemaker.com/uk/learning/training/fts.html.

Pre-requisites

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

Scripts

  • 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

Reporting

  • 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

Security

  • 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

Connectivity

  • 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

Course Dates

London CentralLondon GreenwichBristol

London Greenwich

Dates Price Book Now
4 - 8 Dec £1095 Book Now
See more 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.


"I am writing to say 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. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills

"Excellent. The right pace, the right style- great overall!"

Goldsmiths University of London

"Very clear instruction and presentation."

Hay Group



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team