mopawoo.blogg.se - Filemaker pro course

Using validation options with calculations.

Setting up auto-enter options based on a calculation.

Creating calculations using date and text functions.

Using the IF or CASE functions in calculations to provide conditional results.

Using the Replace command to replace data with a calculation.

Creating calculation fields in FileMaker using operators and functions.

Refreshments (for classes conducted in Avantix Learning classrooms)Ĭourse Topics Entering and Editing Calculations.

Related training: View all FileMaker training courses > INCLUDED IN THIS COURSE For more information including savings for custom group training, email us at contact us by phone. Prerequisite: FileMaker Pro: Introduction or equivalent knowledge and skills.Ĭustom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Students will learn to secure a database and to automate tasks using buttons and simple scripts. Throughout this course, the instructor will include numerous tips, tricks and shortcuts and each student will receive a full course manual. Students will create advanced reports using summary fields and parts and will group records in reports. Relationships will be created between fields in multiple tables to allow the display of information from related tables in layouts and by using portals. More advanced controls will be added on layouts including tabs, popovers and button bars. FileMaker's calculation capabilities will be explored through the creation of calculation fields using various useful functions including IF, Trim, and date functions. Students will learn to control data entry using validations and by auto-entering data in text, number and date fields.

Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.ĭuring this course, users will move to the next level and use some of the more advanced features in FileMaker Pro.

Software Versions: 13 | 14 | 15 | 16 (other versions on request)ĭelivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on requestĬourse Dates: December 27/28, 2018 | View scheduleĬourse Fee: $595 CDN per person + HST or BYOD (bring your own device): $545 CDN person + HST* FileMaker Pro: Intermediate FileMaker Pro Training Series | Level 2 Course Details