Overview

Our Advanced Filemaker Pro course concentrates on the creation of multi-file solutions and defining relationships. It also introduces ScriptMaker and the customisation of the user interface.

Course Outline

Database structure

Multi-file database solutions, Different types of relationships, Functions and calculations, If statements, nested If statements, Using global fields, Creating summary fields, Verifying data entry

Productivity

Complex find and sort criteria, Using scripts with Find and Sort, Auto enter and validation, When to use the lookup option, Creating a master password, Creating limited access passwords

Layouts and reports

Advanced drawing techniques, Layout mode shortcuts, Customising tab order, Field format options, Revision of layout parts, Using sub-summaries, Grand summary parts, Incorporating related fields, Using portals, Sorting records in a portal, Editing related records

Scripts and buttons

Creating a script, Overview of ScriptMaker, Attaching a script to a button, Using graphics as buttons, Invisible buttons, Non-printing buttons