Pass IT Certication
Exams Guaranteed!

100% Real Questions from Actual Test
Accurate Answers Verified by Experts
Free New Questions Updates
99.8% Pass Rate Guaranteed
Exam Simulator Included!

Practice Exams:

Microsoft

Home Online Courses IT & Software Certifications FileMaker 16: FileMaker 16

Best seller! ~~$21.99~~ $19.99

FileMaker 16: FileMaker 16

PDFs and exam guides are not so efficient, right? Prepare for your FileMaker examination with our training course. The FileMaker 16 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to FileMaker certification exam. Pass the FileMaker FileMaker 16 test with flying colors.

133 Students Enrolled 278 Lectures 01:50:00 Hours

Curriculum For This Course

1

0100 - Introductions - Overview

9Lectures

Time 01:16:00

2

FM Starting Point Walkthrough

19Lectures

Time 03:28:00

3

0300 - Fundamentals & Basics

9Lectures

Time 01:11:00

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

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

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

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

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

0550 - Containers Field & DocumentManagement
	1. 0551 - Container Field Introduction	11:40
	2. 0553 - Advanced Container FieldKung-Fu	11:01
	3. 0556 - Interactive Containers inFileMaker	15:35
	4. 0560 - Containers in FMSP	06:33
	5. 0562 - HiJacking Containers in FMStarting Point	17:02
	6. 0580 - When Container Storage goesBad... Recovery Plan...	08:38

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Student Feedback

4.5

Good

55%

45 %

0%

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Pass IT Certication Exams Guaranteed!

FileMaker 16: FileMaker 16

Curriculum For This Course

Student Feedback