Introduction to FileMaker Pro

Duration: 2 Days


FileMaker Pro is the database “for the rest of us” - a rapid development tool that non-coders can use to manage all aspects of their business. Our introductory course teaches the key techniques in FileMaker needed to build databases, including table structure, layout design, comprehensive search techniques and ways to control the consistency and appearance of data. The course also introduces the fundamentals of relational database design, so that information can be shared across layouts, and the basics of simple automation using buttons.


None other than basic IT competency.

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

Getting started

  • Definitions: databases, tables, records & fields; field types
  • The FileMaker Quick Start screen
  • Creating a database (1) From scratch; (2) From an Excel spreadsheet
  • Modes and Views
  • Creating, modifying and editing records
  • Sorting records and Finding records using different search criteria

Creating and modifying layouts

  • What are layouts?
  • Creating new layouts
  • Form, List and Report layouts
  • Applying and reapplying Layout Themes
  • Using the Field picker to add fields to a layout
  • Using the target device stencils
  • Placing date and page number codes
  • Using Tab controls
  • Applying field, border, text, number and Conditional formatting
  • Using Popovers and Slide Controls

Simple Button actions

  • The principles of database automation with buttons and scripts
  • Creating simple buttons
  • Attaching button icons

Comprehensive searching techniques

  • Include and Omission searches
  • Using multiple search criteria
  • Using multiple requests
  • Using Saved Finds
  • Using QuickFind

Controlling entry of data into fields

  • Using Value Lists and Calendar Popups
  • Auto-entry of data and calculated values; validation of values
  • Formatting the data in fields
  • Using In-Field labels

Calculation fields

  • Calculation types including Number, Date and Text calculations
  • Using arithmetic and formulae
  • Introduction to some popular functions including Text, Number and Logical functions

Updating record sets

  • Using the Replace Field Contents command
  • Updating with a fixed value
  • Updating Serial Numbers
  • Updating according to a calculated formula

Summary fields and summarised reports

  • Understanding Summary fields
  • Creating a Summarised Report
  • The Sub-summary Part
  • The Sort field for Sub Summaries

Merge Fields and “Mail Merge” style options

  • What is a merge field?
  • Placing merge fields on the layout
  • Designing a mail-merge letter layout

Creating simple charts

  • Using the charting tool
  • Creating simple pie, bar, horizontal bar, line and area charts
  • Adding chart and axis titles
  • Formatting the chart

Introduction to Relational Databases

  • Defining relationships between tables and understanding the concept of key fields
  • Understanding one-to-many and other forms of table joins
  • Using Portals
  • Using Lookups

Live Chat

Course Dates

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
30 Sep - 1 Oct £445 + VAT Book Now
19 - 20 Nov £445 + VAT Book Now
19 - 20 Dec £445 + VAT Book Now
See more dates...

London Greenwich

Dates Price Book Now
18 - 19 Sep £445 + VAT Book Now
14 - 15 Oct £445 + VAT Book Now
7 - 8 Nov £445 + VAT Book Now
10 - 11 Dec £445 + VAT Book Now
See more dates...


Dates Price Book Now
10 - 11 Sep £445 + VAT Book Now
10 - 11 Oct £445 + VAT Book Now
12 - 13 Nov £445 + 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.

"Absolutely top quality training and facilities."

National Museum of Wales

"One of the most enjoyable and informative courses I have ever attended."

Invacore Ltd

"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

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