Home > On Request Training: FileMaker Training:
FileMaker - Intermediate
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.
FileMaker Pro Training
FileMaker
Intermediate
Course Information
Platform: Windows and Macintosh
Fee: Call DPA
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. On the second day, students 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 Content
- Set up auto entry options to make data entry easier
- Create validation options to ensure accurate data entry
- Create calculation fields to add, subtract, multiply, and divide
- Use the If function to create conditional calculations
- Summarize data using summary parts and summary fields
- Create trailing grand summaries to create grand totals
- Group data within reports by creating sub-summaries above and below the grouped records
- Understand title header and title footer parts
- View part information
- Use key fields to set up relationships between databases
- Place fields from another database in a layout
- Create a “lookup” from another database file
- Use portals to display multiple related records from a related database
- Use buttons to move between layouts
- Create buttons to move to a related record in another database
- Create simple scripts to automate repetitive tasks
- Run scripts from the Script menu or using keyboard shortcuts
- Format buttons to run scripts
Calendar Dates:
On Request Only
Call DPA for more information or a quote for custom training
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Training
Course Discounts
Receive a discount off of the regular fee for this course!
Register for two or more courses and you automatically qualify for a discount of 10% off the regular fees for all courses.
Register for five or more courses at one time and the discount increases to 15% per courses
(Note: Only the 10% discount applies to Microsoft Office or FileMaker Pro training)
(PDF 55 kb)