Advanced FileMaker 19 is an intensive three-day course that gives students who are already adept with FileMaker the opportunity to enhance their skills.
Day 1Students begin by working through a moderately complex relational database design problem using a process that they can apply to any project scenario, and then move on to various design methodologies and architectures, including issues inherent in working with single file and multi-file systems. Considerations for revising deployed systems will be reviewed.
Students will learn about design challenges that arise in multi-user systems and how to address them. A significant amount of time will be spent on FileMaker's security system, including how to capture user logins, using custom extended privileges to drive system logic, and setting up rules-based deletion and editing. Students will also learn to design security implementations that are portable and can be deployed in multiple locations without requiring new security configurations with each setup.
Day 2Students will spend the day on exercises that emphasize using various calculation functions to solve specific design problems and using calculations with scripts and script triggers.
Day 3Day 3 will be spent on advanced reporting techniques using multiple reporting design challenges that feature the use of triggers to automatically maintain join tables, using dedicated report utility tables to combine report data that resides in multiple tables into a single report, how to have single records appear in multiple contexts in the same report, using dynamic labeling and graphical elements, constructing reports that can display different row styles for different records or record types, and using loops to compile report values.
Topics Include How To
- Relational database design
- Quick Charting
- Inspector and Layout Objects windows
- Scripting and script triggers
- Object Badges
- Importing and setting up recurring imports
- Advanced report creation and automation