Fundamentals of FileMaker 12 Development
Interested in FileMaker Development? Join us at our FileMaker Fundamentals course, where we will attack topics such as Working with Fields, Data Modeling, Scripting and Calculations, and Layout Development. For 2 days students will develop Reports, work with Relationships, develop and modify scripts to run, and learn to Manage Security effectively. All materials will follow the Foundation Training Series from FileMaker Inc. which is supplied with the course. Here is an outline of the class:
Fundamentals of FileMaker 12 Development
Goal of the Course: Students acquire topics such as Working with Fields, Data Modeling, Scripting and Calculations, and Layout Development.
Working with Fields
Learn practical skills required to define FileMaker Pro 12 data tables and fields. This module explores data types and options for auto-entry, validation, and field storage. Discover how to manage images and other objects in container fields.
Data Modeling
Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. This module also covers lessons in building layouts using related data fields and portals.
Working with Layouts
Discover tools and techniques for creating layouts in FileMaker Pro 12, including Layout themes, object states, the Inspector tool palette, conditional formatting, auto-resize, Web Viewers, portals, and tab controls. Learn how to organize layouts into groups and how to set Script Trigger options. Understand how to create and use static, dynamic, and relational value lists.
Calculation Functions
Learn how functions work in the calculation engine in FileMaker Pro 12 and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions.
Scripts
Explore the Script Trigger features of FileMaker Pro 12, as well as best practices for writing scripts. Learn how to build navigation and window controls, and study logical branching and looping routines.
Reporting
Practice creating reports in FileMaker Pro 12 using a variety of techniques. Explore sub-summary reports that group information by break fields. Work with the charting features of FileMaker Pro 12. Learn how to build a cross-tab report (with data-driven columns) and an HTML report that is displayed via the Web Viewer object.
