Intermediate FileMaker Pro: Relational Database Design and Scripting

Duration: 2 Days

Objectives

This FileMaker Authorised course teaches good practice in the design of efficient relational database systems. The course includes full explanations of how and when to link tables together using primary and secondary keys in FileMaker Pro and introduces FileMaker scripting, to provide automation and efficiency of procedures within a database solution. It also looks at techniques to improve the user experience, such as helpful navigation and the use of multiple windows and introduces the power of FileMaker calculations.

Pre-requisites

Attendance on the Introduction to FileMaker Pro course, or equivalent experience e.g. knowledge of the FileMaker field types, layout parts, designing and formatting layouts and the basics of the FileMaker Calculation engine.

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

Introduction to relational database systems

  • The efficiencies achieved using related tables and the problems they solve
  • Defining relationships between tables and understanding the Match field
  • “One to many” relationships
  • “One to one” relationships
  • “Many to many” relationships

Managing data using One-to-Many relationships

  • Placing fields from a “parent” table on a “child” layout
  • Understanding and using portals on a “parent” layout
  • Displaying related records in a portal
  • Creating new records in a portal
  • Navigating related files using the Go to Related Record script step
  • Filtering portals

Introduction to Scripting

  • Scripts v. button single actions
  • Creating, duplicating and editing scripts
  • Locating and adding script steps to a script
  • Commonly scripted procedures
  • Running scripts from buttons
  • Building a Button Bar
  • Scripting the creation of new windows
  • Use the Card style window
  • Specifying name, size and position
  • Switching between windows
  • Organising scripts using the Script Workspace window
  • Organising scripts in folders

Scripting the creation of records

  • Recap on the concept of primary and secondary keys
  • Scripting the creation of related records using Set Variable and Set Field script steps
  • Using the Commit Record script step
  • Refreshing portals

The power of calculation fields

  • Formulae, operators and functions
  • Using Text and Number functions
  • Using logical functions such as If, IsEmpty and Case
  • Using aggregate calculations such as Count, Min and Max
  • Using the Let function

Database sharing and security issues

  • Defining accounts and passwords
  • Understanding privilege sets
  • Granting limited access by specifying a formula or rule
  • Assigning full access rights to a script

Further scripting techniques

  • Using script variables
  • Using script parameters
  • Running scripts using event triggers
  • Script trigger categories
  • Using script triggers - worked examples
  • Using custom dialogs in scripts
  • Using conditional script steps; If/EndIf and Else
  • Using globally stored fields as part of a scripted search
  • Scripting the export of data e.g as an Excel file or as a PDF and using variables to name the output file

Course Dates

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
22 - 23 Feb £495 + VAT Book Now
28 - 29 Mar £495 + VAT Book Now
26 - 27 Apr £495 + VAT Book Now
28 - 29 May £495 + VAT Book Now
28 - 29 Jun £495 + VAT Book Now
30 - 31 Jul £495 + VAT Book Now
30 - 31 Aug £495 + VAT Book Now
20 - 21 Sep £495 + VAT Book Now
22 - 23 Oct £495 + VAT Book Now
12 - 13 Nov £495 + VAT Book Now
22 - 23 Nov £495 + VAT Book Now
12 - 13 Dec £495 + VAT Book Now
24 - 25 Dec £495 + VAT Book Now
See more dates...

London Greenwich

Dates Price Book Now
24 - 25 Jan £425 + VAT Book Now
15 - 16 Feb £495 + VAT Book Now
15 - 16 Mar £495 + VAT Book Now
16 - 17 Apr £495 + VAT Book Now
16 - 17 May £495 + VAT Book Now
18 - 19 Jun £495 + VAT Book Now
18 - 19 Jul £495 + VAT Book Now
20 - 21 Aug £495 + VAT Book Now
20 - 21 Sep £495 + VAT Book Now
22 - 23 Oct £495 + VAT Book Now
22 - 23 Nov £495 + VAT Book Now
See more dates...

Bristol

Dates Price Book Now
29 - 30 Jan £445 + VAT Book Now
19 - 20 Feb £495 + VAT Book Now
19 - 20 Mar £495 + VAT Book Now
19 - 20 Apr £495 + VAT Book Now
21 - 22 May £495 + VAT Book Now
21 - 22 Jun £495 + VAT Book Now
23 - 24 Jul £495 + VAT Book Now
23 - 24 Aug £495 + VAT Book Now
24 - 25 Sep £495 + VAT Book Now
24 - 25 Oct £495 + VAT Book Now
26 - 27 Nov £495 + VAT 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.


"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills

"The course was perfect. Great course, great trainer!"

Northgate

"The course was an excellent experience and will further my career opportunities."

Adjective Graphic Design



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260