FileMaker Pro is an award-winning database software program that works both for Mac, Windows and Mobile users. This comprehensive three-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.

3 days - $1,895.00

Course taught by an expert real-world FileMaker Pro Certified Instructor.

Prerequisites:

Basic knowledge of a Mac or PC computer is required. Understanding of some database terminology is also 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

Viewing and Working with Data
Layouts
Modes Within Layouts
Views Within Layouts
Records: Adding, Deleting, and Duplicating
Working With Data

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