Introduction to FileMaker Pro 15.0

Duration: 2 Days

Objectives

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.

Pre-requisites

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 (glyphs)

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

  • Entering data from the last visited record
  • 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

  • What is a Summary field?
  • 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 many-to-one relationships
  • Using Portals
  • Using Lookups

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

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.

Related Courses


"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

"Absolutely top quality training and facilities."

National Museum of Wales

"Brilliant. Exactly what was needed."

NHS



 

 

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