Intermediate FileMaker
Description: A 3-day class that covers the concepts to create a relational database with FileMaker Pro. Learn to understand data modeling and create an entity-relationship diagram; use the relationship graph in FileMaker Pro; create complex filtering relationships; understand and implement calculations in various contexts (auto-enter, validation, conditional formatting, calculated replace); create scripts to automate routine tasks (user interaction, finding data, navigation, windows, looping).
| Class |
Dates |
Price |
|
| Intermediate FileMaker |
Aug 13-15
Oct 15-17
|
$995 |
Level: Intermediate. Want to go further? Try Advanced FileMaker.
Prerequisites: Introduction to FileMaker or 3 months experience using databases with FileMaker Pro (7, 8, 8.5 or 9).
Data Modeling - Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. This module also covers lessons in building layouts using related data fields and portals.
- Break a real-world scenario into a set of entities and their attributes
- Identify cases where one-to-many or many-to-many relationships are appropriate
- Create an entity-relationship diagram (ERD)
- Create relationships between FileMaker Pro tables
- Understand relationship options
- View and manage related FileMaker Pro data via a portal
- Create complex relationships for filtering views of related data
|
Calculations - Learn how functions work in the calculation engine in FileMaker Pro 9. Study how custom functions are built and how to best apply them to database solutions.
- Be familiar with the most common and useful calculation functions
- Be able to create calculation fields
- Know how to use calculations for field auto-entry and validation
- Have experience using calculation functions in a variety of practical contexts
- Understand how and why to use custom functions
|
Scripts - User controls and interface elements are generally driven through scripts in FileMaker Pro. Explore best practices in scripting, learn how to build navigation and window controls, and study logical branching and looping routines.
- Attach scripts to buttons
- Create scripts that interact with users, perform finds, and manipulate data
- Use the Script Debugger and Data Viewer to troubleshoot scripts
- Add error trapping routines to scripts
- Use script parameters, script results, and script variables
- Create scripted routines for generating related records
- Use loops to perform iterative tasks
|
|
