Certification training
278Lectures
47h 59m 8sDuration
Vendor
FileMaker 16
Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.
Best seller
certification training
278 lessons arranged in a guided course path
Course overview
Study with a clear path.
Move through focused sections, review lecture timing, and return directly to the objectives that need more work.
Sequenced lessons
Follow the course in order or jump directly to the section you need to revisit.
Video-first prep
Use concise lecture blocks for technical review before moving into exam practice.
Fast access
Your purchased course becomes available in the member area after confirmed payment.
Curriculum
Course sections.
20 sections, 278 lessons, and lecture-level duration details.
01
0102 - The FileMaker Platform -Summary
7m 29s
02
0105 - Installing FileMaker andDowngrades
8m 46s
03
0106 - Buying / Licensing FileMaker -FLT
6m 29s
04
0107 - Pro for FLT & ConcurrencyConnections
13m 48s
05
0108 - New Feature Brain Dump forNew and Intermediate Users
8m 50s
06
0109 - The New Windows Interface
3m 6s
07
0113 - Basics of Sharing a Database
13m 36s
08
0115 - Upgrading 12, 13, 14, or 15Solutions to FM16
7m 49s
09
0117 - FM Pro Vs
2m 26s
01
0201 - FMSP Walkthrough - Intro
6m 23s
02
0202 - FMSP Device Support & LayoutOrganization
5m 22s
03
0203 - Script Numbering andOrganization
4m 10s
04
0205 - Whats new in FMSP 5?
6m 30s
05
0207 - FMSP Account & ContactsWalkthrough
17m 24s
06
0208 - FMSP Invoice Walkthrough
9m 12s
07
0211 - FMSP Sales Followups
14m 37s
08
0212 - FMSP Invoice - New Line Items- Advanced
14m 25s
09
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
01
0301 - What is a Database - Part 1
5m 49s
02
0302 - What is a Database - Part 2
4m 31s
03
0303 - Modes in FileMaker
5m 40s
04
0304 - Browse Mode, and the Deletemenu item
6m 29s
05
0305 - Saving Data
2m 2s
06
0306 - Converting from .fp7 to.fmp12 file formats
10m 49s
07
0307 - Converting from .fp5 to .fp7file formats
9m 30s
08
0308 - How to make a Copy of a FMDatabase
5m 10s
09
0309 - What is a Relationship?
18m 27s
01
0401 - Finding Records - Basics
5m 43s
02
0402 - Finding - Multiple Requests
10m 49s
03
0403 - Finding Ranges of Dates
4m 14s
04
0404 - Finds with Special Operators
8m 37s
05
0405 - Finds and Indexing andPerformance, Stored Calcs
6m 15s
06
0406 - Finds Constrain and Extend
4m 37s
07
0407 - Sorting Records
7m 38s
08
0408 - Custom Sort Orders
7m 42s
01
0501 - Layouts - Available tools
13m 15s
02
0502 - Tour of the Inspector
21m 29s
03
0503 - Intro to Adding Fields toDatabase (Text and Number)
12m 11s
04
0504 - Added Calc fields and HidingObjects
11m 40s
05
0505 - Creating a Survey & TabPanels & Value Lists
14m 28s
06
0506 - Value Lists - Under the hood
9m 11s
07
0507 - Hiding Objects & ConditionalFormatting
13m 26s
08
0508 - Text Fields with User SpecifiedFormatting
11m 20s
09
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
01
0551 - Container Field Introduction
11m 40s
02
0553 - Advanced Container FieldKung-Fu
11m 1s
03
0556 - Interactive Containers inFileMaker
15m 35s
04
0560 - Containers in FMSP
6m 33s
05
0562 - HiJacking Containers in FMStarting Point
17m 2s
06
0580 - When Container Storage goesBad..
8m 38s
01
0601 - Making Layouts load 200%faster in FM 16 - Performance
7m 16s
02
0602 - 200% faster Part 2 -Performance
8m 12s
03
0603 - 200% faster Part 3 -Performance
2m 53s
04
0604 - Grouping with Slide Panels toHide Objects
5m 45s
05
0605 - Get Object Attribute forHidden Objects
2m 52s
06
0608 - Script Triggers - Intro
4m 17s
07
0609 - Script Triggers - LayoutSpecific
10m 3s
08
0610 - Script Triggers - Object Specific
7m 51s
09
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
01
0701 - Sharing Data Intro
1m 17s
02
0702 - Importing Data
14m 34s
03
0703 - Exporting Data
7m 59s
04
0704 - Scripting Import & Exports -Basics
4m 31s
05
0706 - Send Email Script Step
3m 53s
06
0707 - Finding Your SMTP Settings
8m 40s
07
0708 - Automating outbound emails
6m 51s
08
0709 - Spamming with FileMaker
8m 7s
09
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
01
0803 - Barcode DeploymentPlanning & Options
12m 20s
02
0804 - Installing the BarcodeCreator into FMSP
7m 21s
03
0805 - Scanning Items into Invoiceswith Barcodes
2m 25s
04
0806 - Under-the-hood withScanner Barcodes In FMSP Part 1
7m 20s
05
0807 - Under-the-hood withScanner Barcodes In FMSP Part 2
8m 40s
06
0808 - Under-the-hood withScanner Barcodes In FMSP Part 3
12m 52s
07
0809 - USB Barcodes Gun We'reUsing
6m 40s
08
0810 - Setup Up Printer Labels &Users Scanning the Wrong Barcode
6m 23s
09
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
01
0901 - Scripting
9m 58s
02
0902 - Intro to Script Workspace
11m 47s
03
0903 - Workspace KeyboardShortcuts
10m 56s
04
0904 - Set fields vs
16m 35s
05
0905 - Set fields & Context
2m 29s
06
0906 - Buttons run one Command
15m 2s
07
0907 - Navigation
3m 27s
08
0908 - IF...THEN...decisions
6m 30s
09
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
01
1001 - Calculation Engine & NewWork Space
13m 21s
02
1002 - Calculation Engine & NewWork Space Part 2
4m 48s
03
1010 - Parsing Text with Calcs - Part1
12m 7s
04
1011 - Parsing Text with Calcs - Part2
11m 33s
05
1012 - Detecting Window Mode andFilter Function
11m 14s
06
1013 - Date Calcs
5m 11s
07
1014 - Detecting Device & PlatformTypes
3m 27s
08
1020 - Get Functions Walkthrough -Part 1
8m 51s
09
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
01
1101 - What is a Relationship?
9m 27s
02
1102 - Table Occurrences Basics
11m 52s
03
1103 - Relationship Graph & ERDs
12m 23s
04
1104 - What is a Portal..
6m 42s
05
1105 - Multi-Predicate Relationships
8m 46s
06
1106 - Multi-Key Relationships
11m 1s
07
1107 - Cascading Adds
7m 24s
08
1108 - Cascading Deletes
6m 12s
09
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
01
1201 - Security in FileMakerOverview
5m 21s
02
1202 - Accounts and Privileges
12m 11s
03
1203 - Extended Privileges...theBasics
10m 26s
04
1204 - Extended Privileges...RecentChanges
9m 8s
05
1205 - Encryption at Rest (EAR)
9m 12s
06
1206 - Point-to-Point Encryption -SSL Certificates
52m 27s
07
1207 - Audit Trails - Part 1 -Overview
12m 25s
08
1208 - Audit Trails - Part 2 -Technical
11m 46s
09
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
01
1301 - Deployment & Sharing
19m 10s
02
1302 - FMS Admin Walkthrough
18m 23s
03
1303 - Scheduling Backups
14m 45s
04
1304 - Progressive Backups
4m 48s
05
1305 - Restoring from a Crash
18m 58s
06
1306 - Server PerformanceImprovements 14 - Nick Lightbody
44m 7s
07
1307 - Server PerformanceImprovements 15 - Nick Lightbody
31m 27s
01
1401 - Printing and PDF Generation
13m 14s
02
1402 - Structuring your data so it isreportable
4m 29s
03
1403 - List View for Ad-HocReporting
4m 9s
04
1404 - Layout Parts on List View -for Beginners
9m 34s
05
1405 - FileMaker Report Wizard -Very Cool
10m 20s
06
1406 - Printing & Reporting onGovernment Forms
7m 4s
07
1407 - Subsummaries in Detail
11m 17s
08
1420 - State of Charting in FileMaker
13m
09
1421 - Built-in Charting Overview
19m 34s
10
1422 - Google Charts
12m 12s
11
1425 - MultiPage Append to PDF
7m 19s
01
1501 - Top 10 FileMaker CustomFunctions (For Senior Developers)
17m 46s
02
1502 - Richard Carlton's Top 5FileMaker Custom Functions
13m 44s
03
1503 - Parsing XML - CustomFunction
16m 40s
01
1602 - Creating PDF's and Emailingfrom WebDirect
16m 34s
01
1701 - Performance Improvementsin 14 - Advanced
8m 1s
02
1702 - Database PerformanceTuning with Nick Lightbody
51m 12s
03
1704 - 3 Areas of PerformanceImprovement in Pro 15
10m 25s
04
1706 - 3 Area of PerformanceImprovement in Pro 14
9m 29s
05
1708 - How to make an AssetDatabase in 5 Minutes
7m 59s
06
1717 - PHP #1 - Overview
11m 52s
07
1718 - PHP #2 - Technical ProcessWalkthrough
10m 34s
08
1719 - PHP #3 - Sample CodeReview
16m 55s
09
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
01
1802 - Detailed Comparison withRegular FileMaker Server
16m 30s
02
1803 - Is FileMaker Cloud Right foryou?
8m 15s
03
1804 - Brain Dump for ExperienceFileMaker Developers
16m 38s
04
1805 - How to Buy FMC - Directfrom AWS - New Users
18m 30s
05
1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses
17m 27s
06
1807 - Uploading files to FileMakerCloud
7m 16s
07
1809 - Picking the right size ofAmazon Server
9m 43s
08
1811 - Understanding Amazon'sTotal Cost
14m 32s
09
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
01
1902 - Who takes the FileMakerCertification test?
5m 19s
02
1904 - What is FMI's Official StudyList Part #1
12m 34s
03
1905 - What is FMI's Official StudyList Part #2
15m 53s
04
1906 - Final Test Taking Tips...
10m 43s