FileMaker Pro: Introduction

FileMaker Pro Training Series | Level 1

Course Details

Duration: 1 day (9 am – 4 pm)

Software Versions: 17 | 18 | 19 (other versions on request)

Delivery Methods (Instructor-led): Live classroom (LC) | Virtual classroom (VC)

Course Dates: June 14, 2021 | View schedule Course schedule

Course Fee: $275 CDN per person + HST (Virtual classroom), $295 CDN per person + HST (Bring your own device for live classroom courses) or $345 CDN per person + HST (Avantix Learning provides device for live classroom courses)*

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

Note: Public scheduled courses are delivered as live instructor-led classroom training or virtual classroom training (as indicated). Bring your own device rates apply to live classroom courses.

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.

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 2021 Avantix® Learning

Student typing on laptop in classroom situation.

Custom training

Register now for a public scheduled course or contact us to discuss on-site or off-site custom training solutions.

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Access: Introduction

Microsoft Access: Intermediate / Advanced

VIEW MORE COURSES >

You may like

How to Convert Cm to Inches in Excel (or Inches to Cm)

How to Convert Cm to Inches in Excel (or Inches to Cm)

You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.

How to Hide Comments or Notes in Excel Workbooks

How to Hide Comments or Notes in Excel Workbooks

You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.

How to Delete Blank Rows in Excel (5 Ways)

How to Delete Blank Rows in Excel (5 Ways)

You can delete blank rows in Microsoft Excel worksheets manually or you can use several tricks to remove multiple blank rows quickly. Check out 5 different ways to easily delete blank rows in your data.

How to Move a Pivot Table in Excel

How to Move a Pivot Table in Excel

Moving a pivot table is not as simple as moving other objects in an Excel worksheet or workbook. You will typically need to use the Move PivotTable command in the Ribbon to move a pivot table to a different area on a worksheet or to a different sheet in the same workbook.

You may also like

How to Insert a Nonbreaking Space in Word

How to Insert a Nonbreaking Space in Word

You can keep text together in several ways in Word. If you want to keep words or characters together, you can use nonbreaking spaces or nonbreaking hyphens or dashes and insert them using a dialog box or a keyboard shortcut. If you want to keep lines or paragraphs together on the same page, you can apply settings in the Paragraph dialog box (which can be built into styles if you use styles).

How to Use Wildcards in Word to Find and Replace

How to Use Wildcards in Word to Find and Replace

If you want to find and replace text or numbers in Word, you can use wildcards if you are not able to find an exact match. To use advanced find and replace techniques in Word, you will need to expand the Find and Replace dialog box.

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
June 14, 2021
Next course ends
June 14, 2021

Pin It on Pinterest