[Forums] [Shop] [Resources] [Training] [About] [Solutions] [Consulting] [News] [Links]

Questions s I offer personalized FileMaker training, on-site or off-site. If you would like training customized to your specific needs or onsite training, please contact me at jmo@filemakerpros.com. I am located in Chino Hills, California. My phone number is 909-393-4664. Listen to my podcast interview about training and learn about my philosophy on training.






Jump to the category you want:
Hands-on Training:

 FileMaker Training Series
 Philosophy of Scripting Training
 Beyond the Basics
 Reporting
Other Training Options:

 FileMaker 9 Videos
 Self-Paced Training
 Onsite Training
 Training Testimonials
 FREE Online Training!
 Phone Training and Consulting
FileMaker Training Series
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. Authorized Trainer

Subjects include FileMaker Pro Server, Relational Database Design, Scripting, Calculations, Reporting and Connectivity. Database Pros is one of only twelve trainers in the United States authorized to teach these courses.

New FileMaker 9 features will be covered!

Find out More!



* Download a PDF containing all my information on private and public training [MAC] [WIN]
Philosophy of Scripting Training
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. Philosophy of Scripting 201 is a two day advanced scripting and calculation course.

The curriculum for these classes has been rewritten from the ground up to include more hands-on exercises and the latest techniques for FileMaker Pro 7, 8, 8.5 and 9!

Find out More!!!

To find out more about the curriculum, dates and locations or to register for a class, click on More Philosophy of FileMaker Class Information.
John Mark Osborne helping a student.

* Download a PDF containing all my information on private and public training [MAC] [WIN]
Beyond the Basics
Beyond the Basics is based on the original Relational Database Design course from Claris Corporation covering one-to-many, many-to-many and one-to-one relationships as well as ER diagramming. Finds, Sorts, Importing, Exporting, Scripting, Reporting, Calculations and much more have been added to this two day curriculum. An extra day of web publishing and advanced topics can be added to the curriculum.

To find out more about the curriculum click on More Beyond the Basics Class Information.

* Download a PDF containing all my information on private and public training [MAC] [WIN]
Reporting
This class has a boring name but reporting is one of the most important skills to have under your belt beyond relational design and scripting. Too many people don't think about reporting until after they have designed their database. This class teaches you to think about what reports you will need before it is too late to change the structure of your system.

- Summary fields including Fraction of Total
- Subsummary parts
- Multiple subsummary parts
- Percentages
- GetSummary function
- Calculations
- Automation (Scripting)
- Reports with Columns
- Sliding Objects
- Finds (restoring)
- Sorts (restoring)
- Page Breaks
- Grand Summaries
- Headers and Footers
- Insert items
- Page Totals (e.g. page 4 of 10)
- Custom titles
- Creating a phone directory
- Printing portals the right way
- Printing one of each like label

This class is only taught privately for FileMaker versions 3, 4, 5, 5.5 and 6. To find out more, contact John Mark Osborne.

* Download a PDF containing all my information on private and public training [MAC] [WIN]
Video Training
Hundreds of hours of video training, ranging from beginner to intermediate to advanced to expert relational design, scripting, calculations, PHP and much more. FileMaker Server and Server Advanced are also covered! Click below for more information.

 - Beginner, Intermediate and Advanced Bundle

 - FileMaker 9 & PHP Foundations

 - Other FileMaker Videos from VTC

Purchase one or all of these videos

You can purchase video training online from the Database Pros secure web site using a Visa or MasterCard credit card. I'm so sure you love this course that I offer a money back guarantee if you are not fully satisfied after viewing them in their entirety.

Visa   MasterCard
Self-Paced Training
If you can't afford to visit one of my hands-on training sessions, try this self-paced version of the Philosophy of Scripting 101. It covers intermediate scripting and calculations.

Find out More!!!

To find out more, click on More Self-Paced Training Information.


Purchasing

You can purchase this self-paced course online from the Database Pros secure web site using a Visa or MasterCard credit card. I'm so sure you love this course that I offer a money back guarantee if you are not fully satisfied after viewing them in their entirety.

Visa   MasterCard
Onsite Training
I'd love to come to your company site and teach you FileMaker Pro intermediate and advanced scripting, calculations, relationships and other techniques. If you have five or more employees, the cost is about half the price of sending them all to one of my public training sessions.

I offer the following courses for private training:

- Professional Training Foundation Series +
- Beyond the Basics ^
- Philosophy of Scripting 101 *
- Philosophy of Scripting 201 *
- Reporting
- Web Publishing

+ The Professional Foundation Series classes are also taught publicly across the United States. More information..

* The Philosophy of Scripting classes are also taught publicly across the United States. More information..

^ Beyond the Basics is a favorite class of FileMaker, Inc. where I teach their employees. More information on Beyond the Basics.

If you'd like to find out more, send me an email at jmo@filemakerpros.com or call me at my office in California at 909-393-4664.
Training Testimonials
I really love teaching people how to use FileMaker Pro. It is so exciting to see that light bulb go off in students' heads when they finally understand a FileMaker concept or learn something they never thought FileMaker could accomplish.

If you are struggling with the cost, travel or time commitment for a quality FileMaker class, perhaps some former students of mine can convince you. I get tons of testimonials every time I teach a class, and I am always amazed at how my classes change the lives of the students. Click on the training testimonials link to see how my classes have changed people's FileMaker lives!
FREE Online Training!
Here are some free online training courses I developed for FileMaker 3, 4, 5 or 6. They are very high quality with screen shots and download files. They are geared towards the intermediate to advanced FileMaker user. Please let me know if you'd like to see more!

Irregular Buttons   Field Filters   Find Similar  
Disappearing Buttons   Field Labels   Isolating a Record  
Changing Buttons   3D Fields   Ultimate Find  
Animating Buttons   Popup Menus   Save a Found Set  
Savvy Buttons   Disappearing Fields   Find Mode Buttons  
Idiot Proofing 1   Idiot Proofing 5    Show Message 1  
Idiot Proofing 2   Idiot Proofing 6    Show Message 2  
Idiot Proofing 3   Idiot Proofing 7    Show Message 3  
Idiot Proofing 4   Idiot Proofing 8    Show Message 4  
 Show Message 5    Restoring a Find  
 Restoring a Sort    Better Find Restore?  
 Restoring Import/Export    Updating the Find Criteria  
 Restoring Page Setup    Restoring Enter Find Mode  
Phone Training and Consulting
If you can't afford the time away from work or you require a very specific solution, I offer over-the-phone training and consulting. This allows you to customize the training to a specific area. I'll even send you FileMaker files demonstrating any techniques we cover on the phone.

If you are interested in talking to me, call 909-393-4664 PST or email me at jmo@filemakerpros.com.

Exclamation s If you can't afford one of these classes, try the FileMaker Reference. It contains, scripts, calculations, interface graphics, errors and much more!


Video Training