FileMaker Authorized Training Series For Ohio, Michigan, Kentucky, West Virginia, Indiana, and the Midwest.

FileMaker Training At The Computer Workshop, Inc.

The Computer Workshop offers a variety of FileMaker courses to fill your training needs. In addition to our Introduction course we offer additional courses that utilise the FileMaker Training Series curriculum.

Course Name	Modules	Number of Days	Price	Print Flier
FileMaker 9 Level 1 - Introduction To FileMaker		1	$295	Show Dates
Introduction to FileMaker Pro 11 (FileMaker Training Series)	1,2	1	$299*	Show Dates
Beginning Development with FileMaker Pro 11 (FileMaker Training Series)	3,4a,5a,6a,7	2	$645*	Show Dates
Intermediate Development with FileMaker 11 (FileMaker Training Series)	4b,5b,6b,8,9	2	$645*	Show Dates
FileMaker 11 Serving and Sharing (FileMaker Training Series)	10,11,12	2	$450*	Show Dates
All five days of FileMaker Training Series Core	1,2,3,4,5,6,7,8,9	5	$1549*	Call 800-639-3535

*Price for the individual FileMaker Training Series courses and the core series does not include the course manual which contains all 12 modules and is used for all FTS classes. This is a separate purchase. This manual costs $99 and can either be purchased from us or can be purchased at FileMaker's website ahead of time and brought with you the for the first day of class. All classes are taught on Windows machines provided by TCW unless other arrangements have been made. If you would rather take the FTS series using your own laptop (Windows or Mac) please feel free to bring it with you. Just give us a call to let us know in advanced.

What is the FileMaker Pro Training Series?

The FileMaker Training Series is the official training curriculum from FileMaker, Inc. It offers a series of 12 training modules that cover a comprehensive set of topics designed to help you master the essentials of FileMaker solution development. This new series incorporates the many new features of the FileMaker 11 product line throughout the modules.

This course will allow you to:

Learn best practices for developing professional database solutions with FileMaker 11 products.
Get results more quickly than using self-teaching methods.
Work with certified FileMaker experts who can answer your most technical questions.
Network with others and learn what they are doing and how they accomplish it.
Share your ideas and tips.

You should consider taking this course if you are:

Familiar with the basics and want a solid grounding in key FileMaker development principles.
Comfortable with FileMaker Pro and want to advance your development skills.
An expert developer and want to fill in any gaps in your knowledge.
Planning to become a FileMaker 11 Certified Developer.

Course materials:

In-depth course manual with 12 modules and over 700 pages of content.
A CD that includes demo files, exercises, videos, and PDFs of the manual.

Module description

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.

FileMaker says:

As a FileMaker Authorized Trainer, The Computer Workshop, Inc. has undergone training directly from FileMaker, Inc. to deliver the FileMaker Training Series programs and has extensive knowledge of FileMaker best practices and solutions. The courses are highly customized to accelerate learning and increase individual productivity. FileMaker recognizes and recommends The Computer Workshop, Inc. as a qualified trainer.