Class Description
In this Comprehensive 4-day class, three-time FileMaker Excellence award-winning Trainer, Cris Ippolite, will be imparting his world-class FileMaker knowledge and skills to intermediate-level FileMaker users that would like to see their level of mastery advance by leaps and bounds!
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.
Course Benefits
This class will be taught by Author and multiple award-winning FileMaker Trainer, Cris Ippolite. Cris Ippolite has been the exclusive FileMaker Author on lynda.com (now Linkedin Learning)since 2002 and was one of the ORIGINAL FileMaker Authorized Trainers when the program first launched in 2008. Cris has taught over 3000 students in his live classes and has millions of views of his online course, watched internationally by over 30,000 subscribers. Cris is a top-rated speaker at the FileMaker Developer Conference and has been a speaker every year for the last 16 years. Cris was hand-picked by FileMaker, Inc. to manage their “FileMaker Training Day” Track at the conference and also won the FileMaker Excellence Award for Education in 2014 and 2016
Attendees will only need to bring a laptop.
The course cost Includes:
– Training materials
– Exercise files
– 30-day access to lynda.com
– Installation of FileMaker Pro
Who Should Attend
This course is intended for users that have some knowledge of FileMaker processes, but would like to achieve FileMaker clarity and marketable proficiency like never before!
Suggested Prerequisites
Attendees should have introductory-level experience with FileMaker and are welcome to take the FileMaker Essential Training course at lynda.com FREE for 30 days to prepare for the course.
Course Outline
Data
Gain practical skills required to define FileMaker Pro 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.
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.
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 for accessing metadata stored with container field data.
Solution Logic: Scripting
Explore the power of the scripting in FileMaker Pro, 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.
Reporting
Practice creating reports in FileMaker Pro 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.
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.
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.
Integration
Learn how to integrate FileMaker Pro 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.
Related Classes
- Acrobat 101 – Adobe Acrobat for Professionals
- Acrobat 201 – Adobe Acrobat – eForms Introduction
- AWS 101 – AWS Business Essentials
- AWS 110 – AWS Technical Essentials
- AWS 201 – Architecting on AWS
- AWS 210 – Advanced Architecting on AWS
- AWS 220 – Certification Exam Readiness Workshop: Certified Solutions Architect – Associate
- AWS 230 – Certification Exam Readiness Workshop: Certified Solutions Architect – Professional
- AWS 301 – Developing on AWS
- AWS 410 – Systems Operations on AWS
Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.
Locations