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 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.

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.

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

FileMaker Pro: Intermediate

FileMaker Pro: Introduction to Scripting

Microsoft Excel: Intermediate / Advanced

Microsoft Access: Introduction

Microsoft Access: Intermediate / Advanced

VIEW MORE COURSES >

How to Compress Video Media in PowerPoint to Reduce File Size

You can compress video (and / or audio) media in a PowerPoint presentation to reduce file size. Since video and audio that is inserted into a PowerPoint file is embedded by default, video and audio media can increase file size significantly.

How to Fill Blank Cells with Zeros, Dashes or Other Values in Excel

You can quickly fill blank cells in a range of data in Excel with dashes, zeros or other number or text values. Blank cells can be problematic if you want to use a data set as the source for a pivot table.

How to Insert a Countdown Timer in PowerPoint

You can insert several types of countdown timers in PowerPoint presentations. In this article, we’ll review the steps to create 3 types of timers in PowerPoint using shapes and animations.

How to Change Margins in Google Docs

You can change margins in Google Docs using the Page Setup dialog box or by using the Ruler. You have the option of changing the top, bottom left and right margins for your document. Note that margins can be different in each section of a document if you have inserted section breaks. By default, a Google Docs file contains one section.

How to Create and Print Labels in Word (Mail Merge Using Excel Source Data)

You can create labels in Microsoft Word by running a mail merge. This is typically used to generate and print bulk mailing labels for names and addresses of clients or other contacts. You’ll need to create a main document for the labels in Word and then connect to a data set or list in an Excel worksheet.

How to Subscript in Google Docs (Mac or Windows)

You can apply subscript to text, numbers or special characters in Google Docs using the menu or a keyboard shortcut. If you apply subscript, the selected letter, number or symbol will be lowered slightly below the line of text and sized to a smaller size.

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.