Filemaker pro advanced

Overview
Taking Filemaker Pro further after Filemaker Pro Introduction taking in advanced features and techniques.

Prerequisites
Delegates must have experience with using standard components of a Macintosh or Windows computer, including full knowledge of keyboard, mouse and relevant operating systems and a good understanding of FileMaker Pro v7 or above.

Course Content Refreshing on FileMaker 9

• File Size limits
• Database File References
• Defining Databases
• Multiple Table Structure

Defining Fields

• Data Types
• Indexing
• Globals
• Complex calculations
• New functions

Layout Mode

• Selecting the table
• Layout Options
• Auto save vs. Manual
• Views
• Field Behaviour
• Inserting Fields

Interface Design Techniques Using Tabs to navigate data regions Colour coding and usability Building Relationships

• One to One
• One to Many
• Many to Many
• Simple - Equal Match
• Complex - Unequal Match
• Multiple Match
• (Equal and /or Unequal)
• Entity Relationship Diagram and the DOM
• Portals

Scripts

• Web Compatibility
• Accessibility to Scripts
• Looping Scripts
• Multiple User environments
• Custom Dialogues
• New Windows

Importing and Exporting

• Exporting Found Sets
• Formatting Records
• Export Format
• Exporting field content
• Importing from FileMaker
• Importing from Excel
• Field Mapping

Networking Multiple Users

• Network Ports
• Layouts
• Scripts
• User Access and Security

Accounts and Privileges

• Admin User
• Privilege Sets
• Other Users
• Extended Privileges

Advanced Features

• Web Viewer
• Conditional Formatting
• Advanced Tab Control
• Object Navigation and Control
• Custom Functions
• Custom Menus
• Object Anchoring