FileMaker Pro Training
In 2 days, learn to create and use a Claris FileMaker Pro database: fields, layouts, data entry, finds, value lists, import and export, printing and reports.
Claris FileMaker Pro (formerly FileMaker Pro) lets you build custom database applications to manage contacts, inventory, projects or registrations without being a programmer. In 2 days, you learn how a database is organized, how to create a file and its fields, and how to work efficiently in FileMaker’s four modes: Browse, Find, Layout and Preview.
You then design layouts, use value lists, find and sort records, import and export data, format fields and produce reports with summaries and statistics. Each topic is followed by a hands-on exercise on a sample database you build during the course.
Updated on
The FileMaker Pro Training course at a glance
- Length
- 2 days
- Schedule
- 9:00 a.m. to 4:30 p.m.
- Format
- Live virtual class or in person in Montreal and Quebec City
- Level
- Beginner
- Audience
- Administrative staff, coordinators, managers and small-business owners who use or want to create a FileMaker database, and anyone who needs to maintain an existing FileMaker solution.
- Software
- Claris FileMaker Pro (recent version), on macOS or Windows
- Price
- $1,101 per participant, or $935 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and FileMaker Pro Training: key facts
- Since 2016Doussou Formation has been delivering professional training in Quebec
- 300+specialized courses in our catalogue
- 97 %satisfaction according to client evaluations
- RAP · CPMTAccredited supplier and recognized training organization
Upcoming FileMaker Pro Training sessions
FileMaker Pro Training course outline
Introduction to FileMaker Pro
- What a database is: tables, fields, records
- Overview of Claris FileMaker Pro and its uses
Overview of FileMaker Pro features
- Creating a new file
- Understanding the environment: toolbars, status area, menus
Creating a file
- Creating fields
- Available field types: text, number, date, time, timestamp, container, calculation, summary
- Editing fields and field options (auto-enter, validation)
Work modes
- Browse, Find, Layout and Preview modes
- Switching between modes and choosing the right one
Browse mode
- Creating, duplicating and deleting records
- Entering and editing data
- Using indexes and value lists
- Sorting records
Layout mode
- Creating and modifying layouts
- Using predefined layout types (form, list, table, report)
- Placing fields, labels, buttons and objects
Find mode
- Creating and modifying find requests
- Global and specific searches, find operators
- Saving finds for later use
Preview and printing
- Print preview
- Printing a data sheet
- Printing the database structure
- Saving as PDF
Working with other software
- Importing and exporting data (for example with Excel)
- Saving and backing up a database
Formatting fields and layouts
- Date, time, number and text formats
- Formatting and deleting a layout
Creating reports
- Building reports with the wizard
- Groupings, sub-summaries and totals
- Generating statistics
Prices and practical information
Preferred rate
$935 / participant
Public bodies and non-profits · plus taxes
Standard price
$1,101 / participant
Businesses and individuals · plus taxes
Practical information
- Length: 2 days
- Schedule: 9:00 a.m. to 4:30 p.m.
- Format: Live virtual class or in person in Montreal and Quebec City
- Payment: online (PayPal or card) when registering, or by invoice for organizations
- Funding: Doussou Formation is a training organization accredited by the CPMT. For Quebec employers subject to the Act to promote workforce skills development (payroll over $2M), this course can count toward their 1% training obligation.
- Equipment: A computer with Claris FileMaker Pro installed (a free trial version is available from Claris). Online: a computer with a good Internet connection, ideally with two screens.
Corporate FileMaker Pro Training training
Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.
Participant reviews
97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials
Frequently asked questions about the FileMaker Pro Training course
Do I need any database experience?
No. The course starts from the beginning: what a database, a table, a field and a record are, and how FileMaker organizes them.
Is FileMaker the same as Claris FileMaker?
Yes. The software is now sold under the Claris brand (Claris FileMaker Pro). The course uses the current interface and names.
Does it work on Mac and Windows?
Yes. FileMaker Pro runs on macOS and Windows, and files can be shared between the two. The course works the same way on both systems.
Can we work on our own database?
In a private group, the exercises can be based on your existing FileMaker file or on a case inspired by your organization.
What should I take next?
To learn the SQL language used by most other database systems, take SQL Training for SQL Server (1 day) or SQL Training: Mastering SQL Queries (2 days).
Why take this FileMaker Pro Training course
Objectives: what you will be able to do
- explain what a database is and how FileMaker Pro organizes files, tables, fields and records;
- create a new file and define fields of the right type;
- switch between Browse, Find, Layout and Preview modes and know when to use each one;
- enter, edit and delete records, using value lists to speed up and control data entry;
- create and modify layouts and format date, time, number and text fields;
- find, sort and print records, and save finds you use often;
- import and export data, for example from and to Excel;
- build reports with groupings, summaries and statistics.
Prerequisites
Be comfortable using a computer (Mac or Windows). No prior knowledge of databases is required.
What is included
- Course materials and exercise files for each participant
- Certificate of attendance
- Optional personalized coaching after the course
- In public in-person sessions:
- Tea and coffee
- Lunch at a nearby restaurant
- Parking (in some cities)
- Wi-Fi access
Concrete result
You leave with a working FileMaker database that you created yourself, with fields, layouts, value lists, saved finds and reports, along with the course material and the exercise files.