FileMaker Pro: Intermediate
FileMaker Pro Training Series | Level 2
Course Details
Duration: 2 days
Software Versions: 13 | 14 | 15 | 16 (other versions on request)
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: December 27/28, 2018 | View schedule 
Course Fee: $595 CDN per person + HST or BYOD (bring your own device): $545 CDN person + HST*
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
Course Overview
During this course, users will move to the next level and use some of the more advanced features in FileMaker Pro. Students will learn to control data entry using validations and by auto-entering data in text, number and date fields. FileMaker's calculation capabilities will be explored through the creation of calculation fields using various useful functions including IF, Trim, and date functions. Students will create advanced reports using summary fields and parts and will group records in reports. Relationships will be created between fields in multiple tables to allow the display of information from related tables in layouts and by using portals. More advanced controls will be added on layouts including tabs, popovers and button bars. Students will learn to secure a database and to automate tasks using buttons and simple scripts. Throughout this course, the instructor will include numerous tips, tricks and shortcuts and each student will receive a full course manual.
Prerequisite: FileMaker Pro: Introduction or equivalent knowledge and 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 training: 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
Entering and Editing Calculations
- Creating calculation fields in FileMaker using operators and functions
- Using the Replace command to replace data with a calculation
- Using the IF or CASE functions in calculations to provide conditional results
- Creating calculations using date and text functions
Managing Data Entry
- Setting up auto-enter options based on a calculation
- Using validation options with calculations
- Replacing field contents with calculated results
Creating Reports
- Inserting different parts in a report
- Quickly viewing part information
- Creating report layouts that summarize data at the beginning or end of a report using summary parts
- Grouping data within reports and adding subtotals for each group
- Creating reports that summarize by year and by month using date calculations
- Using FileMaker's report assistant/wizard
- Previewing reports
Getting Started with FileMaker Automation
- Creating buttons to navigate in FileMaker, add new records and perform other common actions
- Creating simple scripts to automate common tasks
- Running simple scripts using menus, shortcuts or triggers
- Running scripts with buttons
Relationship Concepts
- Using key fields to set up relationships between tables
- Understanding the importance of data types
- Specifying a primary key
- Using table occurrences to create relationships
Working with Related Fields on Layouts
- Placing fields from related tables in a layout
- Using FileMaker's portals to display multiple related records from a related table
- Adding a button in a portal to go to a related record
- Creating a lookup from another table to enter static data
Adding Other Types of Layout Objects
- Adding tab controls to organize fields
- Creating popover buttons
- Adding button bars
Formatting Layouts with Themes and Styles
- Overview of using themes and styles
- Applying themes
- Applying, modifying and saving styles
- Saving new themes
Organization
- Managing layouts in file folders and creating sub-menus
- Hiding layouts
Managing Security Settings
- Overview of security settings
- Setting up an administrator account
- Setting up groups
- Adding users
- Managing different levels of security
Extracting Information
- Extracting user information and entering it into a field
- Extracting summary information using formulas
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 2018 Avantix Learning Inc.
Copyright 2025 Avantix® Learning
Custom Training
Register now for a public scheduled course or contact us to discuss a custom training solution.
Related courses
FileMaker Pro: Introduction to Scripting
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Introduction to Visual Basic for Applications (VBA)
You may like
How to Make Text Appear on Click in PowerPoint
You can make text appear on click in PowerPoint using entrance animations. The most common entrance animations are appear, fade, wipe and fly in. During a slide show, presenters can make text appear by line, bullet point, paragraph, word or character. In this article, we will focus on using animations to make text appear on click so you will need to run a slide show and then click anywhere on the slide to make the text appear. You can also press the right arrow or spacebar to make text appear during a slide show. Animations are typically added to placeholders or text boxes in Normal View but can be applied in Slide Master View.
How to Flip an Image in PowerPoint (2 Easy Ways)
You can easily flip an image in PowerPoint using the Ribbon or by dragging a sizing handle. Images can be flipped horizontally or vertically on a slide.
How to Recolor a Picture in PowerPoint
You can recolor a picture in PowerPoint in several ways. The recolor options in the Ribbon and in the Format Picture task pane allow you to recolor a picture but, depending on your version of PowerPoint, the colors available may only work with the current color theme and may also blend colors from the original picture which is problematic. An alternative is to create a shape, fill it with a color, change its transparency and overlay the shape on top of the picture. You would typically make the image grayscale first if you use this strategy.
How to Add Background Music to Play on All Slides in PowerPoint
You can add background music to play on all slides in a PowerPoint presentation. The music file can be stored on your PC or in a shared drive. Background music will play when you run a slide show from the slide where you inserted the music file. Since audio files are copied into PowerPoint presentations by default, these media files will increase file size and may need to be compressed. In order to play music files, your computer must be equipped with a sound card and speakers and be sure to set and test the volume.
You may also like
How to Insert or Type I with an Accent Mark in Word (Í, í, Ì, ì, Î, î, Ï, or ï)
You can insert or type i with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter i can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in Word in upper or lower case: grave (Ì or ì), acute (Í or í), circumflex (Î or î) and umlaut (Ï or ï).
How to Insert or Type A with an Accent Mark in Google Docs (À, Á, Â, Ä, à, á, â, or ä) – 6 Ways
You can insert or type a with an accent mark in Google Docs in several ways. You can use built-in tools, online tools, add-ons or keyboard shortcuts (including Alt code shortcuts). The following are common accented characters that you can insert or type in Google Docs in upper or lower case: grave (À or à), acute (Á or á), circumflex (Â or â) and umlaut (Ä or ä).
How to Insert or Type A with an Accent Mark in Word (À, Á, Â, Ä, à, á, â, or ä)
You can insert or type a with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter a can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in Word in upper or lower case: grave (À or à), acute (Á or á), circumflex (Â or â) and umlaut (Ä or ä).
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.