Module 1: Introduction to Filemaker
Defaults and Preferences
Terms, tools, menus.
Working with text, basic fields and records
Sorting and selecting
Layout control and parts
Lines and fills
Introduction to calculations
Summaries and sub-summaries
Reports
Mailmerge
Office oriented examples

Module 2: Filemaker Intermediate
Introduction to Relational Databases
Defining relationships between databases
Lookup, Choose and Case functions
Portals
Security and password protection
Automatic and restricted fields
Introduction to scripting
Buttons

Module 3: Purchase. Sales and Inventory Type Applications
Setting up a typical inventory, purchasing and sales system.
Invoicing and statements
GST
Bank reconciliations
Customer account reconciliations
Commissions
Samples on loan etc.

Module 4: Course Enrolment Type Applications
Normalised databases for students, courses, fees, locations, scheduling
Results recording and reporting.
Form letters
Security issues for data entry and extraction.

Module 5: Financial Analysis
Importing data from common accounting packages
Normalised relational databases for stockand service type items
Scripting to construct reports
Exporting to Excel etc for automated graphing of results
Refer also to the DreamWeaver UltraDev and Generator courses for remote access to databases with dynamic reporting using a browser.

Module 6: Special Topic
A custom course to suit the particular direction that the Filemaker is to be taken in. This is designed and taught only after consultation with the recipients.
See also our consultancy work from the main menu above.