Advanced FileMaker
Description: A 3-day class that covers advanced techniques for FileMaker Pro. Learn to create and distinguish the different types of summary reports; create a cross-tab report and use a web viewer for reporting; setup security in a FileMaker database; control record deletion and implement record-level access; use advanced portal and scripting techniques; create a user preferences table and implement custom menus.
| Class |
Dates |
Price |
|
| FileMaker Advanced |
Aug 26-28
Oct 28-30 |
$1195 |
Level: Intermediate to advanced. Want to go further? Try Server, SQL & Web or Web Publishing with PHP.
Prerequisites: Introduction to FileMaker and Intermediate FileMaker; OR 6 months experience creating databases with FileMaker Pro (7, 8, 8.5 or 9).
Reporting - Practice creating reports in FileMaker Pro, using a variety of techniques. Explore sub-summary reports that group information by break fields. Learn how to build a cross-tab report (with data-driven columns) and an HTML report that is displayed via the Web viewer object.
- Be able to create a basic subsummary report
- Be able to create a bodiless subsummary report, a ranked subsummary report, and a subsummary report that summarizes by multiple variables
- Be able to create a crosstab report and understand the advantages and disadvantages of subsummary and crosstab reporting
- Understand the uses of the web viewer in the context of reporting
|
Security - Study the account-based security features of FileMaker Pro and learn how to implement privilege sets, tie access to database solutions to external authentication servers, control both access and authoring rights to systems, and extend security controls with scripting.
- Be familiar with the security controls in FileMaker Pro
- Know how to create and manage user accounts
- Understand how to associate privilege sets with accounts
- Know how to manage privilege settings
- Understand integration with external authentication servers
- Be able to control record deletion
- Know how to control record level access
|
Advanced Techniques - Work with relational value lists, write scripts that leverage object naming, and explore custom menus in depth. Learn advanced techniques with portals that include dynamic sorting, filtering, row highlights and preview panes.
- Be able to dynamically control the contents of a portal
- Know how to work with value lists in creating relational associations
- Understand two techniques for portal sorting
- Be familiar with more advanced scripting techniques
- Know how to implement custom menus
- Know how to create user records and store preferences in a user table
|
|
