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

  • PostgreSQL: Know how to handle database jobs

    PostgreSQL: Know how to handle database jobs

    SGD $45.00

    Course Description

    This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences. Take the first step in maintaining your database.- Learn how to maintain your database - Know about the features and functions of PostgreSQL.- Learn about the different administrative tools available- Be able to handle and monitor the activity in your database This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Word: Essential 2013, 2016 & Online

    Microsoft Word: Essential 2013, 2016 & Online

    SGD $99.00

    Course Description

    Microsoft® Word 2013 offers enhanced features to help you create professional-quality documents, collaborate with your peers and expanded access to your files. In this online training series, you will learn about the new interface, and the basics of how to create high-quality documents that you can be proud of. Additionally, learn about Microsoft® Word 2016 and its newly introduced features as well as Word Online, increasing your word processing capabilities!Learn about the new interface of Microsoft Word 2013, and the basics of how to create high-quality documents that you can be proud of.- Master Microsoft Word 2013 with this excellent online tutorial- Know about the basics and newly added functions in Microsoft Word 2016 - Learn how you can apply this techniques into actual documents - Be able to create dynamic and of high-quality documents using Microsoft WordThis course is SkillsFuture Credit Eligible.

    Read more...

  • FileMaker and PHP Foundations

    FileMaker and PHP Foundations

    SGD $45.00

    Course Description

    PHP is the most widely used scripting language on the web. It's accessible, well documented, and easy to learn. When FileMaker Inc. released their API for PHP a new door was opened to build rich web applications that interact with FileMaker Pro databases. This VTC course will introduce you to the PHP language, FileMaker's API for PHP, and best practices for Custom Web Publishing with PHP. Discover how data can be managed efficiently with PHP. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how PHP can be implemented to run the data better - Understand how PHP is an effective solution to optimizing your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

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

+

Organization

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

+

Overview

Considerations

Definitions

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

Miscellaneous

+

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

Training

Consulting and Meta-Consulting

Solutions

Contacting Me

SkillsFuture Credit Eligible
SGD $63.00
(Price excludes GST)
GET ACCESS NOW
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.