Got smarts? Get Savvy!

Attend this expert-led course to get better results in less time—guaranteed.

Savvy FM Essentials

The solution to the "you don't know what you don't know" problem

Best for...
  • Those seeking FileMaker certification
  • Intermediate to advanced developers
  • As a professional refresher or for updating knowledge to current version
Course Length & Price

3 days (9:00 a.m. to 5:00 p.m. each day); $495/day

Schedule of Upcoming Classes

To register for a specific class using a credit card, please select your class and complete the online registration form—or call us at 800.946.5433 to speak in person.

* April 13-15, 2010 (Tue-Thu) in Redwood City, CA Register Online
* June 15-17, 2010 (Tue-Thu) in Redwood City, CA Register Online

Classroom Location


Seaport Conference Center
459 Seaport Court
Redwood City, CA 94063
map & directions

 

Course Description

This 3-day course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 10. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.

The Savvy FM Essentials course is presented over 3 days and references the FileMaker Training Series (FTS), FileMaker's official curriculum (purchased separately) .

While a 3-day course can't cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer must-know techniques. Trainer Lee Lukehart has received instruction directly from FileMaker, Inc. on delivering the FTS, and has extensive knowledge of FileMaker best practices and know-how to accelerate learning and productivity.

Whether you're preparing for FileMaker 10 Developer Certification or you just want a convenient and effective way to improve your FileMaker Pro skills, Savvy FM Essentials is an indispensable path to greater proficiency. The FileMaker Training Series (FTS) is designed to help you master the essentials of FileMaker solution development.

The official 700-page manual (purchase directly from FileMaker Inc.) covers:

  1. Using FileMaker Pro - Approach FileMaker Pro 10 from the perspective of users: learn techniques for working with FileMaker data, printing and exporting, performing and saving Find requests, 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 10 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 10, including conditional formatting, auto-resize, web viewers, tab controls, and tooltips. Understand how field behavior and tab orders are controlled, and learn to create and use different kinds of value lists.
  5. Calculation Functions - Learn how functions work in the calculation engine in FileMaker Pro 10 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 new Script Trigger features of FileMaker Pro 10, 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 10 using a variety of techniques. Explore sub-summary reports that group information by break fields. 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 10 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 and Advanced Techniques - Work with relational value lists, write scripts that leverage object naming, and explore custom menus in depth. Learn advanced techniques with portals that include dynamic sorting, filtering, row highlights and preview panes.
  10. FileMaker Server - Learn the best practices for setting up and maintaining FileMaker Server 10 and FileMaker Server 10 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 10 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 10 and FileMaker Server 10 Advanced and learn how to develop solutions to publish via the web. Review the PHP Site Assistant and gain hands-on experience with IWP.

    Note: Emphasis on module content varies by class; please inquire in advance for the specific agenda.
Instructors

Our instructors are FileMaker Certified Developers, and are practicing consultants who bring valuable real-world experience and best practices to the classes they teach.