FileMaker Advanced

Details of training class

FileMaker Advanced (3 Days) - Contact for upcoming training

Location Details

Global Knowledge
31st Floor - 2 Bloor Street East
Toronto, ON M4W 1A8


The FileMaker Training Series: Advanced is for intermediate to advanced FileMaker developers, but anyone who creates FileMaker databases can increase their knowledge from this series. It also serves as a stepping-stone to becoming a FileMaker Certified Developer.


Benefits

When you complete this course you will be able to:

  • Describe your real-world information in terms of Files, tables, fields, and relationships in a relational database system.
  • Use more advanced FileMaker Pro layout features to improve the design, efficiency, and user-friendliness of your database solutions.
  • Define calculations to manipulate your FileMaker Pro data in a variety of ways.
  • Understand the organization and use of FileMaker Pro’s built-in functions.
  • Add powerful and useful automation features to your FileMaker Pro solutions.
  • Generate simple and advanced summary reports of your FileMaker Pro data.
  • Better understand how to use FileMaker Pro’s functions.

Who should take this class?

  • Familiar and comfortable with FileMaker Pro.
  • Interested in learning FileMaker Pro and creating simple databases for their own or business use.
  • Planning to take the FileMaker certification exam.
  • Familiar with older versions for FileMaker Pro but not familiar with recent releases.
  • Interested in becoming a FileMaker Pro power user.
  • Recently starting a job that requires understanding of FileMaker Pro.

What you will Learn

  • About planning, creating and deploying successful solutions on the FileMaker Platform.
  • FileMaker Pro data tables and fields.
  • How to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions.
  • Important topics such as data types and options for auto-entry, validation, field storage and indexing.
  • How to manage images and other objects in container fields.
  • Working efficiently and effectively with layouts (mobile, desktop, web).
  • About creating a great user experience.
  • Functions including the most used and custom functions.
  • New functionality in FileMaker Pro for accessing metadata stored with container field data.
  • Scripting tools that make it easier to write and troubleshoot scripts, as well as best practices for writing scripts, and scripting for the mobile user.
  • How to build navigation and window controls, create custom menus, and study logical branching and looping routines.
  • Reporting including types of reports, ExecuteSQL function, sort, find, and aggregate data.
  • About security controls in FileMaker Pro and their relevance to FileMaker Go, FileMaker WebDirect, and Custom Web Publishing.
  • Encryption of FileMaker files, Controlling access to systems, and about extended security features.
  • How to deploy a FileMaker solution including WebDirect and FileMaker Go.
  • Installation and configuring FileMaker Server.
  • How to integrate FileMaker Pro with SQL systems.
  • About the integration of FileMaker with web services which opens up a wealth of possibilities for your FileMaker solutions.

Training Materials

Each student requires the FileMaker Training Series Manual. This manual is available as a downloadable ebook ($19.99).

Recommended Equipment

If you are bringing your own laptop then a copy of FileMaker Pro must already be installed on it.

Pricing

$295.00 (CAD) per day + applicable taxes

This is a 3 day class

*Note – This class has a minimum enrollment requirement.