FileMaker Training Series is the official self-paced training curriculum from FileMaker, Inc. Discover best practises for developing professional FileMaker 15 solutions that are easy to use and take advantage of the full functionality of the FileMaker Platform.
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 15 Certified Developer.
Learn how to build a custom solution utilizing the full capabilities of the FileMaker Platform that meets the ever-changing needs of your business. With 9 self-paced training modules FileMaker Training Series Advanced covers a comprehensive set of topics to help you master the essentials of FileMaker 15 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.
FileMaker Training Series: Advanced Modules
|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 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 15 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 a great user experience. The lessons in this module explore different types of layout objects—including button bars, popovers, tab controls, and Web viewers—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 cover the set of functions that are especially useful when developing for the mobile user.|
|5. Solution Logic: Scripting||Explore the power of the Script Workspace in FileMaker Pro 15, 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 15 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). 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 15, 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 FileMaker WebDirect and FileMaker Go solutions. 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 15 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.|
FileMaker Taining Series Advanced requires FileMaker Pro 15 or Pro 15 Advanced; sold separately.