Brief Summary
This course is all about diving into FileMaker Pro with expert John Mark Osborne. You’ll learn to script, calculate, and manage relationships while building a handy invoicing system from the ground up. It’s practical, it’s fun, and it’s perfect for grasping those tricky concepts.
Key Points
-
Learn from John Mark Osborne, the author of Scriptology: FileMaker Pro Demystified.
-
Focus on intermediate and advanced techniques in FileMaker Pro.
-
Build an invoicing solution from scratch to apply what you learn.
-
Understand different types of relationships: one-to-many, many-to-one, one-to-one, and many-to-many.
-
Create an Entity-Relationship diagram (ERD) for better visual understanding.
Learning Outcomes
-
Master intermediate scripting techniques in FileMaker Pro.
-
Design a solid multi-user database solution.
-
Understand and create various types of relationships in databases.
-
Build and utilize an Entity-Relationship diagram (ERD).
-
Finish with a fully functional invoicing system.
About This Course
Intermediate FileMaker Pro 15 Scripting, Calculations, Relationships and Reporting
Learn FileMaker 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 invoicing 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.
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)
Hans V. D.
I am becoming 80 this month. Have wordking experience with computers from the Hollerith machine, IBM 360, IBM370, IBM 1401-mini computers DEC, HP, and IBM36 and then of course the PC starting with the first IBM PC. I have a financial business economics background was controller, business analist for the marketing department, financial director with industrial companies and in the harbour business. Developed a lot of systems as a system analist and project leader. Programmed myself in RPG, Cobol and later Basic, DBase, Foxpro, and MS Access in combination with Visual Basic. In recent years I learned myself by books Ruby and Python. The introduction of how to set up a project and do good preperations by design is from my experience 200% correct. And also very important not yet mentioned in the ontroduction is that after the actual programming has been done you do thorough testing and test every possibility what may go wrong I call that dummy testing. That is very important because you avoid in this way frustations from end users and their cries "it does not work" and by doing so avoid negative sentiment from the start and remember new things are always looked upon with scepcism. The introduction assured me that I have a teacher with a lot of practical experience as what he told match entirely my long experience in the field. I did already some things in filemaker and find it promising as a younger friend with whom I did a lot of complicated projects with in the past already told me. But the philosophy of Filemaker is different from MsAccess and SQL so I though it wise to take a thorough course. I go crisscross through the course and am building a database for a whosale packaging company. If I am stuck somewhere I look in the course for the topic I need so it is more a reference for me then that I am following the course lesson by lesson. But it works!