FileMaker 16

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$14.99 / $24.99

0100 - Introductions - Overview

1. 0102 - The FileMaker Platform -Summary
7m 29s
2. 0105 - Installing FileMaker andDowngrades
8m 46s
3. 0106 - Buying / Licensing FileMaker -FLT
6m 29s
4. 0107 - Pro for FLT & ConcurrencyConnections
13m 48s
5. 0108 - New Feature Brain Dump forNew and Intermediate Users
8m 50s
6. 0109 - The New Windows Interface
3m 6s
7. 0113 - Basics of Sharing a Database
13m 36s
8. 0115 - Upgrading 12, 13, 14, or 15Solutions to FM16
7m 49s
9. 0117 - FM Pro Vs
2m 26s

FM Starting Point Walkthrough

1. 0201 - FMSP Walkthrough - Intro
6m 23s
2. 0202 - FMSP Device Support & LayoutOrganization
5m 22s
3. 0203 - Script Numbering andOrganization
4m 10s
4. 0205 - Whats new in FMSP 5?
6m 30s
5. 0207 - FMSP Account & ContactsWalkthrough
17m 24s
6. 0208 - FMSP Invoice Walkthrough
9m 12s
7. 0211 - FMSP Sales Followups
14m 37s
8. 0212 - FMSP Invoice - New Line Items- Advanced
14m 25s
9. 0213 - FMSP Estimate to InvoiceTransfer Button - Customize it!
11m 32s
10. 0214 - FMSP Calculating Margin andMarkup in Invoices
9m 24s
11. 0216 - FMSP Unlimited RelatedDigital Document Upgrade
8m 40s
12. 0219 - Calendar Under the Hood Part1
9m 38s
13. 0220 - Calendar Under the Hood Part2
12m 46s
14. 0221 - Tab Controls with Calculations
4m 19s
15. 0230 - Dashboard Charts Part #1
11m 22s
16. 0231 - Dashboard Charts Part #2 -Scripting
25m 18s
17. 0232 - Dashboard Charts Part #3 -Performance
5m 2s
18. 0235 - Managing Primary Keys
6m 54s
19. 0240 - Default Tax Rates in FileMaker16 Invoices - Auto Enter Values
10m 36s

0300 - Fundamentals & Basics

1. 0301 - What is a Database - Part 1
5m 49s
2. 0302 - What is a Database - Part 2
4m 31s
3. 0303 - Modes in FileMaker
5m 40s
4. 0304 - Browse Mode, and the Deletemenu item
6m 29s
5. 0305 - Saving Data
2m 2s
6. 0306 - Converting from .fp7 to.fmp12 file formats
10m 49s
7. 0307 - Converting from .fp5 to .fp7file formats
9m 30s
8. 0308 - How to make a Copy of a FMDatabase
5m 10s
9. 0309 - What is a Relationship?
18m 27s

Performing Finds & Sorts

1. 0401 - Finding Records - Basics
5m 43s
2. 0402 - Finding - Multiple Requests
10m 49s
3. 0403 - Finding Ranges of Dates
4m 14s
4. 0404 - Finds with Special Operators
8m 37s
5. 0405 - Finds and Indexing andPerformance, Stored Calcs
6m 15s
6. 0406 - Finds Constrain and Extend
4m 37s
7. 0407 - Sorting Records
7m 38s
8. 0408 - Custom Sort Orders
7m 42s

0500 - Working on Fields & Layouts

1. 0501 - Layouts - Available tools
13m 15s
2. 0502 - Tour of the Inspector
21m 29s
3. 0503 - Intro to Adding Fields toDatabase (Text and Number)
12m 11s
4. 0504 - Added Calc fields and HidingObjects
11m 40s
5. 0505 - Creating a Survey & TabPanels & Value Lists
14m 28s
6. 0506 - Value Lists - Under the hood
9m 11s
7. 0507 - Hiding Objects & ConditionalFormatting
13m 26s
8. 0508 - Text Fields with User SpecifiedFormatting
11m 20s
9. 0509 - Merge Fields
4m 36s
10. 0510 - Stored Vs UnstoredCalculations
11m 22s
11. 0511 - 3 Types of Buttons and OneGlyph - Icon
9m 36s
12. 0512 - Button Bar as New Data InputControl Style
3m 5s
13. 0513 - Inline Field Labels
3m 29s
14. 0514 - Layout Object Windows (LOW)(aka Layout Object Tree)
9m 25s
15. 0515 - Tabs vs
5m 51s
16. 0516 - Popovers and New WindowCommand
9m 43s
17. 0517 - Auto-Enter Options for Fields
8m
18. 0521 - Introduction to Single-User vs.Multi-User databases
9m 25s
19. 0522 - Global Fields
10m 44s
20. 0523 - Tooltips
7m 8s
21. 0524 - Object Flags, or Badges
7m 33s
22. 0525 - Object Alignment tools
11m 44s
23. 0526 - Creating a new iOS Layoutfrom Scratch - Stencils
7m 1s
24. 0527 - Field Validation Options
13m 3s
25. 0528 - Repeating Fields
8m 34s
26. 0530 - Layout Badge Tooltips
2m 46s
27. 0539 - Custom Currency in FMSP
4m 6s
28. 0540 - Formatting Currency - When itgoes into a Text Field
10m 2s
29. 0545 - Hamburger Menus & InlineText Labels
6m 7s

0550 - Containers Field & DocumentManagement

1. 0551 - Container Field Introduction
11m 40s
2. 0553 - Advanced Container FieldKung-Fu
11m 1s
3. 0556 - Interactive Containers inFileMaker
15m 35s
4. 0560 - Containers in FMSP
6m 33s
5. 0562 - HiJacking Containers in FMStarting Point
17m 2s
6. 0580 - When Container Storage goesBad..
8m 38s

0600 - Advanced Layout Techniques

1. 0601 - Making Layouts load 200%faster in FM 16 - Performance
7m 16s
2. 0602 - 200% faster Part 2 -Performance
8m 12s
3. 0603 - 200% faster Part 3 -Performance
2m 53s
4. 0604 - Grouping with Slide Panels toHide Objects
5m 45s
5. 0605 - Get Object Attribute forHidden Objects
2m 52s
6. 0608 - Script Triggers - Intro
4m 17s
7. 0609 - Script Triggers - LayoutSpecific
10m 3s
8. 0610 - Script Triggers - Object Specific
7m 51s
9. 0611 - Script Triggers - FieldValidations
10m 12s
10. 0612 - Script Triggers - More Layoutscontrols
6m 5s
11. 0614 - What is a Virtual List? ***Advanced ***
14m 12s
12. 0615 - Hierarchical Portal forNavigation *** Advanced ***
16m 49s
13. 0620 - Go to Related Record - GTRR
19m 10s
14. 0622 - FileMaker 14 SVG Icon HelperTool
18m 20s

0700 - Emailing, Imports and Exports

1. 0701 - Sharing Data Intro
1m 17s
2. 0702 - Importing Data
14m 34s
3. 0703 - Exporting Data
7m 59s
4. 0704 - Scripting Import & Exports -Basics
4m 31s
5. 0706 - Send Email Script Step
3m 53s
6. 0707 - Finding Your SMTP Settings
8m 40s
7. 0708 - Automating outbound emails
6m 51s
8. 0709 - Spamming with FileMaker
8m 7s
9. 0710 - Automating Emailing ofExports, Like a PDF
2m
10. 0711 - Scripting FileMaker to Deletea File
11m 36s
11. 0712 - Multi-Table Imports...Complex Imports
21m 20s
12. 0713 - Upgrading Copies of FMSP,migrating / updating to a new release
9m 16s
13. 0714 - Updating data in a FileMakertable from an Excel File
13m 27s
14. 0720 - Using 360Works Email Pluginto Send HTML Emails
6m
15. 0725 - 360Works' CloudMail Install
16m 15s

0800 - Integration

1. 0803 - Barcode DeploymentPlanning & Options
12m 20s
2. 0804 - Installing the BarcodeCreator into FMSP
7m 21s
3. 0805 - Scanning Items into Invoiceswith Barcodes
2m 25s
4. 0806 - Under-the-hood withScanner Barcodes In FMSP Part 1
7m 20s
5. 0807 - Under-the-hood withScanner Barcodes In FMSP Part 2
8m 40s
6. 0808 - Under-the-hood withScanner Barcodes In FMSP Part 3
12m 52s
7. 0809 - USB Barcodes Gun We'reUsing
6m 40s
8. 0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode
6m 23s
9. 0811 - Viewer Questions & troubleshooting Barcodes
7m 6s
10. 0812 - Infinite Peripherals BarcodeHardware for iPhone & iPad
11m 29s
11. 0814 - Getting FileMaker Server toGenerate PDFs - PSOC
9m 1s
12. 0815 - What is a FileMaker Robot?
8m 40s
13. 0820 - Intro to Sending HTML emailsand SMS messages
7m 15s
14. 0830 - Building a Progress Bar inFileMaker
12m 19s
15. 0831 - Validating Emails with aService
8m 27s
16. 0832 - Getting Driving DistanceFrom Google
8m 45s
17. 0835 - Dialing VOIP Phone with SIP& X-Lite
10m 13s
18. 0840 - Sending SMS with Twilio
10m 38s
19. 0845 - Syncing to iPad or Syncing 2databases - MirrorSync 2
45m 21s
20. 0846 - Clustering and Replication -MirrorSync 3
19m 48s
21. 0847 - 360Works MirrorSync 4
5m 24s

0900 - Writing Scripts

1. 0901 - Scripting
9m 58s
2. 0902 - Intro to Script Workspace
11m 47s
3. 0903 - Workspace KeyboardShortcuts
10m 56s
4. 0904 - Set fields vs
16m 35s
5. 0905 - Set fields & Context
2m 29s
6. 0906 - Buttons run one Command
15m 2s
7. 0907 - Navigation
3m 27s
8. 0908 - IF...THEN...decisions
6m 30s
9. 0909 - Variables vs
6m 5s
10. 0910 - Performing Finds
9m 3s
11. 0911 - Basic Error Capture
10m 26s
12. 0912 - Calling Subscripts - ScriptParameters
8m 57s
13. 0913 - Advanced Script Parameters& Script Results
5m 2s
14. 0914 - Looping Scripts
3m 15s
15. 0917 - Preserving User Contextwhen running a Script
7m 23s
16. 0918 - New Window - Script Step
14m 6s
17. 0920 - Script Debugger - Part 1
20m 54s
18. 0921 - Script Debugger - Part 2
3m 11s
19. 0924 - Data Viewer
13m 32s
20. 0932 - UI Indicators for DatabaseActivity
10m 46s
21. 0940- Database PerformanceOptimization Overview
5m 42s
22. 0941- Making Scalable Databases
11m 26s
23. 0942- Server Evidence - SlowPerformance - Slow Scripts
3m 28s
24. 0943 - Perform Script on Server -PSOS
20m 10s
25. 0945 - PSOS in FMSP
7m 11s
26. 0946 - Testing for PSOS Availability
12m 27s
27. 0947 - SASE
10m 31s
28. 0948 - Case Statement
2m 9s
29. 0950 - Deduplicating Records, thePlan
7m 56s
30. 0951 - Replace Command - A TigerLoose at the Zoo
8m 3s
31. 0953 - Landmines in FileMaker
9m 50s
32. 0955 - Testing to Make Sure YourScript has Access to a Record
7m 40s
33. 0957 - Testing to See if a Field orvariable contains ONLY a number / Tri…
5m 17s
34. 0965 - One Use Loop Technique
5m 57s
35. 0968 - Go To Object
12m 18s

1000 - Calculations

1. 1001 - Calculation Engine & NewWork Space
13m 21s
2. 1002 - Calculation Engine & NewWork Space Part 2
4m 48s
3. 1010 - Parsing Text with Calcs - Part1
12m 7s
4. 1011 - Parsing Text with Calcs - Part2
11m 33s
5. 1012 - Detecting Window Mode andFilter Function
11m 14s
6. 1013 - Date Calcs
5m 11s
7. 1014 - Detecting Device & PlatformTypes
3m 27s
8. 1020 - Get Functions Walkthrough -Part 1
8m 51s
9. 1021 - Get Functions Walkthrough -Part 2
7m 16s
10. 1022 - Get Functions Walkthrough -Part 3
3m 39s
11. 1023 - Get Functions Walkthrough -Part 4
5m 7s
12. 1024 - GetLayoutAttribute
5m 26s
13. 1025 - GetContainerAttribute
5m 15s
14. 1026 - Get(UUID) andGet(PersistentID)
8m 11s
15. 1040 - List Function, Summary List,and GetValue
7m 58s
16. 1042 - SortValues and UniqueValues
1m 40s
17. 1045 - Get (ScriptName) - Understand Timing Issues...
16m 37s

1100 - Relationships

1. 1101 - What is a Relationship?
9m 27s
2. 1102 - Table Occurrences Basics
11m 52s
3. 1103 - Relationship Graph & ERDs
12m 23s
4. 1104 - What is a Portal..
6m 42s
5. 1105 - Multi-Predicate Relationships
8m 46s
6. 1106 - Multi-Key Relationships
11m 1s
7. 1107 - Cascading Adds
7m 24s
8. 1108 - Cascading Deletes
6m 12s
9. 1111 - Portal Dialog Options
16m 44s
10. 1112 - Portal Summary Sum Totals
7m 14s
11. 1114 - Filtering Portals - RadioButtons
7m 30s
12. 1120 - Lookup Values
13m 12s
13. 1121 - Relookup Command -Updating One Time Relationships
8m 6s
14. 1130 - Anchor Buoy DesignMethodology Part 1
9m 23s
15. 1131 - Anchor Buoy DesignMethodology Part 2
7m 31s
16. 1132 - Many to Many Relationships
14m 37s
17. 1135 - Preference Table in yourSolution
7m 8s
18. 1140 - Calculating and Primary Keywith the current Year
10m 14s
19. 1150 - Multiple Page Invoices -Portal Management - Part 1
10m 26s
20. 1151 - Multiple Page Invoices -Portal Management - Part 2
28m 25s

1200 - Security

1. 1201 - Security in FileMakerOverview
5m 21s
2. 1202 - Accounts and Privileges
12m 11s
3. 1203 - Extended Privileges...theBasics
10m 26s
4. 1204 - Extended Privileges...RecentChanges
9m 8s
5. 1205 - Encryption at Rest (EAR)
9m 12s
6. 1206 - Point-to-Point Encryption -SSL Certificates
52m 27s
7. 1207 - Audit Trails - Part 1 -Overview
12m 25s
8. 1208 - Audit Trails - Part 2 -Technical
11m 46s
9. 1209 - Audit Trails - Audits in FMSPPart 1
9m 14s
10. 1210 - Audit Trails - Audits in FMSPPart 2
17m 44s
11. 1211 - Audit Trails - Logging Recordsviewed - HIPAA
19m 22s
12. 1213 - Security through Obscurity
7m 55s
13. 1214 - Record Level Security
13m 29s
14. 1215 - Layout and Process AccessControls - Restricting Staff
15m 9s
15. 1216 - Hacking a FileMaker File...and Protecting It
7m 56s
16. 1220 - CryptAuthCode SecurityFunctions
7m 39s

1300 - FileMaker Server

1. 1301 - Deployment & Sharing
19m 10s
2. 1302 - FMS Admin Walkthrough
18m 23s
3. 1303 - Scheduling Backups
14m 45s
4. 1304 - Progressive Backups
4m 48s
5. 1305 - Restoring from a Crash
18m 58s
6. 1306 - Server PerformanceImprovements 14 - Nick Lightbody
44m 7s
7. 1307 - Server PerformanceImprovements 15 - Nick Lightbody
31m 27s

1400 - Printing & Report Creation

1. 1401 - Printing and PDF Generation
13m 14s
2. 1402 - Structuring your data so it isreportable
4m 29s
3. 1403 - List View for Ad-HocReporting
4m 9s
4. 1404 - Layout Parts on List View -for Beginners
9m 34s
5. 1405 - FileMaker Report Wizard -Very Cool
10m 20s
6. 1406 - Printing & Reporting onGovernment Forms
7m 4s
7. 1407 - Subsummaries in Detail
11m 17s
8. 1420 - State of Charting in FileMaker
13m
9. 1421 - Built-in Charting Overview
19m 34s
10. 1422 - Google Charts
12m 12s
11. 1425 - MultiPage Append to PDF
7m 19s

1500 - Custom Functions

1. 1501 - Top 10 FileMaker CustomFunctions (For Senior Developers)
17m 46s
2. 1502 - Richard Carlton's Top 5FileMaker Custom Functions
13m 44s
3. 1503 - Parsing XML - CustomFunction
16m 40s

1600 - WebDirect

1. 1602 - Creating PDF's and Emailingfrom WebDirect
16m 34s

1700 - MISC

1. 1701 - Performance Improvementsin 14 - Advanced
8m 1s
2. 1702 - Database PerformanceTuning with Nick Lightbody
51m 12s
3. 1704 - 3 Areas of PerformanceImprovement in Pro 15
10m 25s
4. 1706 - 3 Area of PerformanceImprovement in Pro 14
9m 29s
5. 1708 - How to make an AssetDatabase in 5 Minutes
7m 59s
6. 1717 - PHP #1 - Overview
11m 52s
7. 1718 - PHP #2 - Technical ProcessWalkthrough
10m 34s
8. 1719 - PHP #3 - Sample CodeReview
16m 55s
9. 1720 - Duplicate Module in FMSPPart 1
7m 9s
10. 1721 - Duplicate Module in FMSPPart 2
14m 42s
11. 1722 - Duplicate Module in FMSPPart 3
14m 50s
12. 1723 - Duplicate Module in FMSPPart 4
12m 7s

1800 - FileMaker Cloud

1. 1802 - Detailed Comparison withRegular FileMaker Server
16m 30s
2. 1803 - Is FileMaker Cloud Right foryou?
8m 15s
3. 1804 - Brain Dump for ExperienceFileMaker Developers
16m 38s
4. 1805 - How to Buy FMC - Directfrom AWS - New Users
18m 30s
5. 1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses
17m 27s
6. 1807 - Uploading files to FileMakerCloud
7m 16s
7. 1809 - Picking the right size ofAmazon Server
9m 43s
8. 1811 - Understanding Amazon'sTotal Cost
14m 32s
9. 1812 - How to Save 50% to 75% onAmazon Instance
7m 43s
10. 1813 - FMI Hourly Costs..
3m 11s
11. 1814 - Restoring from a Backup(New Process)
11m 2s
12. 1815 - Restoring from a Backup
7m 6s
13. 1816 - Robot DB & Notifications
4m 47s
14. 1817 - Automated Maintenance
7m 55s
15. 1818 - EBS & Backups
7m 32s
16. 1820 - Supersize my Server!
7m 47s
17. 1822 - Detecting When a File isrunning on FileMaker Cloud
5m 1s
18. 1824 - Instance Refresh &Emergency Procedures Part 1
10m 51s
19. 1830 - Offboarding FileMaker Cloud
3m 48s
20. 1840 - Intro T2 Burstable Instances,Performance, CPU Credits
9m 59s
21. 1841 - CPU Credit and Base lines forT2.Small, T2.Medium, T2.Large
3m 17s
22. 1842 - Standard Usage Scenario
16m 15s

1900 - FileMaker's Certification Test

1. 1902 - Who takes the FileMakerCertification test?
5m 19s
2. 1904 - What is FMI's Official StudyList Part #1
12m 34s
3. 1905 - What is FMI's Official StudyList Part #2
15m 53s
4. 1906 - Final Test Taking Tips...
10m 43s