Intermediate FileMaker Pro
Two days of instructor-led, hands-on training
Focus
This class is for those already familiar with FileMaker Pro and seeking to expand their knowledge to develop more sophisticated solutions for their business. You’ll explore detailed handouts (useful later for reference), participate in active discussions and try out what you learn on the computer.
You’ll find out how to design your database to make it easy for other folks to use, improving your layouts, creating portals to bring in data from related fields and running scripts and calculations. And you will get to ask about your specific interests.
This class spans days two and three of our four-day Core Curriculum. Each course can be taken separately, or together in one week.
Benefits
By the end of this class, you’ll be able to:
- Work with multiple tables in a database, creating relationships between them
- Import and export data to and from FileMaker Pro
- Enter data accurately and completely
- Perform calculations with numbers, dates, and text
- Create good-looking layouts quickly and efficiently, with advanced layout objects such as tab controls and web viewers
- Create pop-up lists, pop-up menus, radio buttons, and check boxes, to enable faster and more accurate data entry
- Create reports with subtotals and grand totals
- Write scripts that automate your database
Who should take this class
You should take this class if you have already been using FileMaker Pro (or have just completed our Introduction to FileMaker Pro course), and you now want to create more sophisticated solutions, possibly for other people.
With this workshop, you can make data entry easier and more accurate; improve your interface; understand and use relationships to display relevant information from other databases.
Agenda
- Using multiple tables: storing different kinds of records in the same file
- Importing and exporting
- Automating data entry: auto-enter options and updating multiple records
- Calculations
- Advanced layout techniques: formatting, tab controls, web viewers, and anchors
- Value lists: pop-up lists and menus, radio buttons and check boxes
- Reporting: generating reports with subtotals and grand totals
- Scripting and buttons: what you can automate, and how
- Introduction to relationships: what they are and how they help
- Viewing related data: displaying related fields and creating portals
Pricing
Tuition for our two-day Intermediate FileMaker Pro class is just $595. Take it as part of our complete four-day Core Curriculum package Introduction to FileMaker Pro, Intermediate, and Scripting with FileMaker Pro) for $995, a savings of $190. Or register for both Intro and Intermediate for just $750 and save $140. Register online now.
