Log in
Hot & Trending on FMT

Advanced FileMaker Training Series

Featured Advanced FileMaker Training Series

We train from the FileMaker Training Series: Advanced curriculum, the official training curriculum from FileMaker, Inc. Our FTS: Advanced course is offered in 2-Day and 4-Day sessions to better serve your needs. We refer to the 2-Day training as Parts 1 and 2. Part 1 covers Modules 1–4 from the FTS book and Part 2 covers Modules 5–8. This training course will take you deeper into what FileMaker Pro 13 Advanced has to offer, while adding to your skills as a developer. As a student, you receive a printed copy with DVD when you take the course. Covered topics: Data Modeling, Layouts, Scripting, Calculations, FileMaker Server, and Security.

Course Outline

1. Introductionicon_get_started_quickly
Begin your journey of building solid business solutions by learning the steps of planning, creating and deploying successful solutions on the FileMaker Platform. This section gives you an introduction to the foundation and design phase when starting a new project and the key principles to consider for any project such as user experience, building for different devices, and performance.

2. Dataicon_data_viewer
Gain practical skills required to define FileMaker Pro 13 data tables and fields. Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. Cover important topics such as data types and options for auto-entry, validation, field storage and indexing. Plus, learn how to manage images and other objects in container fields.

3. Interfaceicon_design_tools
Learn how to work efficiently and effectively with layouts, an essential skill for any developer. For solutions accessed by mobile, desktop, and web users, layouts can be tailored to take full advantage of the specific environment, providing for a great user experience. The lessons in this module explore different types of layout objects and the tools and methods for controlling them.

4. Solution Logic: Calculationsicon_custom_functions
Learn how functions work in the calculation engine and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions. Lessons also include the set of functions that are especially useful when developing for the mobile user. And discover new functionality in FileMaker Pro 13 for accessing metadata stored with container field data.

5. Solution Logic: Scriptingicon_script_debugger
Explore the power of the scripting in FileMaker Pro 13, which allows you to create scripted routines that can then be triggered in a variety of ways. Learn about a number of scripting tools that make it easier to write and troubleshoot scripts, as well as best practices for writing scripts, and scripting for the mobile user. Learn how to build navigation and window controls, create custom menus, and study logical branching and looping routines.

6. Reportingicon_reports
Practice creating reports in FileMaker Pro 13 using a variety of techniques. Explore basic and advanced sub-summary reports and learn how to build a cross-tab report (with data-driven columns). And see how the ExecuteSQL function can be extremely useful for creating reports and charts with its ability to quickly find, sort and even aggregate data.

7. Securityicon_security
Become familiar with the security controls in FileMaker Pro and their relevance to FileMaker Go, FileMaker WebDirect, and Custom Web Publishing. Study the account-based security features of FileMaker Pro 13, 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. Learn how to encrypt FileMaker files and network communication and why doing this is important.

8. Deploymenticon_ipad_iphone
Understand the various techniques for a deploying a FileMaker solution, with particular considerations for the new FileMaker WebDirect technology, as well as considerations specific to FileMaker Go. Get best practices for installing and configuring FileMaker Server, and learn how to trigger scripts from FileMaker Pro as well as operating system scripts from FileMaker Server.

9. Integrationicon_integrate
Learn how to integrate FileMaker Pro 13 with SQL systems, both through ODBC connections and with the External SQL Data Source capabilities. Discover how the integration of FileMaker with web services opens up a wealth of possibilities for your FileMaker solutions. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.

Why Train With Us?


Why Come To Simpsonville, South Carolina?


Next class starts on 9/22/2014

Upcoming 2014 Classes: September 22-25 • October 27-30 • November 17-20

Part 1, Part 2 – $635
Parts 1 & 2 – $1,200

The Scarpetta Group

The Scarpetta Group, Inc. is a Platinum FileMaker Business Alliance Member, specializing in custom FileMaker solutions for desktop, iOS and web. Our expertise is understanding our clients’ needs and translating their requirements into successful software solutions that enhance their business, improve efficiency and streamline workflows. We accomplish this through years of project management, diverse skill sets and industry experience.

Whereas many development firms handle only FileMaker development, we leverage our web development strengths and vast knowledge of bringing FileMaker to the web to set us apart. With more than 15 years of experience, The Scarpetta Group has completed countless projects for small businesses to international Fortune 500 companies. These projects have ranged from single iPad applications using FileMaker Go to 100+ user management systems, CRMs, Content Management Systems, Custom PHP APIs and complex web applications.

In the last five years, The Scarpetta Group has grown from a single employee and a team of subcontractors to five full time developers and a team of subcontractors. In 2013 The Scarpetta Group began hosting a FileMaker Pro User Group that has proven to be very successful and considered to be one of the larger user groups in the Southeast.

No matter what data challenges your company faces, The Scarpetta Group has the expertise to lead you in the right direction with your data management and get your company on the road to efficiency. Contact us today.

Website: scarpettagroup.com