課程資料
報名日期
全年招生
課程級別
學習模式
修業期
9 小時 5 分鐘
教學語言
英語
授課導師
John Mark Osborne
評分
課程簡介
Learn FileMaker 16 Scripting, Calculations, Relationships and Reporting while building a Contact Manager
Continue learning FileMaker 16 Scripting, Calculations, Relationships and Reporting from the guy who actually wrote the book, Scriptology: FileMaker Pro Demystified. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. Intermediate and advanced FileMaker techniques will be taught throughout the three part tutorial series. In order to better understand every nut and bolt that goes into designing a solution, a single file will be created from scratch. The chosen solution is an Contact Manager or CRM solution for its familiarity to a wide audience and flexibility of applying techniques to other solutions. The completed FileMaker file at each stage is provided to assist with the learning process.
課程章節
- 7 個章節
- 74 堂課
- 第 1 章 Part 3
- 第 2 章 Ultimate Find
- 第 3 章 Becoming a Developer
- 第 4 章 Custom Menus & Security
- 第 5 章 Reminders
- 第 6 章 Wrapping it Up!
- 第 7 章 Working with John Mark Osborne
課程內容
- Design a multi-user solution, Identify and create one-to-many, many-to-one, one-to-one and many-to-many relationships, Create an Entity-Relationship diagram (ERD), Design according to the principals of anchor-buoy relational design, Translate business systems from real-life to electronic using data modeling, Create portals, filtered portals and filtered relationships, Learn how to print properly in a multi-table environment, Work with columns, merge fields, labels and a variety of other print mediums, Create reports using sub summary parts and summary fields, Learn how to script complex automations with decision making intelligence, Create adaptive or dynamic scripts, Work with modular scripting, Capture errors and redirect programming with error analysis, Save and restore found sets for a better user experience, Compare and contrast different approaches to a problem in order to design better solutions, Validate and format a phone number for consistent data entry, Understand record locking and script for multi-user solutions, Learn the differences and best uses for global fields, variables and parameters
此課程所涵蓋的技能
評價
-
DDirk Westerhoff
Fantastic! Here I was able to discover really new ways of searching in FileMaker. The course is worth every cent for these insights alone.
-
DDavid Coutts
Well I was looking for a Contact Database - you know Name , Address , Phone , Email and a few other misc stuff ! DOB for example - Now what did this course deliver ! Well after doing the course i thought i could be a Rocket Scientist and Engineer There was so much much content to learn and digest that doing the course once is most certainly not proficient - At the end it was one of the best solutions i have ever seen - in depth ; very professional ; hard work ; It was fun to do CRM part 1 and 2 but getting onto CRM part 3 - it was starting to cause headaches BUT on finally getting to the end of part 3 - I have to take my hat off to Mr JMO for all that he has achieved with this course ? Of course once for me is not really good enough - i will now take a weeks holiday , trekking , come home again and start the course again - and this time i know what I will be doing most of the time A really wonderful course to take and get involved in - after this it will be a time keeping course for me with the Calendar Conundrum thrown in also from Mr JMO ! Cheers and THANK YOU Mr JMO David
-
SStam Kapetanakis
Great intermediate-advanced tutorial. As with the other instalments there is always something new to learn. Some newer FM features like the object selector panel could have been used with great effect but the teacher sticks to tried n tested methods like moving overlapping fields manually - may be a missed opportunity or may be intentional, but would have been a lot slicker using this in many places… Overall highly recommended.
-
RRobert Jackson
A lot of very useful tips - presented in an interesting, logical and progressive way
