Training Schedule
Welcome to the FMPug training calendar.
If you see the "Save" tag check to see the FMPug member discount for that course.
Sort listing by...
There are 29 classes currently scheduled in our calendar. If you are looking for a class from a particular training company use the list below to narrow your results.
July
Mon 28th Jul to Thu 31st Jul in Columbus, OHFileMaker Training Series

Mon 28th Jul to Thu 31st Jul
Instructor: Brinsley Barreto
Cost of class: $1995
Please visit www.cornetser.com/training for more details.
Tue 29th Jul to Fri 01st Aug in San Mateo, CA
FTS FileMaker 9 Core Essentials (SFO)

Tue 29th Jul to Fri 01st Aug
Instructor: Lee Lukehart
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
August
Tue 05th Aug in Chicago, IL
Intro to FileMaker Pro

Tue 05th Aug
Instructor: Paul Mitchell
Cost of class: $295
FMPug Discount
$50 off (enter coupon code int7ke-pug on online registration form or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_fmpintro.php
The class walks students through the basics of FileMaker Pro 8 including its various modes and how to navigate among records, layouts, tables and files. In the process of creating their database, students will learn how to work other file types such as images and external documents, organize data within the database and create printable reports.
The class concludes with an overview of the help features and online resources for FileMaker Pro 8. Students will be well equipped to address many of the challenges they will face when they return to their organization.
Tue 05th Aug in San Mateo, CA
Intro to FileMaker Pro

Tue 05th Aug
Instructor: David Simerly
Cost of class: $295
FMPug Discount
$50 off (enter coupon code int7ke-pug on online registration form or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_fmpintro.php
The class walks students through the basics of FileMaker Pro 8 including its various modes and how to navigate among records, layouts, tables and files. In the process of creating their database, students will learn how to work other file types such as images and external documents, organize data within the database and create printable reports.
The class concludes with an overview of the help features and online resources for FileMaker Pro 8. Students will be well equipped to address many of the challenges they will face when they return to their organization.
Wed 06th Aug in Rockville, MDLearning FileMaker Pro: Introduction

Wed 06th Aug
Instructor: Brinsley Barreto
Cost of class: $349
Please visit www.cornetser.com/training for details.
Tue 12th Aug to Fri 15th Aug in Chicago, IL
FTS FileMaker 9 Core Essentials (CHI)

Tue 12th Aug to Fri 15th Aug
Instructor: Jim Medema
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
Wed 13th Aug in Rockville, MDLearning FileMaker Pro: Intermediate

Wed 13th Aug
Instructor: Brinsley Barreto
Cost of class: $399
Thu 14th Aug in San Mateo, CA
Advanced Techniques in FileMaker, by the Author

Thu 14th Aug
Instructor: Scott Love
Cost of class: $495
FMPug Discount
$50 (enter Coupon Code "atif-8cb-pug" via the online registration form, or call 800.582.0170)
This one-day class is based on Module 9 of the official FileMaker Training Series (FTS), taught by the author of that module, Mr. Scott Love.
A developer's learning is progressive: Once you are familiar with most of FileMaker's features, the next skill-building step is to creatively combine these features in ways that enhance the capability and usability of your solutions. This applied-knowledge approach is the indispensable trademark of a professional developer.
In this class, you'll learn intermediate and advanced techniques that provide capabilities frequently requested in real-world situations. Equally important, you’ll gain invaluable professional insights while examining and constructing these interface solutions. So come prepared to expand your skills, as Scott takes you on an in-depth exploration of into this mindset.
You should seriously consider taking this course if you are:
* A past participant of Soliant's FileMaker 9 Core Essentials course
* An intermediate-level developer wanting to boost your development skills
* An advanced developer wanting to expand your FileMaker repertoire
* An expert developer wanting a focused refresher
This class focuses on using standard FileMaker features as building blocks for enhancing a solution's functionality, so any modestly accomplished developer will benefit.
Please visit http://www.soliantconsulting.com/training/descrip_fts_module09.php for class schedules and a detailed course description. From there you can register online, and be sure to use the coupon code "atif-8cb-pug" to receive the special pricing.
------
Educational Offerings from Soliant Consulting
We provide various monthly trainings at our classrooms in Chicago and the San Francisco Bay Area. We also offer on-site instruction, customizable to your needs. Sending one of six FileMaker authorized instructors to your location may be a cost-effective training alternative for you, saving attendee travel costs and time. Please contact us at training@soliantconsulting.com to explore whether on-site is the optimal option for your organization.
Tue 19th Aug to Fri 22nd Aug in San Mateo, CA
FTS FileMaker 9 Core Essentials (SFO)

Tue 19th Aug to Fri 22nd Aug
Instructor: Lee Lukehart
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
Wed 20th Aug in Rockville, MDLearning FileMaker Pro: Advanced

Wed 20th Aug
Instructor: Brinsley Barreto
Cost of class: $399
Tue 26th Aug to Fri 29th Aug in Berwyn, PA
FTS FileMaker 9 Core Essentials (PHI)

Tue 26th Aug to Fri 29th Aug
Instructor: Lee Lukehart
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
September
Thu 04th Sep in Chicago, IL
Intro to FileMaker Pro

Thu 04th Sep
Instructor: Paul Mitchell
Cost of class: $295
FMPug Discount
$50 off (enter coupon code int7ke-pug on online registration form or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_fmpintro.php
The class walks students through the basics of FileMaker Pro 8 including its various modes and how to navigate among records, layouts, tables and files. In the process of creating their database, students will learn how to work other file types such as images and external documents, organize data within the database and create printable reports.
The class concludes with an overview of the help features and online resources for FileMaker Pro 8. Students will be well equipped to address many of the challenges they will face when they return to their organization.
Tue 09th Sep to Fri 12th Sep in Chicago, IL
FTS FileMaker 9 Core Essentials (CHI)

Tue 09th Sep to Fri 12th Sep
Instructor: TBA
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
Tue 09th Sep in San Mateo, CA
Intro to FileMaker Pro

Tue 09th Sep
Instructor: David Simerly
Cost of class: $295
FMPug Discount
$50 off (enter coupon code int7ke-pug on online registration form or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_fmpintro.php
The class walks students through the basics of FileMaker Pro 8 including its various modes and how to navigate among records, layouts, tables and files. In the process of creating their database, students will learn how to work other file types such as images and external documents, organize data within the database and create printable reports.
The class concludes with an overview of the help features and online resources for FileMaker Pro 8. Students will be well equipped to address many of the challenges they will face when they return to their organization.
Mon 15th Sep in Bothell, WAIntroduction to FileMaker 9

Mon 15th Sep
Instructor: Jason Young
Cost of class: $300.00
Covers FTS Module:
1) Using FileMaker Pro:
Approach FileMaker Pro 9 from the perspective of users: learn techniques for working with FileMaker data, printing & exporting, performing Find requests, and accessing features for working with email, Adobe PDF and Microsoft Excel documents.
Prerequisite – This class serves as an introduction to FileMaker 9 for the user and beginning developer.
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Tue 16th Sep to Wed 17th Sep in Woodinville, WA
FileMaker 9 Developer Skills 1

Tue 16th Sep to Wed 17th Sep
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
2) Working with Fields:
Learn practical skills required to define FileMaker Pro 9 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:
Review new features in FileMaker Pro 9, such as conditional formatting and auto-resize, while learning how to work with layout objects. Understand how field behavior and tab orders are controlled, learn to create different kinds of value lists, and work with the Web Viewer object, Tab Control object, and Tool Tips.
5) Calculation Functions:
Learn how functions work in the calculation engine in FileMaker Pro 9. Study how custom functions are built and how to best apply them to database solutions.
Prerequisite – Introduction to FileMaker or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Tue 16th Sep to Fri 19th Sep in San Mateo, CA
FTS FileMaker 9 Core Essentials (SFO)

Tue 16th Sep to Fri 19th Sep
Instructor: Lee Lukehart
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
Thu 18th Sep to Fri 19th Sep in Woodinville, WA
FileMaker 9 Developer Skills 2

Thu 18th Sep to Fri 19th Sep
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
6) Scripting:
User controls and interface elements are generally driven through scripts in FileMaker Pro 9. Explore best practices in scripting, learn how to build navigation and window controls, and study logical branching and looping routines.
7) Reporting:
Practice creating reports in FileMaker Pro 9 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 9 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:
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.
Prerequisite – FileMaker 9 Developer Skills 1 or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Tue 23rd Sep to Fri 26th Sep in Berwyn, PA
FTS FileMaker 9 Core Essentials (PHI)

Tue 23rd Sep to Fri 26th Sep
Instructor: TBA
Cost of class: $1595
FMPug Discount
$150 (enter Coupon Code from FMPug Discount Area via the online registration form, or call 800.582.0170)
Link: http://www.soliantconsulting.com/training/descrip_series4.php
This 4-day FileMaker-authorized course helps you master the essential skills required for developing and deploying solutions in FileMaker Pro 9. Highly interactive instruction and hands-on exercises focus on providing students with a solid foundation in using the FileMaker Pro family of technologies.
FileMaker 9 Core Essentials are presented over 4 consecutive days, drawing from the 70+ lessons in FileMaker's official curriculum, the FileMaker Training Series (FTS). While a 4-day course can't provide enough time to cover the entire FTS body of knowledge, our classroom agenda is packed with crucial how-to knowledge and professional developer best practices. The included CD and 591-page training manual include step-by-step instruction and 27 videos of exercise solutions, so you'll be able to retain the knowledge you gained in class by revisiting the lessons.
Whether you're preparing for FileMaker 9 Developer Certification (exam available soon), or you just want a convenient and effective way to improve your FileMaker Pro skills, the FTS is an indispensable path to greater proficiency.
October
Thu 02nd Oct in Chicago, IL
Advanced Techniques in FileMaker, by the Author

Thu 02nd Oct
Instructor: Scott Love
Cost of class: $495
FMPug Discount
$50 (enter Coupon Code "atif-8cb-pug" via the online registration form, or call 800.582.0170)
This one-day class is based on Module 9 of the official FileMaker Training Series (FTS), taught by the author of that module, Mr. Scott Love.
A developer's learning is progressive: Once you are familiar with most of FileMaker's features, the next skill-building step is to creatively combine these features in ways that enhance the capability and usability of your solutions. This applied-knowledge approach is the indispensable trademark of a professional developer.
In this class, you'll learn intermediate and advanced techniques that provide capabilities frequently requested in real-world situations. Equally important, you’ll gain invaluable professional insights while examining and constructing these interface solutions. So come prepared to expand your skills, as Scott takes you on an in-depth exploration of into this mindset.
You should seriously consider taking this course if you are:
* A past participant of Soliant's FileMaker 9 Core Essentials course
* An intermediate-level developer wanting to boost your development skills
* An advanced developer wanting to expand your FileMaker repertoire
* An expert developer wanting a focused refresher
This class focuses on using standard FileMaker features as building blocks for enhancing a solution's functionality, so any modestly accomplished developer will benefit.
Please visit http://www.soliantconsulting.com/training/descrip_fts_module09.php for class schedules and a detailed course description. From there you can register online, and be sure to use the coupon code "atif-8cb-pug" to receive the special pricing.
------
Educational Offerings from Soliant Consulting
We provide various monthly trainings at our classrooms in Chicago and the San Francisco Bay Area. We also offer on-site instruction, customizable to your needs. Sending one of six FileMaker authorized instructors to your location may be a cost-effective training alternative for you, saving attendee travel costs and time. Please contact us at training@soliantconsulting.com to explore whether on-site is the optimal option for your organization.
Mon 20th Oct to Tue 21st Oct in Woodinville, WA
FileMaker 9 Developer Skills 1

Mon 20th Oct to Tue 21st Oct
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
2) Working with Fields:
Learn practical skills required to define FileMaker Pro 9 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:
Review new features in FileMaker Pro 9, such as conditional formatting and auto-resize, while learning how to work with layout objects. Understand how field behavior and tab orders are controlled, learn to create different kinds of value lists, and work with the Web Viewer object, Tab Control object, and Tool Tips.
5) Calculation Functions:
Learn how functions work in the calculation engine in FileMaker Pro 9. Study how custom functions are built and how to best apply them to database solutions.
Prerequisite – Introduction to FileMaker or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Mon 20th Oct to Fri 24th Oct in San Jose, CA
FileMaker Training Series

Mon 20th Oct to Fri 24th Oct
Instructor: John Mark Osborne & Steven Blackwell
Cost of class: $2,000.00
FMPug Discount
If you take all 5 days of the course, enjoy an additional $250.00 discount.
These training classes were created by FileMaker, Inc. to teach students how to optimize the development, deployment and administration of real-world FileMaker Pro solutions across any size organization. Subjects include FileMaker Pro Server, Relational Database Design, Scripting, Calculations, Reporting and Security. Database Pros is one of only twelve trainers in the United States authorized to teach these courses.
Wed 22nd Oct to Thu 23rd Oct in Woodinville, WA
FileMaker 9 Developer Skills 2

Wed 22nd Oct to Thu 23rd Oct
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
6) Scripting:
User controls and interface elements are generally driven through scripts in FileMaker Pro 9. Explore best practices in scripting, learn how to build navigation and window controls, and study logical branching and looping routines.
7) Reporting:
Practice creating reports in FileMaker Pro 9 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 9 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:
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.
Prerequisite – FileMaker 9 Developer Skills 1 or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Fri 24th Oct in Woodinville, WA
FileMaker 9 Server Admin, Connectivity & the W...

Fri 24th Oct
Instructor: Jason Young
Cost of class: $395.00
FMPug Discount
Covers FTS Modules:
10) FileMaker Server:
Learn the best practices for setting up and maintaining FileMaker Server 9 and FileMaker Server 9 Advanced. Review hardware and networking requirements, learn proper backup routines, and be trained in configuration processes.
11) Connectivity:
Learn how to integrate FileMaker 9 with SQL systems, both through ODBC connections and with the new External SQL Data Source capabilities in FileMaker Pro 9. 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 9 and learn how to develop solutions to publish via the Web. Review the PHP Site Assistant and gain hands-on experience with IWP.
Prerequisite – Instructor Permission Required (Class content will vary slightly depending on student requirements. Speak with an instructor for more information.)
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
November
Mon 17th Nov in Bothell, WA
Introduction to FileMaker 9

Mon 17th Nov
Instructor: Jason Young
Cost of class: $300.00
FMPug Discount
Covers FTS Module:
1) Using FileMaker Pro:
Approach FileMaker Pro 9 from the perspective of users: learn techniques for working with FileMaker data, printing & exporting, performing Find requests, and accessing features for working with email, Adobe PDF and Microsoft Excel documents.
Prerequisite – This class serves as an introduction to FileMaker 9 for the user and beginning developer.
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Tue 18th Nov to Wed 19th Nov in Woodinville, WA
FileMaker 9 Developer Skills 1

Tue 18th Nov to Wed 19th Nov
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
2) Working with Fields:
Learn practical skills required to define FileMaker Pro 9 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:
Review new features in FileMaker Pro 9, such as conditional formatting and auto-resize, while learning how to work with layout objects. Understand how field behavior and tab orders are controlled, learn to create different kinds of value lists, and work with the Web Viewer object, Tab Control object, and Tool Tips.
5) Calculation Functions:
Learn how functions work in the calculation engine in FileMaker Pro 9. Study how custom functions are built and how to best apply them to database solutions.
Prerequisite – Introduction to FileMaker or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
Thu 20th Nov to Fri 21st Nov in Woodinville, WA
FileMaker 9 Developer Skills 2

Thu 20th Nov to Fri 21st Nov
Instructor: Jason Young
Cost of class: $650.00
FMPug Discount
Covers FTS Modules:
6) Scripting:
User controls and interface elements are generally driven through scripts in FileMaker Pro 9. Explore best practices in scripting, learn how to build navigation and window controls, and study logical branching and looping routines.
7) Reporting:
Practice creating reports in FileMaker Pro 9 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 9 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:
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.
Prerequisite – FileMaker 9 Developer Skills 1 or Instructor Permission
8:30 am to 4:30 pm with a one hour lunch
Requirements:
- Laptop (either Mac or Windows) with a working CD-ROM drive (Rentals available through SMI).
- Adobe Acrobat Reader.
- FileMaker 8 or higher (FileMaker 9 preferred).
January
Mon 26th Jan to Fri 30th Jan in San Jose, CA
FileMaker Training Series

Mon 26th Jan to Fri 30th Jan
Instructor: John Mark Osborne & Steven Blackwell
Cost of class: $2,000.00
FMPug Discount
If you take all 5 days of the course, enjoy an additional $250.00 discount.
These training classes were created by FileMaker, Inc. to teach students how to optimize the development, deployment and administration of real-world FileMaker Pro solutions across any size organization. Subjects include FileMaker Pro Server, Relational Database Design, Scripting, Calculations, Reporting and Security. Database Pros is one of only twelve trainers in the United States authorized to teach these courses.
February
Mon 02nd Feb to Fri 06th Feb in San Jose, CA
Philosophy of Scripting 101 and 201

Mon 02nd Feb to Fri 06th Feb
Instructor: John Mark Osborne
Cost of class: $995.00
FMPug Discount
Take both classes and receive an additional $250.00 discount for a total of $1,500.00.
These are the classes I developed based on my wildly popular book and CD ROM, Scriptology - FileMaker Pro Demystified. Philosophy of Scripting 101 is a three day intermediate scripting and calculation course for $995.00. Philosophy of Scripting 201 is a two day advanced scripting and calculation course for $995.00. Take both courses and save $250.00 for a final total of $1,750.00.



















