Advanced FileMaker Pro

Duration: 2 Days

Objectives

This two day course is aimed at those wanting to learn powerful techniques and best practice in FileMaker database design. It covers some of the less obvious features of FileMaker and emphases the creative use of relationships to build user-friendly interfaces and the efficient capture, display and output of data. The course draws on many tried and tested procedures used by FileMaker developers to create database systems that are both easy to use and that possess rich functionality when required.

Pre-requisites

Strong existing FileMaker Pro skills and a good understanding of relationships and scripting. This may be acquired through experience as a database developer or previous attendance on the equivalent Transmedia training course and follow up practice.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Going further with FileMaker Relationships (1)

  • The creative use of relationships
  • Using non-equijoin relationships
  • Multi-parameter relationships
  • Self relationships
  • Using relationships to create conditional value lists

Going further with FileMaker Relationships (2)

  • Achieving better information presentation through filtered portals
  • Controlling portals using relationships with global fields
  • Enhanced control using multi- parameter global field relationships

Looping and batch processing

  • The Replace command versus Looping techniques
  • Setting initial conditions; using global fields; starting and ending a loop
  • Worked examples: (1) Updating a salary field; (2) Creating multiple user accounts at one time

Using Script Triggers

  • The principle and benefits of script triggers
  • Comparing the various trigger conditions for a script trigger (OnObject properties, OnRecord properties, OnLayout properties etc)
  • Simple demonstration example
  • More sophisticated examples including a “Type Ahead” portal search

The Data Separation Model

  • Understanding the concept
  • Benefits of data separation
  • Practical demonstration

Using the Execute SQL function

  • Understanding the concept
  • Structuring the query
  • Basic SQL commands used in FileMaker
  • Query tutorials

Tutorial Option - Best Practice For Building A Solution

  • Planning the solution; tables and relationships
  • Creating user-friendly navigation
  • Creating filtered portals
  • Scripting as required
  • Building the solution: Option (1) - Creating a Restaurant Menu solution; Option (2) - Creating a Shopping Cart solution

Course Dates

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
22 - 23 Nov £495 Book Now
2018
15 - 16 Jan £495 Book Now
22 - 23 Feb £445 Book Now
15 - 16 Mar £495 Book Now
16 - 17 Apr £495 Book Now
See more dates...

London Greenwich

Dates Price Book Now
27 - 28 Nov £495 Book Now
2018
8 - 9 Feb £445 Book Now
See more dates...

Bristol

Dates Price Book Now
2018
17 - 18 Jan £495 Book Now
8 - 9 Feb £495 Book Now
8 - 9 Mar £495 Book Now
9 - 10 Apr £495 Book Now
9 - 10 May £495 Book Now
11 - 12 Jun £495 Book Now
11 - 12 Jul £495 Book Now
13 - 14 Aug £495 Book Now
13 - 14 Sep £495 Book Now
15 - 16 Oct £495 Book Now
15 - 16 Nov £495 Book Now
17 - 18 Dec £495 Book Now
See more dates...


All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Exams and Certification

The knowledge gained on this course is a valuable contribution towards passing the Developer Essentials for FileMaker 12 exam, allowing a successful candidate to become an FileMaker Certified Developer.


"Excellent in all areas. The trainer was fantastic."

University of Glamorgan

"I have nearly thirty years experience as an information systems manager and I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you displayed over the last two days. I am self employed and so time spent on a course is time spent not earning. This was worth the money and my time!"

Trinitas Consulting

"Informative, useful, relaxed - Excellent! Will certainly use Transmedia again."

Tate & Lyle



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team