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)