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
https://content.filemaker.com/filemaker-trial

Course taught by an expert real-world FileMaker Pro Instructor

Register Now

Prerequisites

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

Layouts

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

Objectives

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

Layouts

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

Reporting

Basic Reports

Planning for Reports 

Subsummary Reports 

Working with Charts

Integration

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

Relationships

Objectives

Relationships

Using Primary and Foreign Keys to Relate Tables

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

Special Layout Objects

Portal

Tab Control

Slide Control

Popover

Web Viewer

Importing Data

Converting an Existing File

Converting Excel Files

Scripting

Understanding Scripts

Creating and Editing Scripts

Writing Scripts

Buttons

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 

Navigation

Window Management 

Looping Techniques 

Scripting for Mobile Users

Exporting Data

To Tab-Delimited Text

To Excel

Sending Records as Email

Creating PDFs

Data Repair

Calculations

Creating Calculations

Functions and Operators

Number Functions  

Text Functions

Date and Time Functions 

Logical Functions 

Security 

Creating Accounts and Granting Access 

Setting Up Privilege Sets

Restricted Conditional Deletes 

Conditional Record Access 

Advanced Security & Encryption

Deployment

Deployment Options

Introduction to Using FileMaker Server 

Deploying Using FileMaker WebDirect

 

Register Now