 |
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.
|
|
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.
|
|
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!
|
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.

|
|
|
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.
|
|
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!
|
|
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.
|
|
|
 |
s |
If you can't afford one of these classes, try the
FileMaker Reference.
It contains, scripts, calculations, interface graphics, errors and much more!
|
|