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: August 19, 2021 | View 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.
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
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
You may like
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.
How to Lock the Position of a Slicer in Excel
Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.
How to Expand the Formula Bar in Excel (2 Ways)
In Microsoft Excel, when you enter data or a formula, it appears in the Formula Bar. If you are writing longer formulas, it can be helpful to expand the Formula Bar.
How to Fill Blank Cells in Excel (with Zeros, Dashes or Other Values)
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 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
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.
You may also like
How to Crop an Image into a Circle in Google Slides
You can achieve some interesting effects by cropping an image into a shape in Google Slides. However, if you want to crop an image into a circle, you’ll need to use a few tricks.
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.
7 Microsoft Project Navigation and Selection Shortcuts in Task Lists
If you are working in Gantt Chart view, you can use these keyboard shortcuts to quickly move and select in your task list.
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.