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 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 2022 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 Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

How to Use Cell Styles in Excel to Save Time Formatting

How to Use Cell Styles in Excel to Save Time Formatting

You can apply cell styles in Excel worksheets to quickly format cells in a consistent way and automate repetitive formatting. Excel includes several built-in styles (such as Heading 1, Heading 2 and so on) and you can modify styles before or after you apply them. If none of the built-in styles fit your needs, you can also create a new style.

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

In 2021 and 365 versions of Word, Excel and PowerPoint, you now have the ability to hide or unhide the Quick Access Toolbar. So if your Quick Access Toolbar seems to have disappeared, it may simply be hidden. In 2021, Microsoft also removed Undo and Redo / Repeat  from the Quick Access Toolbar and moved these commands to the Home tab in the Ribbon.

You may also like

4 Ways to Delete a Table in Word

4 Ways to Delete a Table in Word

You can delete a table in a Word document in 4 simple ways – using the Ribbon, using the context menu, using the Backspace key or by selecting a paragraph and a table and pressing Delete.

How to Make Columns in Word

How to Make Columns in Word

You can make columns in Word documents in a few different ways. There are two types of columns you can create – newspaper-style columns where the text flows from column to column or tables with columns and rows. You can create documents that contain two, three or more columns. In this article, we'll review how to set up newspaper-style columns. If you want to create a table, check out How to Create a Table in Word (4 Ways).

4 Ways to Create a Table in Word

4 Ways to Create a Table in Word

You can create a table in a Word document in 4 easy ways using the Ribbon. A table is a grid made up of columns and rows that intersect to form cells. You can insert text, numbers and images in a table. Once you have inserted a table, you can easily add and resize columns and rows and change table formatting.

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 (in-person in Toronto or online in virtual classroom format)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario,Canada-M5E 1W7
Next course starts
August 19, 2021
Next course ends
August 19, 2021
Description
FileMaker Pro: Introduction course in Toronto, Ontario, Canada. Instructor-led FileMaker course for beginners. Virtual classroom courses are also available for our clients in Toronto, Mississauga, London, Calgary, Edmonton, Ottawa, Vancouver, Winnipeg, Halifax and other cities in Canada and the United States.

Pin It on Pinterest