FileMaker Pro - 2 Days

Wednesday, 01 June 2022 08:00 AM - Thursday, 02 June 2022 04:00 PM

FileMaker Pro is an award-winning database software program that works both for Mac, Windows and Mobile users. This comprehensive two-day hands-on FileMaker Pro course focuses on the features and benefits of FileMaker with step-by-step easy to follow instructions plus mentored lab exercises. Attendees will learn how to build a sample FileMaker solution from start to finish using all of the built-in tools and templates to demonstrate the different kinds of databases you can create with FileMaker Pro. The course also covers calculations, scripting, and how to keep your data secure.

This course is taught Live On Line, so you can learn from the comfort of your home or office. Cost is $1,050.00 which includes all class materials - Class times: 8:00 am 4:00 pm PST.

If you don't own the software, you can download a free 30-day trial here

Course taught by an expert real-world FileMaker Pro Instructor

Register Now


Basic knowledge of a Mac or PC computer

Understanding some database terminology is helpful


Course Outline

FileMaker Platform Overview

FileMaker Product Line

FileMaker Version Compatibility

Accessing a Solution

Understanding a Database

Fields vs. Records vs. Tables

Database information vs. Spreadsheet Information

Using Starter Solutions

Choose a Starter Solution

Quick Mobile Development

Viewing and Working with Data


Modes Within Layouts

Views Within Layouts

Records: Adding, Deleting, and Duplicating

Working With Data

Finding and Sorting Records

Specifying Search Criteria

Extending and Constraining a Found Set

Using Operators in Search Criteria

Sorting Records

User-Centered Design

Understanding User-Centered Design

Basic Principles

User-Interface Best Practices


User-Interface Best Practices

Creating Fields and Tables

New Tables

Field Types

Create New Fields from the Field Picker

Create New Fields from the Manage Database Dialog


Creating Layouts

Adding Fields to a Layout

Layout Themes and Styles

Creating More Layouts

Layout Design Tools

Status Toolbar and Inspector

Layout Resizing

Guides and Grids

Using Layout Design Tools


Basic Reports

Planning for Reports 

Subsummary Reports 

Working with Charts


Sharing Data With Outside Users

Integrating with Other Data Sources

FileMaker Pro Connectivity Options

Integrating with Web Services

Working ODBC

Formatting Field Objects

Data Formatting

Conditional Formatting

Field Control Styles

Value Lists




Using Primary and Foreign Keys to Relate Tables

Creating One-to-Many and Many-to-Many Relationships

Special Layout Objects


Tab Control

Slide Control


Web Viewer

Importing Data

Converting an Existing File

Converting Excel Files


Understanding Scripts

Creating and Editing Scripts

Writing Scripts


Startup Script

Solution Logic: Calculations

Mobile Functions

Container Functions 

Aggregate Functions 

Custom Functions

Solution Logic: Scripting

Conditional Scripting

Scripting Tools 

Script Triggers 

Custom Menus

Using Scripts to Find Data 


Window Management 

Looping Techniques 

Scripting for Mobile Users

Exporting Data

To Tab-Delimited Text

To Excel

Sending Records as Email

Creating PDFs

Data Repair


Creating Calculations

Functions and Operators

Number Functions  

Text Functions

Date and Time Functions 

Logical Functions 


Creating Accounts and Granting Access 

Setting Up Privilege Sets

Restricted Conditional Deletes 

Conditional Record Access 

Advanced Security & Encryption


Deployment Options

Introduction to Using FileMaker Server 

Deploying Using FileMaker WebDirect


Register Now


Powered by iCagenda

Recent Clients

Wells Fargo
Pie Town Productions
FBI & Treasury Dept.
Great Dane Trailers
Neiman Marcus

Contact us

Mailing Address
20929 Ventura Blvd.,
Suite 47-212
Woodland Hills, CA 91364

Telephone: (818) 794-7125

Contact Us

© 2022 RevUp Tech. All Rights Reserved.