Introduction
Introducing FileMaker Essential Training
()
Introducing the FileMaker platform
()
1. Getting Started
What is a database?
()
How FileMaker works
()
Configuring essential preferences
()
Getting to know the interface
()
2. FileMaker App Creation Essentials
Getting going with starter apps
()
Add-on tables
()
3. Creating Tables
Determining which tables your FileMaker app will need
()
Creating tables in the manage tables window
()
An important note about relationships
()
4. Working with Fields
Deciding what fields you will need
()
Understanding field types
()
Defining fields in tables
()
Adding fields to layouts
()
Field options: Auto enter
()
Field options: Validation
()
5. Working with Container Fields
Using container fields in your FileMaker app
()
Applying container field options
()
Container storage options
()
6. Working with Records
Creating and duplicating records
()
Editing and locking records
()
Deleting records and backing up files
()
7. Importing and Exporting
Exporting data from FileMaker
()
Importing data from FileMaker
()
8. Creating Layouts
Introducing FileMaker layouts
()
Using the Layout Assistant to new layouts
()
9. Working with Layouts
Understanding layout parts
()
The Inspector panel
()
Layout tools and status area in Layout mode
()
Managing layouts and layout folders
()
10. Formatting Layout Objects
Grouping layout objects
()
Arranging and aligning layout objects
()
Understanding FileMaker themes
()
Applying themes to layouts
()
Customizing and importing themes
()
Applying Screen Stencils
()
Formatting fields and applying field attributes
()
Controlling layout object behaviors
()
Setting the tab order
()
Slide controls in your layouts
()
Popovers in your layouts
()
Using the tab control feature
()
11. Finding Data
Using the basic find functions
()
New requests in Find mode
()
Search operators to find records easier
()
Constraining or extending found sets
()
Using Fast Match and Quick Find
()
12. Sorting Data
Sorting with single criteria
()
Sorting with multiple criteria
()
Sorting using custom values
()
Sorting using buttons
()
13. Value Lists
Drop downs, radio buttons, and other field control options
()
Creating and applying static value lists
()
14. Printing
Previewing pages and print options
()
15. Reports
Building simple reports with summary fields
()
Creating subsummary reports: Summary parts
()
Creating subsummary reports: Aggregating summary parts
()
16. Calculation Essentials
What are calculations?
()
Touring the calculation dialog window
()
Number functions in FileMaker
()
Date and time functions
()
Analytic text functions
()
Text manipulation text functions
()
Logic functions: The If function
()
Logic functions: The Case function
()
17. Script Essentials
What are scripts and script steps?
()
Assigning script steps to buttons
()
Touring the Script Workspace
()
Creating multiline scripts
()
Creating multiline scripts: Printing in scripts
()
Creating multiline scripts: Custom dialogs
()
Adding find criteria to a script: Static finds
()
Adding find criteria to a script: User-specified finds
()
Using the New Window script step
()
Understanding the If script step
()
Adding the If script step to a script
()
18. New Features in FileMaker 19
Core ML support
()
Working with Core ML, part 1
()
Working with Core ML, part 2
()
Working with Core ML, part 3
()
Working with Siri shortcuts
()
Setting advanced Siri shortcuts using FileMaker scripts
()
NFC support
()
Setting up your NFC tag
()
Working with NFC in your FileMaker app
()
JavaScript support
()
Working with JavaScript in Web Viewer
()
Conclusion
Where to go from here
()
Ex_Files_FileMaker_Pro_Essential_Training.zip
(312.1 MB)