Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit instead

FileMaker Pro 12: Advanced

  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course
  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course
  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course
  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course
  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course
  • FileMaker Pro 12: Advanced, Singapore SKillsFuture elarning online course

Course Description

FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts, script triggers and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.

Discover how data can be managed efficiently.

- Find out how you can manage your database
- Learn ways to fully utilize your data's potential
- Know how queries can be implemented to run the data better
- Understand an effective solution to optimize your database's productivity

This course is SkillsFuture Credit Eligible.

Course Objectives

1. Understand the introduction to FileMaker 
2. Know how to navigate the interface of FileMaker 
3. Know how to add customized functions to the database
4. Understand the advanced functions in FileMaker 

Related Courses

  • Microsoft Outlook: Training for 2016, 2010, 2013 and More

    Microsoft Outlook: Training for 2016, 2010, 2013 and More

    SGD $99.00

    Course Description

    From a redesigned look to advanced e-mail organization, search and communication features, Microsoft Outlook provides you with a world-class experience to stay productive and in touch with your personal and education networks. Learn how to use Microsoft® Outlook® 2010 to 2016. In this online tutorial series, you'll learn how to create a rule or alert for email messages, schedule a meeting in your calendar, create or edit your email signature and more.Stay on top of your game using Microsoft Outlook.- Learn how to manage your email, calendar and tasks with Microsoft Outlook - Learn how you can customize Microsoft Outlook to cater to your preferences - Know more about the other features that are included in Microsoft Outlook- Adopt Microsoft Outlook into your daily work routine with knowledge from this course This course is SkillsFuture Credit Eligible.


  • Utilize your Business Intelligence with Analytics

    Utilize your Business Intelligence with Analytics

    SGD $45.00

    Course Description

    Data is the fuel that powers modern business and the ability to aggregate and quickly slice and dice data to make accurate, timely decisions is vital in today's environment. Business intelligence is the set of techniques and tools that transform raw, day-to-day, operational data into categorized, aggregated, useful information for fast business analysis purposes. Microsoft's business intelligence tools including SQL Server 2014, SQL Server Analysis Services, Visual Studio/SSDT and Excel provide end users with the power to perform self-service BI and it provides developers the tools they need to create enterprise level BI systems. In this course, Mark Long, teaches you how to work with these tools to create multidimensional data cubes and Microsoft's new tabular data model to provide BI services and help you prepare for Microsoft's certification exam 70-466 Implementing Data Models and Reports with SQL Server.Data plays an integral part in understanding analysis.- Learn how to maintain your database - Know how you should sort your data in SQL Server - Learn about the different functions of data warehouse- Be able to handle and monitor the activity in your database This course is eligible for SkillsFuture Credit.  


  • Sony Vegas Pro 10

    Sony Vegas Pro 10

    SGD $49.00

    Course Description

    Sony's 'Vegas Pro 10' is the latest update to the extremely popular professional digital video editing software. In this course, students are shown important user interface features and their positions on the main Vegas screen. Then, using the included work files, author Mark Struthers goes on to demonstrate how to produce a complete DVD from the timeline. Along the way, audio is scrutinized as is the use of the integrated mixer. Editing functions are inspected and tips and tricks such as track management feature throughout. As the student gains more knowledge, the course illustrates how to use some of the more esoteric functions such as video rotation and using titles as opening and closing credits. Swiftly create professional-looking DVDs, even stunning widescreen productions. - Learn what goes into creating a DVD - Be able to create different kind of content in DVD - Learn how to create your own media content using Sony DVD Architect - Learn how to polish your projects before transferring into DVD This course is SkillsFuture Credit Eligible.




Preview Available


About John Mark Osborne

System Requirements

FileMaker 12 Family of Products

About the Tutorial Series pt. 1

About the Tutorial Series pt. 2

Work Files

Locked Files

Ultimate Find


Why Script a Find?

Find Layout

Basic Find Script with Button

Continue and Cancel

Cancel Improved

Modular Scripting

No Records Found

No Find Criteria

Modify Find

Dynamic Scripting

List Versus Form

Save by Table Occurrence pt. 1

Save by Table Occurrence pt. 2

Save by Table Occurrence pt. 3

Save a Found Set



Loop with Global

Loop with Variable

Speed Testing

GetNthRecord Recursion

Compare and Contrast

Save Multiple Found Sets

Duplicate Set Names

Restore Multiple Found Sets Layout

Restore Multiple Found Sets Script

Completing the Interface

Account Aware Found Sets

Save with Snapshot Link

Restore with Snapshot Link

Parsing Text


Advanced Text Parsing Techniques

Gathering Find Criteria

Saving Find Criteria

Restoring Find Criteria pt. 1

Restoring Find Criteria pt. 2

Restoring Find Criteria pt. 3

Compare and Contrast

Parse Web Form

Parse Popup Menu

New Requests Easier

Charting with Delimited Data

Delete Duplicates


Basic Duplicate Search

Global Loop

Improving the Loop

Replace Field Contents

Improving Replace Technique

Export by Group

Merging Duplicate Records

Validating Duplicates

Compare and Contrast

Scripted Duplicates Defined

Scripted Duplicates Implemented

Recursive Phone Filter


Why Recursion?

Recursive Formula

Global Preferences pt. 1

Global Preferences pt. 2

Startup Layout

Personal Information pt. 1

Personal Information pt. 2

Auto Enter

Multi-User Preferences pt. 1

Multi-User Preferences pt. 2

Multi-User Preferences pt. 3

Multi-User Preferences without Accounts

Revisiting Validation

Back Button


Mimic Web Browser

Storing Layouts

Back Layout

Forward Layout

Back Record and Window

Visual Interface Cue

Dimmed Buttons Structure

Dimmed Buttons Interface

Dimmed Buttons Script

Dimmed Buttons for Multiple Tables

Custom Form Letters


Flexible Form Letters

Form Letter Fields

Form Letter Interface

Print Layout

Print Script

Record Locking Issue

Save Letter

Insert Letter

Changing Text Style Components

Changing Text Style Script

Event Driven Scripting





Calculation Counterparts

Simple Yet Powerful Triggers

Validating Duplicates Revisited pt. 1

Validating Duplicates Revisited pt. 2

Better Quick Find

Save/Revert Record

No Field Selected

Limiting Characters

Script Trigger Conflict

Prevent Carriage Return

Preventing Access to a Tab

Automatic History pt. 1

Automatic History pt. 2

Automatic History pt. 3



Conditional Formatting Basics

Dimmed Buttons

Hidden Field Labels

Portal Resize

Sorting Portals

Cross-Tab Reports

Hiding Trash Can

Print as PDF Dynamically

Better List to Form

Scripted Popup Menus

Check List

Working with John Mark Osborne

Resource Files

Free Resources


Consulting and Meta-Consulting


Contacting Me

SkillsFuture Credit Eligible
SGD $63.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.