* COVID-19: 1 Person per Room Health & Safety Policy *


FileMaker Pro Basic Course

FileMaker Training Online & Onsite

Attend Our Classes From Home - No Software Needed - Learn More...

FileMaker TrainingFileMaker Pro Basic

by Certstaffix® Training

Length: 2 day(s)      Public Class Price: $890/person (USD)      Group Class Price: Request Quote      Course Category: FileMaker


FileMaker Training
This course focuses on the features and benefits of the FileMaker Platform with special attention to the newest version, FileMaker Pro Advanced 18. You will learn how to build a sample FileMaker solution from start to finish.

Say goodbye to paper forms, spreadsheet and single-use apps and learn how to create your own custom solution for your unique business needs.

Get step-by-step instructions to help you create a solution from start to finish. You’ll get an overview of the FileMaker Platform as well as a tour the built-in tools and templates to make a solution that’s right for you.

Discover the basics of working with layouts, creating interfaces for iPad and iPhone, and building reports on the fly. You’ll also get an introduction to calculations, scripting, and keeping your app secure.


FileMaker Versions That Can Attend: 18, 17 & 16 (Microsoft Windows PC and Macintosh)
Course Taught With: FileMaker 18 (Microsoft Windows PC) Software and Courseware
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.

 Register ➥   April 1, 2021     
 Register ➥   May 18, 2021     
 Register ➥   June 28, 2021     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Course Topics

FILEMAKER PRO ADVANCED BASICS
o New features in FileMaker Pro 18 Advanced
o Using Help
o Converting the trial version to the full version of FileMaker Pro Advanced
o About FileMaker Pro Advanced custom apps
o About FileMaker Pro Advanced modes
o Using the status toolbar
o Performing menu commands
o Opening and managing files

SAVING, IMPORTING, AND EXPORTING DATA
o Saving and sending records in other formats
o Sending email messages based on record data
o Importing data into FileMaker Pro Advanced
o Converting a data file to a new FileMaker Pro Advanced file
o Exporting data from FileMaker Pro Advanced
o Supported import/export file formats
o Working with Microsoft Excel

ADDING AND VIEWING DATA
o Viewing records as a form, list, or table
o Selecting the current record
o Moving through records
o Navigating in web viewers
o Working with data in Table View
o Adding, duplicating, and deleting records
o Entering data in records
o Using data in container fields
o Checking spelling
o Replacing the contents of a field

FINDING RECORDS
o Performing a quick find in Browse mode
o Finding records based on criteria in a single field
o Making a find request
o Finding text and characters
o Finding numbers, dates, times, and timestamps
o Finding ranges of information
o Finding empty or non-empty fields
o Finding duplicate values
o Finding duplicate values using a self-join relationship
o Finding records with equal values in different fields
o Finding records that match multiple criteria
o Finding records except those matching criteria
o Viewing, repeating, or changing the last find
o Omitting records from a found set
o Constraining (narrowing) a found set
o Extending (broadening) a found set
o Saving a find request
o Managing saved find requests
o Finding and replacing data

SORTING RECORDS
o Options for sorting records
o Sorting records by subsummary values

CREATING A CUSTOM APP
o Creating a FileMaker Pro Advanced file
o Setting file options
o Defining database tables
o Defining and changing fields
o About choosing a field type
o Setting options for fields
o Setting up container fields to store data externally
o Deleting table definitions, field definitions, and data
o Creating file paths
o Using variables
o Working with formulas and functions
o Working with plug-ins

WORKING WITH RELATED TABLES
o About relationships
o About relationship criteria
o Planning a relational database
o Working with the relationships graph
o Working with related data in portals
o Defining and updating lookups

CREATING AND MANAGING LAYOUTS AND REPORTS
o Best practices for designing layouts
o Creating a layout
o Editing layouts
o Working with layout parts
o Working with fields on a layout
o Working with portals on layouts
o Drawing and inserting objects on a layout
o Working with panel controls on layouts
o Working with buttons and button bars on layouts
o Working with popovers on layouts
o Working with web viewers on layouts
o Working with windows
o Controlling how layouts print
o Setting up script triggers

EDITING OBJECTS, LAYOUT PARTS, AND THE LAYOUT BACKGROUND
o Using the Inspector to format objects
o Using the Objects tab to work with objects
o Copying, duplicating, and deleting objects
o Moving objects on a layout
o Resizing and reshaping objects
o Setting auto-resize options for layout objects
o Specifying the display state for an object
o Formatting graphics on a layout
o Protecting objects from change
o Naming objects
o Defining conditional formatting for layout objects
o Formatting layouts
o Hiding or showing layout objects
o Controlling animations
o Creating and working with styles in layouts
o Saving and managing layout themes
o Formatting and setting up field objects in Layout mode
o Adding tooltips on layouts
o Making layout objects accessible to screen readers
o Controlling data input behavior of fields
o Formatting text
o Arranging objects
o Positioning objects on a layout

CREATING CHARTS FROM DATA
o About chart types
o Chart planning guidelines
o Creating quick charts
o Creating and editing charts in Layout mode
o Example: Charting delimited data

AUTOMATING TASKS WITH SCRIPTS
o Creating and editing scripts
o Working with the Scripts menu
o Script examples

MANAGING SECURITY
o About accounts, privilege sets, and extended privileges
o About the Admin and Guest accounts
o Using the predefined privilege sets
o Planning security for a shared file
o Password-protecting a local file
o Creating and editing account access
o Creating and editing privilege sets
o Creating and editing extended privileges
o Opening files protected with passwords
o Authorizing access to files

Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

FileMaker Pro Basic Class Reviews

Here are a sample of FileMaker class reviews from past students that have attended our FileMaker training courses.



This course focuses on the features and benefits of the FileMaker Platform with special attention to the newest version, FileMaker Pro Advanced 18. You will learn how to build a sample FileMaker solution from start to finish.

Say goodbye to paper forms, spreadsheet and single-use apps and learn how to create your own custom solution for your unique business needs.

Get step-by-step instructions to help you create a solution from start to finish. You’ll get an overview of the FileMaker Platform as well as a tour the built-in tools and templates to make a solution that’s right for you.

Discover the basics of working with layouts, creating interfaces for iPad and iPhone, and building reports on the fly. You’ll also get an introduction to calculations, scripting, and keeping your app secure.



FileMaker Versions That Can Attend: 18, 17 & 16 (Microsoft Windows PC and Macintosh)
Course Taught With: FileMaker 18 (Microsoft Windows PC) Software and Courseware


Certstaffix® Class Reviews

Student Average:
4.65 out of 5 from 16 students

5.00 out of 5

The filemaker basic course was excellent, and covered a lot of material! However, I would have liked to see some more instruction on the "webdirect deployment" portion of filemaker. But other than that, it was a very valuable course!


- attended our FileMaker Pro 15 Basic class

5.00 out of 5

My teacher was outstanding! Ms. Sherry is kind and professional.


- attended our FileMaker Pro 15/16 Basic class

5.00 out of 5

Instructor was excellent!


- attended our FileMaker Pro 15/16 Basic class

4.78 out of 5


- attended our FileMaker Pro Basic class

4.50 out of 5


- attended our FileMaker Pro Advanced class

4.50 out of 5


- attended our FileMaker Pro Advanced class

4.30 out of 5


- attended our FileMaker Pro 15/16 Basic class

5.00 out of 5


- attended our FileMaker Pro 15/16 Basic class

4.60 out of 5


- attended our FileMaker Pro 15 Basic class

4.53 out of 5


- attended our FileMaker Pro 15 Advanced class

4.06 out of 5


- attended our FileMaker Pro 15 Basic class

4.76 out of 5


- attended our FileMaker Pro 15 Basic class

5.00 out of 5


- attended our FileMaker Pro 15 Advanced class

5.00 out of 5


- attended our FileMaker Pro 15 Basic class

4.24 out of 5


- attended our FileMaker Pro 15 Basic class

4.18 out of 5


- attended our FileMaker Pro 15 Basic class



Please contact us if we do not yet have any reviews or you would like more.


View all FileMaker training reviews

FileMaker Courses By City:

       FL - Tampa       NC - Asheville       PA - York      
- - your home       FL - Winter Park       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Atlanta       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Augusta       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Columbus       NC - Winston-Salem       SC - Greenville      
AR - Bentonville       GA - Savannah       ND - Bismarck       SC - Myrtle Beach      
BC - Vancouver       HI - Honolulu       ND - Fargo       SC - North Charleston      
CA - Bakersfield       IA - Des Moines       NE - Lincoln       SK - Regina      
CA - Fresno       IA - Iowa City       NE - Omaha       SK - Saskatoon      
CA - Los Angeles       ID - Boise       NH - Bedford       TN - Chattanooga      
CA - Merced       IL - Chicago       NJ - Bridgewater       TN - Knoxville      
CA - Modesto       IL - Rockford       NM - Albuquerque       TN - Memphis      
CA - Napa       IN - Bloomington       NM - Las Cruces       TN - Nashville      
CA - Oakland       IN - Evansville       NM - Santa Fe       TX - Amarillo      
CA - Oxnard       IN - Fort Wayne       NS - Halifax       TX - Austin      
CA - Rancho Cucamonga       IN - Indianapolis       NV - Henderson       TX - Beaumont      
CA - Sacramento       IN - South Bend       NV - Reno       TX - Corpus Christi      
CA - Salinas       KS - Overland Park       NY - Albany       TX - Dallas      
CA - San Diego       KS - Topeka       NY - Buffalo       TX - El Paso      
CA - San Jose       KY - Lexington       NY - New York City       TX - Fort Worth      
CA - Santa Maria       KY - Louisville       NY - Rochester       TX - Houston      
CA - Santa Rosa       LA - Baton Rouge       NY - Syracuse       TX - Killeen      
CA - Stockton       LA - Lafayette       OH - Beavercreek       TX - Laredo      
CB - Caribbean       LA - New Orleans       OH - Cincinnati       TX - Longview      
CB - Kingston       LA - Shreveport       OH - Cleveland Heights       TX - Lubbock      
CB - Nassau       MA - Burlington       OH - Columbus       TX - McAllen      
CO - Boulder       MA - Springfield       OH - Toledo       TX - Midland      
CO - Colorado Springs       MA - Westborough       OH - Youngstown       TX - San Antonio      
CO - Denver       MB - Winnipeg       OK - Oklahoma City       TX - Tyler      
CT - Cheshire       MD - Laurel       OK - Tulsa       TX - Waco      
CT - New Haven       ME - Portland       ON - Ottawa       UT - Ogden      
CT - Stamford       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
DC - Washington       MI - Flint       OR - Beaverton       VA - Charlottesville      
DE - Wilmington       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
FL - Daytona Beach       MI - Lansing       OR - Eugene       VA - Harrisonburg      
FL - Fort Lauderdale       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Fort Myers       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Gainesville       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Jacksonville       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Lakeland       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Miami       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Naples       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Pensacola       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Sarasota       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tallahassee       NB - Saint John       PA - Scranton-Wilkes Barre