The FileMaker Training Series consists of 13 modules- presented over 5 days-that cover a comprehensive set of topics that provide the building blocks for successful FileMaker solution development.
Is the FileMaker Training Series right for you? Find out!

DAY BREAKDOWNS:

DAY ONE
Day One is the "Beginner" day. It is intended for users that are new to databases or new to FileMaker 11. This can serve as a great primer to get familiar with the product or to just get up to speed on the new version of FileMaker 11 if you have not used the product in some time. It is also a good idea to take this day if you plan to take the more intermediate modules later in the week. Not recommended for experienced FileMaker developers.

  • Using FileMaker Pro
  • Working with Fields
  • Working with Layouts

DAY TWO
Day Two and Day Three are considered the "Intermediate" modules. These are perfect for users with past experience in FileMaker or even those who just took the Beginner class. If you have used FileMaker in the past and have not had training or would like to enhance your current skillset, these days are good for you. They cover the fundamentals of FileMaker with discussion on the core elements of calculations, scripts and reports. These days also discuss the important concept of Relationships in FileMaker.

  • Data Modeling
  • Calculation Functions

DAY THREE

  • Scripts
  • Reporting

DAY FOUR
Day Four is meant for more Intermediate users who would like to explore next level concepts involved with FileMaker relationships as well as a discussion on FileMaker security (accounts and passwords).

  • Security
  • Intermediate and Advanced Techniques

Day 5
Day Five covers some specific concepts that are normally of interest to Intermediate users with support or IT responsibilities. This day covers options for publishing your databases to the web, sharing data with other applications and the setup and administration of FileMaker Server for network use.

  • FileMaker Server
  • Connectivity
  • Web Publishing

MODULE DESCRIPTIONS:

1. Using FileMaker: Approach FileMaker Pro 11 from the perspective of users: learn techniques for working with FileMaker data, performing Quick Finds, saving Find requests, printing and exporting, setting up recurring imports, and accessing features for working with email, Adobe PDF and Microsoft Excel documents.

2. Working with Fields: Learn practical skills required to define FileMaker Pro 11 data tables and fields. This module explores data types and options for auto-entry, validation, and field storage. Discover how to manage images and other objects in container fields and work with the Database Design Report in FileMaker Pro Advanced.

3. Data Modeling: Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. This module also covers lessons in building layouts using related data fields and portals.

4. Working with Layouts: Discover tools and techniques for creating layouts in FileMaker Pro 11, including the new Inspector tool, conditional formatting, auto-resize, web viewers, portals, and tab controls. Learn how to organize layouts into groups and how to set Script Trigger options. Understand how to create and use static, dynamic, and relational value lists.

5. Calculation Functions: Learn how functions work in the calculation engine in FileMaker Pro 11 and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions.

6. Scripts: Explore the Script Trigger features of FileMaker Pro 11, as well as best practices for writing scripts. Learn how to build navigation and window controls, and study logical branching and looping routines.

7. Reporting: Practice creating reports in FileMaker Pro 11 using a variety of techniques. Explore sub-summary reports that group information by break fields. Work with the new charting features of FileMaker Pro 11. Learn how to build a cross-tab report (with data-driven columns) and an HTML report that is displayed via the web viewer object.

8. Security: Study the account-based security features of FileMaker Pro 11, 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.

9. Intermediate & Advanced Techniques: Explore how to implement custom menu sets in FileMaker Pro 11. Learn advanced techniques with portals, including portal sorting and dynamically controlling the contents with a portal with a filter. Use advanced scripting techniques and Script Triggers to implement an audit trail.

10. FileMaker Server: Learn the best practices for setting up and maintaining FileMaker Server 11 and FileMaker Server 11 Advanced. Understand how and why to use server-side scripts. Review hardware and networking requirements, learn proper backup routines, and be trained in configuration processes.

11. Connectivity: Learn how to integrate FileMaker 11 with SQL systems, both through ODBC connections and with the External SQL Data Source capabilities. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.

12. Web Publishing: Understand the capabilities of both Instant Web Publishing (IWP) and Custom Web Publishing in FileMaker Pro 11 and learn how to develop solutions to publish via the Web. Review the PHP Site Assistant and gain hands-on experience with IWP.

13. FileMaker Go: Understand tools and behaviors to start you on your way to building solid and stable solutions for the iPhone and iPad.