FileMaker 16 Video Course

$4.00

FileMaker 16 Video Course is developed by FileMaker Professionals to help you pass the FileMaker 16 exam.

You Will Learn:

View Curriculum

Description

<h1 dir="ltr" style="line-height:1.38;margin-top:20pt;margin-bottom:6pt;"><span style="font-size:20pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Complete FileMaker 16 CRM Course: Learn Scripting, Relationships, and Reporting Step-by-Step</h1><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">This comprehensive course teaches you how to design, build, and enhance a complete FileMaker 16 CRM system from the ground up. Through a hands-on, project-based approach, you will learn to develop a functional contact management solution that can scale to meet real-world business needs. By combining foundational database design with advanced scripting, automation, and reporting, you will gain the knowledge and skills to create a professional-grade FileMaker CRM application.<h2 dir="ltr" style="line-height:1.38;margin-top:14pt;margin-bottom:6pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">What You Will Learn</h2><ul style="margin-top:0;margin-bottom:0;padding-inline-start:48px;"><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Understand FileMaker 16’s interface and development environment<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Create a fully functional FileMaker CRM file from scratch<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Build database tables and define essential fields for efficient data storage<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Establish one-to-many and many-to-one relationships between tables<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Implement primary and foreign keys to connect data effectively<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Design an Entity-Relationship Diagram (ERD) for structural clarity<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Apply anchor-buoy relational design principles for scalable solutions<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Create and manage layouts for intuitive data entry and navigation<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Develop scripting logic to automate repetitive tasks and workflows<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Implement conditional logic, error handling, and validation systems<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Use calculations for data processing, formatting, and automation<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Build professional reports using sub-summary parts, summary fields, and dynamic calculations<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Design dashboards and print-ready layouts for business reporting<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Configure security settings and manage user privileges<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Optimize performance and efficiency for large datasets<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Prepare and deploy your CRM for real-world business environments</li></ul><h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Learning Objectives</h2><ul style="margin-top:0;margin-bottom:0;padding-inline-start:48px;"><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Gain confidence in setting up a new FileMaker project<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Understand the logic behind relational database design<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Learn to structure tables and fields for optimal data integrity<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Build relationships that support accurate and consistent data connections<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Create user-friendly layouts to improve navigation and usability<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Develop a clear plan for expanding your CRM into a complete business solution</li></ul><h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Target Audience</h2><ul style="margin-top:0;margin-bottom:0;padding-inline-start:48px;"><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">FileMaker developers who want to strengthen their understanding of relational design<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Intermediate users looking to build their first complete FileMaker CRM solution<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Business professionals and administrators seeking to manage contact data efficiently<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Learners who want to move beyond basic FileMaker functionality into structured application design<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Anyone interested in creating custom FileMaker databases for organizational use</li></ul><h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Requirements</h2><ul style="margin-top:0;margin-bottom:0;padding-inline-start:48px;"><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Access to FileMaker Pro 16 installed on a Mac or Windows computer<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Basic knowledge of FileMaker browse, find, layout, and preview modes<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Interest in learning structured database design and workflow automation<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">No prior experience with scripting or calculations required but helpful for faster progress</li></ul><h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Course Description</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The Complete FileMaker 16 CRM Course is designed to provide learners with a thorough understanding of how to build, manage, and enhance a complete FileMaker CRM system from the ground up. This course offers a structured, hands-on approach that blends theoretical knowledge with real-world application, guiding participants through every stage of CRM development using FileMaker Pro 16. Through carefully designed lessons, learners will gain confidence in database structure, relational design, scripting, automation, and reporting—culminating in the creation of a fully functional and scalable FileMaker CRM solution suitable for professional use.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The course begins with a detailed exploration of FileMaker’s development environment and core interface components. Participants will learn how to navigate the workspace, manage tables and fields, and understand how FileMaker’s relational model supports data organization. Early lessons focus on foundational concepts that are essential for effective CRM design, such as defining data tables, setting field types, and applying naming conventions that promote consistency and maintainability. By learning how to organize and interconnect data through primary and foreign keys, learners will develop the ability to design clean, reliable relational structures that reflect real-world business relationships.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A key component of the course involves understanding the logic behind database relationships. Learners will explore one-to-many and many-to-one connections between tables, using FileMaker’s Relationship Graph to visualize how data flows through the system. The course emphasizes best practices for establishing efficient data linkages through the anchor-buoy relational design model, a principle that supports clarity and scalability as solutions grow in complexity. By constructing a well-structured Entity-Relationship Diagram (ERD), participants will gain a clear visual understanding of how contacts, companies, interactions, and other modules connect within a CRM environment.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Once the relational foundation is established, learners will move into layout design and interface development. FileMaker’s layout tools allow developers to create intuitive data entry and viewing interfaces, and this course provides step-by-step instruction on designing layouts that are both functional and visually appealing. Participants will learn how to structure layouts for desktop, tablet, and mobile use, ensuring accessibility across devices. The course highlights how layout organization directly affects usability and productivity, teaching students to employ logical grouping, clear navigation, and dynamic elements that respond to user actions.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">With a solid database structure and user interface in place, the course transitions into the core of FileMaker’s interactive power: scripting and automation. This section introduces learners to the fundamentals of FileMaker scripting, demonstrating how to automate repetitive tasks, manage workflows, and improve data accuracy through intelligent system behavior. Each scripting lesson is framed within a real-world context, allowing learners to understand both the technical and practical value of automation. Topics include script creation, sequencing, debugging, and optimization, as well as the use of script parameters and variables for managing data between layouts and windows.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">As participants gain confidence, they will learn to develop modular scripting structures that can be reused across different parts of the CRM. The course explains how to apply conditional logic to scripts, enabling the system to make decisions based on user actions or data conditions. Error management and validation are emphasized throughout, ensuring that learners understand how to design scripts that not only function correctly but also handle unexpected events gracefully. By incorporating techniques for error capture and redirection, developers can create more reliable and user-friendly systems.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">An equally important area of focus is the use of calculations within FileMaker. Calculations are the backbone of data automation, and learners will study how to apply them effectively at both the field and record levels. Through guided examples, participants will use calculation functions to manage text formatting, handle date and time operations, and process numerical data. Auto-entry calculations are introduced as a method for minimizing user input errors and enforcing data consistency. The course also demonstrates how calculated fields and summary functions can drive reporting and analytical features, transforming raw data into meaningful insights.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Building on the foundation of scripting and calculations, the course delves into advanced relational techniques, such as filtered portals and dynamic relationships that respond to user input. Learners will see how global fields and variables can be used to filter, sort, and manipulate data across layouts, creating dynamic user experiences without compromising performance. Through practical exercises, participants will construct interactive portals that display related records, apply conditional formatting, and design systems that adapt to changing business data in real time.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Reporting and analysis are major pillars of this course, providing learners with the ability to transform complex datasets into clear, actionable information. Participants will learn to design reports using sub-summary parts, summary fields, and calculation-based groupings that display data trends and key performance indicators. The course covers both on-screen and print-ready report design, ensuring that learners can produce professional outputs such as mailing labels, client reports, and performance dashboards. Detailed guidance is provided on managing page setup, print options, and multi-table report generation, allowing students to create reports that are both accurate and visually organized.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Key Topics Covered</h2><ul style="margin-top:0;margin-bottom:0;padding-inline-start:48px;"><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Understanding FileMaker scripting fundamentals and their application within CRM systems<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Writing and organizing scripts to automate repetitive processes and enhance workflow efficiency<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Creating and managing script triggers for real-time responses to user actions<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Developing modular scripting structures that can be reused across layouts and processes<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Using script parameters and variables to manage data between layouts and windows<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Implementing conditional logic to guide decision-making within scripts<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Designing validation systems for accurate and consistent data entry<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Applying field-level and record-level calculations to manage business logic<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Creating auto-entry calculations that minimize user input errors<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Using calculation functions for text formatting, date management, and numerical processing<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Building dynamic relationships that respond to user input and data changes<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Constructing filtered portals and filtered relationships for refined data presentation<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Exploring global fields, variables, and parameter differences for optimized data flow<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Understanding and implementing error capture techniques within scripts<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Redirecting script flows based on error states for improved user experience<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Designing structured reports using summary fields and sub-summary parts<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Customizing print layouts for mailing labels, reports, and other formatted outputs<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Managing page setup and print options for multi-table report generation<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Developing dashboards and summary reports for performance analysis<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li><li dir="ltr" style="list-style-type:disc;font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;" aria-level="1"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Learning practical strategies to compare and refine different scripting approaches<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;"> </li></ul><h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Teaching Methodology</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Throughout the course, the teaching methodology emphasizes applied learning and real-world development practices. Each topic is introduced conceptually and then demonstrated step by step within the FileMaker environment. Learners are encouraged to replicate exercises in their own FileMaker files, reinforcing concepts through direct experimentation and problem-solving. By following along with guided demonstrations, participants learn not only how to perform tasks but also the reasoning behind each decision. The course promotes understanding through practice, encouraging learners to think critically about database design and user experience.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A strong focus is placed on best practices in development, including modular scripting, naming conventions, and documentation. Learners will discover how these practices contribute to system maintainability, allowing for easier expansion and collaboration in the future. The course also emphasizes layout consistency, script organization, and calculation clarity—habits that define professional-grade FileMaker developers. By adopting these standards early, learners build a strong foundation for long-term success in database application design.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Usability and user interface design are interwoven throughout the learning process. Participants will observe how scripting and calculations can enhance the user experience by automating navigation, updating interface elements dynamically, and providing visual feedback. For example, learners will build layouts where conditional formatting highlights overdue tasks or where dynamic buttons change behavior based on user context. Through these exercises, students will develop an appreciation for how technical logic can enhance interface design and overall usability.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Assessment & Evaluation</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Assessment in this course is based on practical performance rather than formal testing. Learners are evaluated by their ability to implement working solutions within their own FileMaker files. Each major topic concludes with a hands-on exercise that reinforces newly acquired skills. For example, after completing scripting lessons, participants will create scripts that automate contact updates or generate filtered reports. After learning calculations, they will apply text, date, and number functions to manage real business data. By continuously applying knowledge, learners strengthen both technical proficiency and problem-solving confidence.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The evaluation approach encourages iterative learning, where students refine and improve their solutions through testing and feedback. Emphasis is placed on the ability to troubleshoot errors, understand the cause of issues, and optimize workflows for greater efficiency. Learners are guided to assess their own progress through key performance indicators such as successful automation, accurate reporting, and effective relationship building. By the end of the course, participants will have created a fully functional FileMaker CRM that demonstrates mastery of database logic, scripting, and design principles.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Course Benefits</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The Complete FileMaker 16 CRM Course offers a wide range of benefits designed to help learners acquire practical, professional skills in database design, automation, and reporting. By the end of the program, participants will not only understand the technical aspects of FileMaker 16 but also how to apply them strategically to real-world business needs. This combination of conceptual knowledge and hands-on experience ensures that graduates are well-prepared to design efficient, scalable, and secure CRM systems.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">One of the primary benefits of the course is the opportunity to build a complete, fully functional CRM system from scratch. Learners gain step-by-step experience designing tables, relationships, and layouts that mirror professional-grade database applications. This hands-on process reinforces critical thinking and problem-solving skills while providing tangible results that can be used as part of a professional portfolio. By creating a working CRM, learners gain practical experience that goes far beyond theoretical learning.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The course also focuses on automation through scripting and calculations, helping learners save time and increase productivity. Participants learn how to design intelligent workflows that reduce manual data entry and minimize user errors. Automation enhances system reliability and allows users to focus on higher-level business activities rather than repetitive administrative tasks. This knowledge translates directly into real-world efficiency improvements and is a valuable asset in any professional setting.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A strong emphasis on usability and design ensures that learners develop the ability to create systems that are not only powerful but also intuitive. Through guided lessons in layout creation, conditional formatting, and responsive design, participants learn to build user interfaces that promote smooth navigation and improved data accuracy. These design principles help developers create CRM systems that are easy to use, reducing training time and increasing user adoption.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Another major benefit of the course lies in its focus on security, performance optimization, and scalability. Learners discover how to manage user privileges, control access, and secure sensitive data. They also learn performance enhancement techniques such as indexing, relational optimization, and calculation management. This ensures that their FileMaker solutions remain fast, stable, and adaptable to growing data volumes or multi-user environments.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Finally, the course equips learners with transferable skills applicable across industries. Understanding how to design relational databases, automate workflows, and generate analytical reports prepares participants for careers in database management, systems analysis, and business application development. By mastering FileMaker 16, learners gain a versatile technical foundation that can be applied to a wide variety of organizational and professional contexts, empowering them to create efficient, data-driven solutions that support long-term business success.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Tools & Resources Required</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The primary tool required is FileMaker Pro 16. This version of FileMaker provides all the features needed for scripting, relationship management, layout design, and reporting. Learners should have a licensed installation on their computer, either on macOS or Windows. It is recommended to update FileMaker Pro 16 to the latest maintenance release to ensure stability and compatibility.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A functional computer system with sufficient performance is essential. Learners should have a machine equipped with at least 8 GB of RAM and a reliable processor to handle database operations smoothly. Adequate storage space should also be available to save multiple versions of the CRM solution during development and testing.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">An organized folder structure is recommended for managing project files, backups, and documentation. Learners should regularly save and version their work to track progress and avoid data loss. Basic file management skills, such as creating folders and maintaining consistent naming conventions, are helpful throughout the course.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A secondary testing device, such as an iPad or iPhone with FileMaker Go installed, is highly beneficial for verifying layout responsiveness and user experience. FileMaker Go allows learners to experience how their CRM performs on mobile platforms, ensuring that their designs adapt effectively to different screen sizes.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Internet access is required for downloading sample files, updates, and any supporting materials provided with the course. Learners may also find it useful to refer to FileMaker’s official documentation and developer guides for deeper technical explanations of specific functions and scripting commands.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Additional resources include a spreadsheet or text document for planning and documenting system design. This can be used to record field names, table structures, and relationships, serving as a valuable reference throughout the project. Keeping a design log helps track modifications and ensures consistency during development.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A graphics editor or basic design tool, such as Canva or Figma, can be helpful for designing interface icons or branding elements. While not mandatory, these tools enhance the professional look of the CRM’s layout. Learners may also use free icon libraries to improve visual clarity and usability within their interface.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A printer or PDF generator is useful for testing the report and layout printing features built into FileMaker. This allows learners to verify that reports are properly formatted and aligned for physical output or digital sharing.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">It is also recommended to have a small dataset ready for testing purposes. This dataset should include example contact information such as names, phone numbers, addresses, and notes. Having realistic data helps learners understand how their scripts, relationships, and reports function with actual content.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">For additional learning support, learners may use online communities and forums dedicated to FileMaker development. These communities provide valuable insights, troubleshooting advice, and inspiration for further improvement. However, learners should ensure that their work remains original and that they apply concepts independently to reinforce understanding.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Documentation tools such as Notion, OneNote, or Evernote can be used to take structured notes during lessons. Recording scripting examples, calculation formulas, and relational diagrams will help learners retain complex concepts for future projects.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A backup system, whether cloud-based or local, is strongly advised to protect data and project files. Regular backups prevent accidental data loss and allow learners to experiment freely without fear of damaging their primary solution.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Career Opportunities</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Completing this course provides learners with the technical and analytical skills necessary to pursue a variety of career paths in database management, software development, and business systems design. FileMaker is a widely used platform across multiple industries, making expertise in its use valuable in both technical and administrative roles. The skills acquired throughout this training enable learners to design and maintain efficient data-driven applications that support real-world business operations.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Career opportunities for individuals proficient in FileMaker development are broad and diverse. Many organizations require skilled developers who can design custom CRM systems, manage data workflows, and automate internal processes. Positions such as FileMaker Developer, Database Administrator, and Systems Analyst are in high demand across industries including healthcare, finance, education, logistics, and technology. Professionals in these roles are responsible for building tailored solutions that help companies streamline operations, manage customer relationships, and improve data accuracy.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">A certified FileMaker developer can also pursue independent consulting work. Many small and medium-sized businesses prefer hiring freelance developers to create custom solutions that fit their specific operational needs. Consultants with FileMaker expertise often work on diverse projects, from building inventory systems and scheduling tools to designing complete CRM platforms. This flexibility allows for a rewarding career path that combines creativity, problem-solving, and technical development.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Knowledge of FileMaker development also opens doors to broader career opportunities within information technology. Understanding how to model data, automate processes, and generate reports provides a strong foundation for other database platforms and programming environments. Many professionals use FileMaker as a stepping stone to roles involving data integration, business intelligence, and enterprise application design.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Beyond direct development roles, proficiency in FileMaker can enhance existing careers in business management, project coordination, and customer service. FileMaker-based systems often form the backbone of internal operations, and professionals who understand their structure can work more efficiently within their organizations. Administrative professionals who learn FileMaker gain the ability to customize systems, automate reporting, and manage information independently without constant technical support.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">The demand for data-driven decision-making continues to grow, making database expertise increasingly valuable in the modern job market. FileMaker developers who combine technical skill with an understanding of business logic are particularly sought after. They can interpret organizational needs and transform them into digital workflows that improve performance, accuracy, and communication.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Completing this course also demonstrates practical project experience, which is valuable when applying for roles that require proof of applied technical ability. The CRM system built during training serves as a portfolio piece, showcasing proficiency in relational design, scripting, automation, and reporting. Employers and clients value tangible examples of work that demonstrate both functionality and professional design standards.<span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Overall, this course equips learners with skills that are versatile, adaptable, and aligned with the growing demand for efficient digital solutions. Whether working in a corporate environment, pursuing freelance development, or integrating FileMaker into an existing business, graduates of this course will have the knowledge and confidence to design and deploy professional database systems.<h2 dir="ltr" style="line-height:1.38;margin-top:18pt;margin-bottom:4pt;"><span style="font-size:17pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">Enroll Today</h2><span style="font-size:11pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;">This course offers a practical pathway to mastering FileMaker 16 and building a complete CRM system from the ground up. Enrolling provides access to a structured, comprehensive learning experience that combines technical instruction with real-world application. Learners gain hands-on experience by developing functional modules, writing automation scripts, creating relationships, and designing user-friendly layouts that can be applied to a wide range of industries. Join today to begin building a comprehensive understanding of FileMaker 16 and gain the expertise to develop reliable, efficient, and customized CRM solutions that enhance productivity and support data-driven business success.

Curriculum For This Course

1. 0100 - Introductions - Overview 9 Videos 01:16:00
- 0102 - The FileMaker Platform -Summary 07:29
- 0105 - Installing FileMaker andDowngrades 08:46
- 0106 - Buying / Licensing FileMaker -FLT 06:29
- 0107 - Pro for FLT & ConcurrencyConnections 13:48
- 0108 - New Feature Brain Dump forNew and Intermediate Users 08:50
- 0109 - The New Windows Interface 03:06
- 0113 - Basics of Sharing a Database 13:36
- 0115 - Upgrading 12, 13, 14, or 15Solutions to FM16 07:49
- 0117 - FM Pro Vs. Pro Advanced 02:26
2. FM Starting Point Walkthrough 19 Videos 03:28:00
- 0201 - FMSP Walkthrough - Intro 06:23
- 0202 - FMSP Device Support & LayoutOrganization 05:22
- 0203 - Script Numbering andOrganization 04:10
- 0205 - Whats new in FMSP 5? 06:30
- 0207 - FMSP Account & ContactsWalkthrough 17:24
- 0208 - FMSP Invoice Walkthrough 09:12
- 0211 - FMSP Sales Followups 14:37
- 0212 - FMSP Invoice - New Line Items- Advanced 14:25
- 0213 - FMSP Estimate to InvoiceTransfer Button - Customize it! 11:32
- 0214 - FMSP Calculating Margin andMarkup in Invoices 09:24
- 0216 - FMSP Unlimited RelatedDigital Document Upgrade 08:40
- 0219 - Calendar Under the Hood Part1 09:38
- 0220 - Calendar Under the Hood Part2 12:46
- 0221 - Tab Controls with Calculations 04:19
- 0230 - Dashboard Charts Part #1 11:22
- 0231 - Dashboard Charts Part #2 -Scripting 25:18
- 0232 - Dashboard Charts Part #3 -Performance 05:02
- 0235 - Managing Primary Keys 06:54
- 0240 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values 10:36
3. 0300 - Fundamentals & Basics 9 Videos 01:11:00
- 0301 - What is a Database - Part 1 05:49
- 0302 - What is a Database - Part 2 04:31
- 0303 - Modes in FileMaker 05:40
- 0304 - Browse Mode, and the Deletemenu item 06:29
- 0305 - Saving Data 02:02
- 0306 - Converting from .fp7 to.fmp12 file formats 10:49
- 0307 - Converting from .fp5 to .fp7file formats 09:30
- 0308 - How to make a Copy of a FMDatabase 05:10
- 0309 - What is a Relationship? 18:27
4. Performing Finds & Sorts 8 Videos 00:58:00
- 0401 - Finding Records - Basics 05:43
- 0402 - Finding - Multiple Requests 10:49
- 0403 - Finding Ranges of Dates 04:14
- 0404 - Finds with Special Operators 08:37
- 0405 - Finds and Indexing andPerformance, Stored Calcs 06:15
- 0406 - Finds Constrain and Extend 04:37
- 0407 - Sorting Records 07:38
- 0408 - Custom Sort Orders 07:42
5. 0500 - Working on Fields & Layouts 29 Videos 04:41:00
- 0501 - Layouts - Available tools 13:15
- 0502 - Tour of the Inspector 21:29
- 0503 - Intro to Adding Fields toDatabase (Text and Number) 12:11
- 0504 - Added Calc fields and HidingObjects 11:40
- 0505 - Creating a Survey & TabPanels & Value Lists 14:28
- 0506 - Value Lists - Under the hood 09:11
- 0507 - Hiding Objects & ConditionalFormatting 13:26
- 0508 - Text Fields with User SpecifiedFormatting 11:20
- 0509 - Merge Fields 04:36
- 0510 - Stored Vs UnstoredCalculations 11:22
- 0511 - 3 Types of Buttons and OneGlyph - Icon 09:36
- 0512 - Button Bar as New Data InputControl Style 03:05
- 0513 - Inline Field Labels 03:29
- 0514 - Layout Object Windows (LOW)(aka Layout Object Tree) 09:25
- 0515 - Tabs vs. Slide Controls 05:51
- 0516 - Popovers and New WindowCommand 09:43
- 0517 - Auto-Enter Options for Fields 08:00
- 0521 - Introduction to Single-User vs.Multi-User databases 09:25
- 0522 - Global Fields 10:44
- 0523 - Tooltips 07:08
- 0524 - Object Flags, or Badges 07:33
- 0525 - Object Alignment tools 11:44
- 0526 - Creating a new iOS Layoutfrom Scratch - Stencils 07:01
- 0527 - Field Validation Options 13:03
- 0528 - Repeating Fields 08:34
- 0530 - Layout Badge Tooltips 02:46
- 0539 - Custom Currency in FMSP 04:06
- 0540 - Formatting Currency - When itgoes into a Text Field 10:02
- 0545 - Hamburger Menus & InlineText Labels 06:07
6. 0550 - Containers Field & DocumentManagement 6 Videos 01:12:00
- 0551 - Container Field Introduction 11:40
- 0553 - Advanced Container FieldKung-Fu 11:01
- 0556 - Interactive Containers inFileMaker 15:35
- 0560 - Containers in FMSP 06:33
- 0562 - HiJacking Containers in FMStarting Point 17:02
- 0580 - When Container Storage goesBad... Recovery Plan... 08:38
7. 0600 - Advanced Layout Techniques 14 Videos 02:21:00
- 0601 - Making Layouts load 200%faster in FM 16 - Performance 07:16
- 0602 - 200% faster Part 2 -Performance 08:12
- 0603 - 200% faster Part 3 -Performance 02:53
- 0604 - Grouping with Slide Panels toHide Objects 05:45
- 0605 - Get Object Attribute forHidden Objects 02:52
- 0608 - Script Triggers - Intro 04:17
- 0609 - Script Triggers - LayoutSpecific 10:03
- 0610 - Script Triggers - Object Specific 07:51
- 0611 - Script Triggers - FieldValidations 10:12
- 0612 - Script Triggers - More Layoutscontrols 06:05
- 0614 - What is a Virtual List? ***Advanced *** 14:12
- 0615 - Hierarchical Portal forNavigation *** Advanced *** 16:49
- 0620 - Go to Related Record - GTRR 19:10
- 0622 - FileMaker 14 SVG Icon HelperTool 18:20
8. 0700 - Emailing, Imports and Exports 15 Videos 02:26:00
- 0701 - Sharing Data Intro 01:17
- 0702 - Importing Data 14:34
- 0703 - Exporting Data 07:59
- 0704 - Scripting Import & Exports -Basics 04:31
- 0706 - Send Email Script Step 03:53
- 0707 - Finding Your SMTP Settings 08:40
- 0708 - Automating outbound emails 06:51
- 0709 - Spamming with FileMaker 08:07
- 0710 - Automating Emailing ofExports, Like a PDF 02:00
- 0711 - Scripting FileMaker to Deletea File 11:36
- 0712 - Multi-Table Imports...Complex Imports 21:20
- 0713 - Upgrading Copies of FMSP,migrating / updating to a new release 09:16
- 0714 - Updating data in a FileMakertable from an Excel File 13:27
- 0720 - Using 360Works Email Pluginto Send HTML Emails 06:00
- 0725 - 360Works' CloudMail Install 16:15
9. 0800 - Integration 21 Videos 04:02:00
- 0803 - Barcode DeploymentPlanning & Options 12:20
- 0804 - Installing the BarcodeCreator into FMSP 07:21
- 0805 - Scanning Items into Invoiceswith Barcodes 02:25
- 0806 - Under-the-hood withScanner Barcodes In FMSP Part 1 07:20
- 0807 - Under-the-hood withScanner Barcodes In FMSP Part 2 08:40
- 0808 - Under-the-hood withScanner Barcodes In FMSP Part 3 12:52
- 0809 - USB Barcodes Gun We'reUsing 06:40
- 0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode 06:23
- 0811 - Viewer Questions & troubleshooting Barcodes 07:06
- 0812 - Infinite Peripherals BarcodeHardware for iPhone & iPad 11:29
- 0814 - Getting FileMaker Server toGenerate PDFs - PSOC 09:01
- 0815 - What is a FileMaker Robot? 08:40
- 0820 - Intro to Sending HTML emailsand SMS messages 07:15
- 0830 - Building a Progress Bar inFileMaker 12:19
- 0831 - Validating Emails with aService 08:27
- 0832 - Getting Driving DistanceFrom Google 08:45
- 0835 - Dialing VOIP Phone with SIP& X-Lite 10:13
- 0840 - Sending SMS with Twilio 10:38
- 0845 - Syncing to iPad or Syncing 2databases - MirrorSync 2 45:21
- 0846 - Clustering and Replication -MirrorSync 3 19:48
- 0847 - 360Works MirrorSync 4 05:24
10. 0900 - Writing Scripts 35 Videos 05:25:00
- 0901 - Scripting 09:58
- 0902 - Intro to Script Workspace 11:47
- 0903 - Workspace KeyboardShortcuts 10:56
- 0904 - Set fields vs. Copy, Paste 16:35
- 0905 - Set fields & Context 02:29
- 0906 - Buttons run one Command 15:02
- 0907 - Navigation 03:27
- 0908 - IF...THEN...decisions 06:30
- 0909 - Variables vs. Globals 06:05
- 0910 - Performing Finds 09:03
- 0911 - Basic Error Capture 10:26
- 0912 - Calling Subscripts - ScriptParameters 08:57
- 0913 - Advanced Script Parameters& Script Results 05:02
- 0914 - Looping Scripts 03:15
- 0917 - Preserving User Contextwhen running a Script 07:23
- 0918 - New Window - Script Step 14:06
- 0920 - Script Debugger - Part 1 20:54
- 0921 - Script Debugger - Part 2 03:11
- 0924 - Data Viewer 13:32
- 0932 - UI Indicators for DatabaseActivity 10:46
- 0940- Database PerformanceOptimization Overview 05:42
- 0941- Making Scalable Databases 11:26
- 0942- Server Evidence - SlowPerformance - Slow Scripts 03:28
- 0943 - Perform Script on Server -PSOS 20:10
- 0945 - PSOS in FMSP 07:11
- 0946 - Testing for PSOS Availability 12:27
- 0947 - SASE 10:31
- 0948 - Case Statement 02:09
- 0950 - Deduplicating Records, thePlan 07:56
- 0951 - Replace Command - A TigerLoose at the Zoo 08:03
- 0953 - Landmines in FileMaker 09:50
- 0955 - Testing to Make Sure YourScript has Access to a Record 07:40
- 0957 - Testing to See if a Field orvariable contains ONLY a number / Tri… 05:17
- 0965 - One Use Loop Technique 05:57
- 0968 - Go To Object 12:18
11. 1000 - Calculations 17 Videos 02:14:00
- 1001 - Calculation Engine & NewWork Space 13:21
- 1002 - Calculation Engine & NewWork Space Part 2 04:48
- 1010 - Parsing Text with Calcs - Part1 12:07
- 1011 - Parsing Text with Calcs - Part2 11:33
- 1012 - Detecting Window Mode andFilter Function 11:14
- 1013 - Date Calcs 05:11
- 1014 - Detecting Device & PlatformTypes 03:27
- 1020 - Get Functions Walkthrough -Part 1 08:51
- 1021 - Get Functions Walkthrough -Part 2 07:16
- 1022 - Get Functions Walkthrough -Part 3 03:39
- 1023 - Get Functions Walkthrough -Part 4 05:07
- 1024 - GetLayoutAttribute 05:26
- 1025 - GetContainerAttribute 05:15
- 1026 - Get(UUID) andGet(PersistentID) 08:11
- 1040 - List Function, Summary List,and GetValue 07:58
- 1042 - SortValues and UniqueValues 01:40
- 1045 - Get (ScriptName) - Understand Timing Issues... 16:37
12. 1100 - Relationships 20 Videos 03:39:00
- 1101 - What is a Relationship? 09:27
- 1102 - Table Occurrences Basics 11:52
- 1103 - Relationship Graph & ERDs 12:23
- 1104 - What is a Portal... and a Oneto Many Relationship? 06:42
- 1105 - Multi-Predicate Relationships 08:46
- 1106 - Multi-Key Relationships 11:01
- 1107 - Cascading Adds 07:24
- 1108 - Cascading Deletes 06:12
- 1111 - Portal Dialog Options 16:44
- 1112 - Portal Summary Sum Totals 07:14
- 1114 - Filtering Portals - RadioButtons 07:30
- 1120 - Lookup Values 13:12
- 1121 - Relookup Command -Updating One Time Relationships 08:06
- 1130 - Anchor Buoy DesignMethodology Part 1 09:23
- 1131 - Anchor Buoy DesignMethodology Part 2 07:31
- 1132 - Many to Many Relationships 14:37
- 1135 - Preference Table in yourSolution 07:08
- 1140 - Calculating and Primary Keywith the current Year 10:14
- 1150 - Multiple Page Invoices -Portal Management - Part 1 10:26
- 1151 - Multiple Page Invoices -Portal Management - Part 2 28:25
13. 1200 - Security 16 Videos 03:45:00
- 1201 - Security in FileMakerOverview 05:21
- 1202 - Accounts and Privileges 12:11
- 1203 - Extended Privileges...theBasics 10:26
- 1204 - Extended Privileges...RecentChanges 09:08
- 1205 - Encryption at Rest (EAR) 09:12
- 1206 - Point-to-Point Encryption -SSL Certificates 52:27
- 1207 - Audit Trails - Part 1 -Overview 12:25
- 1208 - Audit Trails - Part 2 -Technical 11:46
- 1209 - Audit Trails - Audits in FMSPPart 1 09:14
- 1210 - Audit Trails - Audits in FMSPPart 2 17:44
- 1211 - Audit Trails - Logging Recordsviewed - HIPAA 19:22
- 1213 - Security through Obscurity 07:55
- 1214 - Record Level Security 13:29
- 1215 - Layout and Process AccessControls - Restricting Staff 15:09
- 1216 - Hacking a FileMaker File...and Protecting It 07:56
- 1220 - CryptAuthCode SecurityFunctions 07:39
14. 1300 - FileMaker Server 7 Videos 02:36:00
- 1301 - Deployment & Sharing 19:10
- 1302 - FMS Admin Walkthrough 18:23
- 1303 - Scheduling Backups 14:45
- 1304 - Progressive Backups 04:48
- 1305 - Restoring from a Crash 18:58
- 1306 - Server PerformanceImprovements 14 - Nick Lightbody 44:07
- 1307 - Server PerformanceImprovements 15 - Nick Lightbody 31:27
15. 1400 - Printing & Report Creation 11 Videos 01:56:00
- 1401 - Printing and PDF Generation 13:14
- 1402 - Structuring your data so it isreportable 04:29
- 1403 - List View for Ad-HocReporting 04:09
- 1404 - Layout Parts on List View -for Beginners 09:34
- 1405 - FileMaker Report Wizard -Very Cool 10:20
- 1406 - Printing & Reporting onGovernment Forms 07:04
- 1407 - Subsummaries in Detail 11:17
- 1420 - State of Charting in FileMaker 13:00
- 1421 - Built-in Charting Overview 19:34
- 1422 - Google Charts 12:12
- 1425 - MultiPage Append to PDF 07:19
16. 1500 - Custom Functions 3 Videos 00:53:00
- 1501 - Top 10 FileMaker CustomFunctions (For Senior Developers) 17:46
- 1502 - Richard Carlton's Top 5FileMaker Custom Functions 13:44
- 1503 - Parsing XML - CustomFunction 16:40
17. 1600 - WebDirect 1 Videos 00:17:00
- 1602 - Creating PDF's and Emailingfrom WebDirect 16:34
18. 1700 - MISC 12 Videos 03:01:00
- 1701 - Performance Improvementsin 14 - Advanced 08:01
- 1702 - Database PerformanceTuning with Nick Lightbody 51:12
- 1704 - 3 Areas of PerformanceImprovement in Pro 15 10:25
- 1706 - 3 Area of PerformanceImprovement in Pro 14 09:29
- 1708 - How to make an AssetDatabase in 5 Minutes 07:59
- 1717 - PHP #1 - Overview 11:52
- 1718 - PHP #2 - Technical ProcessWalkthrough 10:34
- 1719 - PHP #3 - Sample CodeReview 16:55
- 1720 - Duplicate Module in FMSPPart 1 07:09
- 1721 - Duplicate Module in FMSPPart 2 14:42
- 1722 - Duplicate Module in FMSPPart 3 14:50
- 1723 - Duplicate Module in FMSPPart 4 12:07
19. 1800 - FileMaker Cloud 22 Videos 03:41:00
- 1802 - Detailed Comparison withRegular FileMaker Server 16:30
- 1803 - Is FileMaker Cloud Right foryou? 08:15
- 1804 - Brain Dump for ExperienceFileMaker Developers 16:38
- 1805 - How to Buy FMC - Directfrom AWS - New Users 18:30
- 1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses 17:27
- 1807 - Uploading files to FileMakerCloud 07:16
- 1809 - Picking the right size ofAmazon Server 09:43
- 1811 - Understanding Amazon'sTotal Cost 14:32
- 1812 - How to Save 50% to 75% onAmazon Instance 07:43
- 1813 - FMI Hourly Costs... withAWS...Switch to Annual 03:11
- 1814 - Restoring from a Backup(New Process) 11:02
- 1815 - Restoring from a Backup 07:06
- 1816 - Robot DB & Notifications 04:47
- 1817 - Automated Maintenance 07:55
- 1818 - EBS & Backups 07:32
- 1820 - Supersize my Server! 07:47
- 1822 - Detecting When a File isrunning on FileMaker Cloud 05:01
- 1824 - Instance Refresh &Emergency Procedures Part 1 10:51
- 1830 - Offboarding FileMaker Cloud 03:48
- 1840 - Intro T2 Burstable Instances,Performance, CPU Credits 09:59
- 1841 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large 03:17
- 1842 - Standard Usage Scenario 16:15
20. 1900 - FileMaker's Certification Test 4 Videos 00:48:00
- 1902 - Who takes the FileMakerCertification test? 05:19
- 1904 - What is FMI's Official StudyList Part #1 12:34
- 1905 - What is FMI's Official StudyList Part #2 15:53
- 1906 - Final Test Taking Tips... 10:43

Satisfaction Guaranteed

Testking provides no hassle product exchange with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

How The Guarantee Works?

Testking Valuable Customers

Testking is the world's largest certification preparation company with 99.6% Pass Rate History from 330803+ Satisfied Customers in 145 Countries.

Secure Shopping Experience

Your purchase with Testking is safe and fast. Your products will be available for immediate download after your payment has been received.

The Testking website is protected by 256-bit SSL from McAfee, the leader in online security.

Need help assistance? Contact us!

Customer Support