Preparatory Training for the FileMaker 15.0 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 15 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

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

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

"Amazing! Looking forward to the follow-up course!"

MOD

"Absolutely top quality training and facilities."

National Museum of Wales



 

 

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