There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning FileMaker 16

Video Introducing this tutorial


Introducing the FileMaker 16 platform
Touring the Launch Center
Using the exercise files

1. Getting Started

What is a database?
Comparing flat vs. relational databases
How FileMaker works
Essential preferences
Getting to know the interface

2. FileMaker App Creation Essentials

Getting going with starter solutions
Creating new FileMaker apps from spreadsheets

3. Creating Tables

Determining which tables your FileMaker app will need
Creating tables in FileMaker

4. Creating Relationships

Understanding relationship types
Diagramming relationships (creating an ERD)
What are key fields?
Defining primary and foreign keys
Creating relationships using FileMaker relationship graph and table occurrences
A message about relationships

5. Working with Fields

Deciding what fields you will need
Understanding field types
Defining fields
Adding fields to layouts
Field options: Auto enter
Field options: Validation

6. Working with Container Fields

Using container fields in your FileMaker App
Applying field options and using remote container storage

7. Working with Records

Creating and duplicating records
Editing and locking records
Deleting records, backing up files

8. Importing and Exporting

Importing data
Importing records to refresh data
Exporting data

9. Creating Layouts

What is a layout?
Working with layout themes
Using the layout assistant to create list views

10. Working with Layouts

Using the layout setup dialog
Understanding layout parts
Previewing the inspector
Layout tools and status area in layout mode
Manage layouts window

11. Formatting Layout Objects

Using guides, arranging, aligning, grouping and locking layout objects
Applying themes to layouts
Working with shapes in your layouts
Applying screen stencils
Working with images and icons on your layouts
Formatting fields and applying field attributes
Layout object states
Access control behavior
Using the tab control feature
Using slide controls in your layouts
Popovers in your layouts
Setting the tab order
Learning how to conditionally hide layout objects
Using the layout objects window

12. Finding Data

Using the basic find functions
New requests in find mode
Search operators
Constraining or extending found sets
Finding records using date or time or timestamp criteria
Using fast match and quick find

13. Sorting Data

Sorting with single criteria
Sorting with related fields
Sorting with multiple criteria
Sorting using custom values
Sorting using buttons

14. Value Lists

Drop downs, radio buttons, and other field control options
Creating and applying static value lists
Creating and applying dynamic value lists

15. Printing and Saving

Previewing pages and print options
Controlling object visibility when printing
Printing merge letters
Saving as PDF or Excel

16. Reports

Building simple reports with summary fields
Creating subsummary reports
Adding charts to reports
Creating subsummary reports in table view
Creating quick charts in table view

17. Calculation Essentials

What are calculations?
Touring the calculation dialog window
Number functions
Date and time functions
Text functions
Get functions
Logic functions

18. Script Essentials

What are scripts and script steps?
Assigning script steps to buttons
Touring the Script workspace
Creating multiline scripts
Adding find criteria to a script
Using new window script step
Understanding the "If" script step
Using script parameters, set field, and error capture
Sending emails in your scripts
Importing scripts from other files

19. Script Triggers

Introducing script triggers
Using object-based triggers
Using layout-based triggers
Using file-based triggers (open and close scripts)

20. New Features in FileMaker 16 Platform

Layout objects window
Card window style
Creating PDFs in FileMaker webDirect and on FileMaker server
Animations and transitions on FileMaker Go
Enhanced signature capture
Support for JSON
Working with JSON


Next steps