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.

"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "

Paresh Dudhaiya

"Clear and concise explanations of all program capabilities, very helpful."

Hyder Consulting Ltd

"Our trainer worked at a great pace and was very easy to understand."

Clarks International

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