Support

FileMaker
Training Series

Master the essentials of FileMaker 13

FileMaker Training Series: Overview

Learn at your own pace, on your own time

The FileMaker Training Series (FTS) is the official self-paced training curriculum from FileMaker, Inc. Discover best practices for developing professional FileMaker 13 solutions that are easy to use and take advantage of the full functionality of the FileMaker Platform.

FileMaker Training Series: Basics

New to the training curriculum is the FileMaker Training Series: Basics, a free downloadable ebook. This series focuses on the features and benefits of the FileMaker Platform and highlights the newest version, FileMaker 13. Learn how to build a sample FileMaker solution from start to finish.

Learn more Free download

FileMaker Training Series: Advanced

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 13 Certified Developer.

Learn more Buy Now

FileMaker Training Series: Basics

FileMaker Training Series: Basics

Start creating your first FileMaker solution

Say goodbye to paper forms, spreadsheets and single-use apps and learn how to create your own custom solution for your unique business needs. Get started with the FileMaker Training Series: Basics – a free download.

Get step-by-step instructions to help you create a solution from start to finish. You’ll get an overview of the FileMaker Platform as well as a tour the built-in tools and templates to make a solution that’s right for you.

Discover the basics of working with layouts, creating interfaces for iPad and iPhone, and building reports on the fly. You’ll also get an introduction to calculations, scripting and how to make sure your new solution is secure.

Get started building your first FileMaker solution today.

Download the ebook for free now

FileMaker Training Series: Basics Modules

The FileMaker Training Series: Basics focuses on the features and benefits of the FileMaker Platform with special attention to the newest version, FileMaker 13. You will learn how to build a sample FileMaker solution from start to finish.

Lessons 1 - 2

Learn how the products in the FileMaker Platform work together. Identify requirements for building, assessing, and hosting FileMaker solutions, and compare and contrast FileMaker Pro and FileMaker Go. See what pre-built templates, or Starter Solutions, come with FileMaker Pro and how you can start using them right away. Plus, understand the capabilities of FileMaker Pro Advanced, and read about real-world use cases.

Lessons 3 - 4

Learn how to navigate layouts and understand different ways to view and edit your data. Perform complex finds, extend and constrain found sets, make use of operators in your search criteria, and practice ways to sort data in a solution.

Lesson 5 - 6

Identify the steps to a good design process as well as the basic principles for starting a project. Identify common file formats that can be converted by FileMaker Pro 13. Begin building your own practice solution by importing data from Excel.

Lessons 7 - 8
Working with Fields

Create fields and tables using key features such as the Manage Database Dialog and the Field Picker. Get a basic overview of relational design such as one-to-many and many-to-many relationships so you can reduce the need to enter the same data multiple times or in multiple places.

Lessons 9 - 13

Learn the importance of good user interface design and best practices when creating solutions for iOS devices. Experiment with applying styles and themes in layouts to create a visually attractive user interface. Get familiar with placing objects on a layout, and use the grids, guides and stencils tools available in FileMaker Pro to create a uniform and consistent interface. Add functionality to your practice solution by creating a portal, tab control, panel control, popover and Web Viewer.

Lessons 14 - 19
Calculation Functions

Learn the basics of calculations, scripting and reporting in FileMaker Pro 13 through step-by-step activities building your own practice solution. Then find out how FileMaker Pro can integrate with other business systems. And finally, get introduced to the built-in security capabilities and learn about the methods of sharing and deploying a solution to other users.

Take a training class

If you prefer, take the FileMaker Training Series as a class instead. FileMaker Trainers have extensive real-world experience and in-depth knowledge on the best practices in FileMaker solution development. Courses are offered at trainer facilities and many trainers can provide customised training at your organisation.

Find a FileMaker Trainer

FileMaker Training Series: Advanced

FileMaker Training Series: Advanced

Take your FileMaker development skills to the next level

Learn how to build a custom solution utilising the full capabilities of the FileMaker Platform that meets the ever-changing needs of your business. The FileMaker Training Series: Advanced covers a comprehensive set of topics to help you master the essentials of FileMaker 13 solution development.

FileMaker Training Series: Advanced comes with a detailed, step-by-step manual and includes demo files, exercises and videos to help guide you through the materials.

Is the FileMaker Training Series right for you?

This series is ideal for intermediate to advanced FileMaker developers, but anyone who creates databases can broaden their skill set from these time-tested materials. This series is a key resource for becoming a FileMaker Certified Developer.

See now

Buy now

Book and DVD - £25.99

PDF format - £12.99
(electronic download)

Available on iBooks - £11.99
Download on iBooks

Get it free

Join the FileMaker Developer Subscription for £49 and get FileMaker Training Series: Advanced for free.

Learn More

FileMaker Training Series: Advanced Modules

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 13 Certified Developer.

1. Introduction

Begin your journey of building solid business solutions by learning the steps of planning, creating and deploying successful solutions on the FileMaker Platform. This section gives you an introduction to the foundation and design phase when starting a new project and the key principles to consider for any project such as user experience, building for different devices, and performance.

2. Data

Gain practical skills required to define FileMaker Pro 13 data tables and fields. Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. Cover important topics such as data types and options for auto-entry, validation, field storage and indexing. Plus, learn how to manage images and other objects in container fields.

3. Interface

Learn how to work efficiently and effectively with layouts, an essential skill for any developer. For solutions accessed by mobile, desktop, and web users, layouts can be tailored to take full advantage of the specific environment, providing for a great user experience. The lessons in this module explore different types of layout objects and the tools and methods for controlling them.

4. Solution Logic: Calculations

Learn how functions work in the calculation engine and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions. Lessons also include the set of functions that are especially useful when developing for the mobile user. And discover new functionality in FileMaker Pro 13 for accessing metadata stored with container field data.

5. Solution Logic: Scripting

Explore the power of the scripting in FileMaker Pro 13, which allows you to create scripted routines that can then be triggered in a variety of ways. Learn about a number of 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. Learn how to build navigation and window controls, create custom menus, and study logical branching and looping routines.

6. Reporting

Practice creating reports in FileMaker Pro 13 using a variety of techniques. Explore basic and advanced sub-summary reports and learn how to build a cross-tab report (with data-driven columns). And see how the ExecuteSQL function can be extremely useful for creating reports and charts with its ability to quickly find, sort and even aggregate data.

7. Security

Become familiar with the security controls in FileMaker Pro and their relevance to FileMaker Go, FileMaker WebDirect, and Custom Web Publishing. Study the account-based security features of FileMaker Pro 13, and learn how to implement privilege sets, tie access to database solutions to external authentication servers, control both access and authoring rights to systems, and extend security controls with scripting. Learn how to encrypt FileMaker files and network communication and why doing this is important.

8. Deployment

Understand the various techniques for a deploying a FileMaker solution, with particular considerations for the new FileMaker WebDirect technology, as well as considerations specific to FileMaker Go. Get best practices for installing and configuring FileMaker Server, and learn how to trigger scripts from FileMaker Pro as well as operating system scripts from FileMaker Server.

9. Integration

Learn how to integrate FileMaker Pro 13 with SQL systems, both through ODBC connections and with the External SQL Data Source capabilities. Discover how the integration of FileMaker with web services opens up a wealth of possibilities for your FileMaker solutions. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.

Register for a class

If you prefer, take the FileMaker Training Series as a class instead. FileMaker Trainers have extensive real-world experience and in-depth knowledge on the best practices in FileMaker solution development. Courses are offered at trainer facilities and many trainers can provide customised training at your organisation.

Find a FileMaker Trainer

FileMaker Web Seminars

Connect with knowledge

View topics

Web Seminars

FileMaker Pro 13 Trial

FileMaker Pro Trial 13

Download a free 30-day trial and see all the new features.

Get it now