Contact Us: 978.250.4983
Software Skills Training, Inc.

FileMaker Pro

Attend via an online live remote attendance option

FileMaker Pro

Duration: 4 Days

US Price: $1895

Delivery Option: Courses are delivered via online live remote attendance option 8:00 am - 4:00 pm PST. Students receive digital course materials prior to the start of the course.

Schedule View the course schedule

Description

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

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

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

Prerequisites

Basic knowledge of a Mac or PC computer. Understanding of basic database terminology is helpful but not required.

Course Overview

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
 

Related Training

Training Locations

Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4983 between 9:00 am - 5:00 pm EST.