FileMaker Pro Introduction


  • FileMaker Pro Introduction

    We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.

    Mondrian Investment Partners Limited
    August 2024
  • FileMaker Pro Introduction

    My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!

    The White Wall Company
    August 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    August 2024
  • FileMaker Pro Introduction

    I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.

    Beaulieu Motor Museum
    August 2024
  • FileMaker Pro Advanced

    I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!

    Trinitas Consulting
    August 2024
  • FileMaker Pro Advanced

    We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.

    Rebecca F
    August 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    August 2024
  • 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.

    Paresh Dudhaiya
    August 2024
  • Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

    Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.

    Techedology
    August 2024
  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    August 2024
  • 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. Thank you Transmedia for being so helpful!

    Lucie M
    August 2024
  • I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!

    Julian Support
    August 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    August 2024
  • Great delivery, enjoyable training session.

    August 2024

Course Facts

  • 2 day course
  • Our Trainers are Authorised Professionals
  • Live Online or Classroom-based
  • Certificate of completion
  • Maximum class size of 6 for scheduled courses
  • Unlimited support after your course
  • Courses at all levels: Introduction, Intermediate, Advanced and Masterclasses

Course Outline

  • Creating and modifying layouts
  • Simple Button actions
  • Comprehensive searching techniques
  • Controlling entry of data into fields
  • Calculation fields
FULL OUTLINE
  • FileMaker Pro Introduction

    We attended the FileMaker course with Nick. He was very through and patient with our questions or when we couldn't make something work properly. Really looking forward to redesigning our database.

    Mondrian Investment Partners Limited
    August 2024
  • FileMaker Pro Introduction

    My Transmedia consultant was incredibly patient and thorough and after just a few days of his tutelage, it's clear we have been shown enough to give us all many hours of our lives back with a more efficient system!

    The White Wall Company
    August 2024
  • FileMaker Pro Introduction

    The set up was very professional and my trainer was very knowledgeable. Highly recommended.

    Bladeroom
    August 2024
  • FileMaker Pro Introduction

    I was very impressed. Nick was very reassuring and patient. Really delighted with the content we managed to get through and am now feeling more confident with my new learned skills and abilities.

    Beaulieu Motor Museum
    August 2024
  • FileMaker Pro Advanced

    I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you showed this week. The time I spent learning FileMaker properly was so worth the money and time!

    Trinitas Consulting
    August 2024
  • FileMaker Pro Advanced

    We had a fantastic session with Tony focused on designing for print. Tony tailored the day to our needs and left us feeling confident with a lot of new knowledge.

    Rebecca F
    August 2024
  • An enjoyable and productive day. A flexible content and pace of work which suited our needs.

    Guardian News & Media
    August 2024
  • 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.

    Paresh Dudhaiya
    August 2024
  • Creating and deploying iOS apps using FileMaker Pro and FileMaker Go

    Outstanding bespoke training delivered by Nick at Transmedia. Nick's level of knowledge on FileMaker Pro teamed with his incredible teaching skills have set my colleague and I up for success.

    Techedology
    August 2024
  • FileMaker Pro Advanced

    The course was excellent - exactly to my company's needs. All questions were answered and concepts explained very clearly.

    Hannah Griffiths
    August 2024
  • 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. Thank you Transmedia for being so helpful!

    Lucie M
    August 2024
  • I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database. My invoicing layouts now work perfectly. Thank you very much!

    Julian Support
    August 2024
  • An excellent trainer with extreme depth of knowledge in the product. Also some really good and helpful shortcuts.

    August 2024
  • Great delivery, enjoyable training session.

    August 2024

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Enquire Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.

Enquire Now

Team Training and Bespoke Sessions

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

  • Sessions can be run online or in person, on your site or at our London training centre.
  • We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
  • Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
  • We offer a free consultation service to work out every detail of your course.

Prices for bespoke sessions with our expert trainers start at £525 + VAT.

Overview

Claris FileMaker Pro is the relational database used by professional developers who value speed and precise layout control in a rapid development tool that allows you to deploy to multi-platform, mixed device environments with ease. With its rich library of functions and a powerful scripting language that's accessible to coders and non-coders alike. Claris FileMaker is almost unique in its versatility.

Our introductory course teaches the key techniques needed to build relational apps, from scratch. We cover table structure, layout design, comprehensive search techniques and ways to control the consistency and validity of data. The course introduces good practise in relational database design, showing you how to share information across layouts, and the basics of simple automation using buttons.

Topics covered include Getting started, Creating and modifying layouts, Simple button actions, Comprehensive searching techniques, Controlling data entry, Conditional formatting, Calculations, Updating record sets, Summary fields and summarised reports, Merge fields, Other layout objects and Introduction to relational databases in theory and practise.
Read More...

Course Outline

Getting started

  • Definitions: databases, tables, records and fields; field types
  • Creating a database from scratch and 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 editing layout themes and styles
  • 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

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

Other layout objects

  • Charts
  • Popovers
  • Slide controls
  • Webviewers
  • Layout calculations

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

Our Clients

Our Recent Success Stories

Sketch Training

Sketch

Mark's Story

Graphic Designer at Just Eat

Photoshop Training

Photoshop

Karen's Story

Picture Editor at Reach PLC

Animate Training

Animate

Stuart's Story

Graphic Designer at S4C

30 years working with Claris
Five Star Training Five Star Training Five Star Training Five Star Training Five Star Training   600+ Reviews

Why Transmedia?

Unlimited Training Support

We offer unlimited training support after your course.

Bespoke Training Solutions

Customised training and software solutions based on your exact specification.

Worldwide Creative Skills Training

Join our authorised training courses live online from anywhere in the world.

Authorised Training Professionals

Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.

Courses Live Online

Join our virtual classrooms to learn from the comfort of your own space in real time from our accredited training experts.

SEE COURSES

Classroom Training

Join us at one of our Authorised Training Centres for a traditional classroom-based experience.

We have everything ready for you to have the best training experience.

SEE COURSES

Private Courses

One-to-one tuition or a private group training with just you or your colleagues.

We can train you live online, at one of our centres or onsite, wherever you are located.

SEE COURSES

Useful Links

Latest Help Station Articles