FileMaker Pro: Introduction

FileMaker Pro Training Series | Level 1

Course Details

Duration: 1 day

Software Versions: 13 | 14 | 15 | 16 (other versions on request)

Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request

Course Dates: August 2, 2019 | View schedule Course schedule

Course Fee:  $245 CDN per person + HST (bring your own device) or $295 CDN per person + HST (Avantix Learning provides device)*

Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.

Register for this training course.

Course Overview

During this hands-on FileMaker training course, students will work with this powerful relational database program to create and edit FileMaker databases with tables and multiple layouts. Tables will be designed with various types of fields and properties including fields with drop-down menus, lists, radio buttons and check boxes. Various layouts will be created and formatted for entry and reporting. Students will create multiple find requests with different types of criteria to extract data and will also create reports with calculated fields and summary totals. At the end of the day, students will create a simple relationship between two tables. Throughout the course, the instructor will include numerous tips, tricks and shortcuts.

Prerequisite: Basic keyboarding skills and computer skills

Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. For more information including savings for custom group training, email us at info@avantixlearning.ca or contact us by phone.

Related: View all FileMaker training courses >

INCLUDED IN THIS COURSE

  • Comprehensive course manual
  • Sample and exercise files
  • Refreshments (for classes conducted in Avantix Learning classrooms)
  • Certificate of completion
  • Follow-up email support

Course Topics

Getting Started with FileMaker

  • Components of a database
  • FileMaker’s saving behaviour
  • Creating and saving a new FileMaker database
  • Using the Manage Database dialog vs Field Picker
  • Working with FileMaker’s modes or views

Creating Tables and Fields

  • Creating tables with different types of fields including text, number and date
  • Setting properties or options for fields
  • Auto-entering data in specific fields (such as dates)
  • Creating simple calculated fields in FileMaker
  • Renaming a table
  • Adding or changing fields
  • Viewing data in Browse mode

Adding and Modifying Records

  • Viewing as form, list or table in Browse mode
  • Entering and editing records in Browse mode

Navigating in FileMaker

  • Moving between FileMaker’s views using different strategies
  • Navigating between fields
  • Navigating between records

Creating and Editing Layouts

  • Working with FileMaker’s Inspector, menus and toolbars in Layout mode
  • Formatting the initial FileMaker layout by changing themes
  • Changing fonts and sizes
  • Moving and resizing fields and labels
  • Changing colours
  • Adding titles
  • Creating new layouts to display different types of data in different ways
  • Adding and removing fields from a layout
  • Renaming layouts

Finding Records

  • Using FileMaker’s Find mode to find records using multiple criteria
  • Creating multiple find requests in and/or scenarios
  • Deleting found records
  • Omitting records
  • Automating repetitive finding by saving find settings

Enhancing Layouts

  • Adding a logo to a layout
  • Creating letter layouts with merge fields
  • Creating label layouts with merge fields
  • Automating FileMaker by creating pop-up menus, drop-down lists, radio buttons and check boxes in layouts

Creating and Formatting Reports in FileMaker

  • Creating report layouts with different parts including Header, Body and Footer parts
  • Adding grand summary parts to a report
  • Creating grand totals in reports using summary fields
  • Previewing reports

Creating a Relationship

  • Setting up a simple relationship between tables based on a key field
  • Overview of FileMaker’s table occurrence logic
  • Creating a layout that extracts information from two or more tables

Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.

If you need more information or would like to arrange custom training, contact us.

To request this page in an alternate format, contact our staff.

*Prices subject to change.

 

Copyright 2020 Avantix® Learning Inc.

Student typing on laptop in classroom situation.

You may like

How to Convert PowerPoint to Google Slides (5 Ways)

How to Convert PowerPoint to Google Slides (5 Ways)

You can import or convert a PowerPoint presentation in PPTX format to Google Slides format in several ways. Google Slides will try to convert a PowerPoint presentation to compatible objects, tools and fonts but these programs do have differences so don’t expect a perfect conversion.

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

You can change the formatting of a table border or the borders of multiple table cells in PowerPoint by changing the line style, thickness (weight) or color. Different borders can be applied to cells in the same table. For example, you could apply a thick line to header cells and a thin line to the cells in the last row of a table.

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

You may also like

How to Convert PowerPoint to Google Slides (5 Ways)

How to Convert PowerPoint to Google Slides (5 Ways)

You can import or convert a PowerPoint presentation in PPTX format to Google Slides format in several ways. Google Slides will try to convert a PowerPoint presentation to compatible objects, tools and fonts but these programs do have differences so don’t expect a perfect conversion.

How to Create, Save, Use and Edit Templates in Microsoft Word

How to Create, Save, Use and Edit Templates in Microsoft Word

You can create, save, use and edit templates in Microsoft Word for frequently-used documents such as letters, reports, proposals and manuals. Templates include basic character, paragraph and page formatting and may include text, custom styles, tables, images, macros, sections, headers and footers.

FileMaker, FileMaker Go and the file folder logo are registered trademarks of FileMaker, Inc. in the U.S. and other countries. Mac and the Mac logo are trademarks of Apple Inc. registered in the U.S. and other countries. Microsoft and Windows are registered trademarks of the Microsoft Group of Companies. All other trademarks are the property of their respective owners.

Upcoming Training
Course
FileMaker Pro: Introduction (Toronto course)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario,Canada-M5E 1W7
Next course starts
August 2, 2019
Next course ends
August 2, 2019

Pin It on Pinterest