FileMaker Pro

Course Overview

Students will learn to use many of FileMaker's more advanced features in this hands-on course. Participants will learn to control data entry by setting validation, auto-enter and indexing options for fields. Calculation fields will be created with various types of calculations including simple If statements for conditional calculations. Students will also learn to create report layouts to calculate totals with summary fields and parts. Emphasis will be placed on creating sub-summary fields to create groups in report layouts. Students will also will learn to use the relational features within Filemaker. Key fields will be created and relationships will be established between databases. Students will create portals to display multiple related records from a related database. In order to automate tasks, participants will also create buttons and simple scripts.


Course InformationRelated Training

Duration: One-Day Course
Platform: Windows and Macintosh
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Work with Calculated Fields

Automate Data Entry

Validate Data

Create Reports

Automate Tasks using Scripts and Buttons

Work with Related Tables

Application Overview: FileMaker Pro

FileMaker Pro is database software that helps individuals and workgroups manage and share information about people, projects, assets and anything else that needs to be stored in a database format. With FileMaker Pro you can create complex databases with relationships and multiple database tables.
FileMaker Pro can also access data stored in other FileMaker Pro files and external ODBC data sources, which allows you to combine data stored in your FileMaker Pro file with data from these external sources. You can work with data in SQL databases that share information through ODBC. You can also use supplemental fields in FileMaker Pro to perform calculation and summary operations on data stored in ODBC data sources.
You can use ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) to share FileMaker Pro files with ODBC- and JDBC-compliant applications, or you can access data from external data sources.
If your computer is connected to a network, you and other Windows and Mac OS FileMaker Pro users can use the same FileMaker Pro database file simultaneously.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.