Introduction To FileMaker Pro (1 day)
Who Should Take This Class?
If you’re new to FileMaker Pro, this one-day workshop is your perfect starting point. You should be familiar with Windows or Macintosh systems, using a mouse. No experience with FileMaker is necessary.
Focus and Objectives
Learn how to build a Filemaker Pro database from scratch, how to add and modify fields and layouts, sort and browse data, and generate reports.
Outcomes
By the end of this class, you will be able to design and build a simple database, including:
- Creating a new database
- Defining fields, and deciding which type is right for each kind of information
- Building layouts for reviewing, editing, and reporting
- Working with information in individual records
- Searching and finding the records you need
- Sorting groups of records for many different purposes
Intermediate FileMaker Pro (2 days)
Who Should Take This Class?
Recent graduates of Introduction to FileMaker Pro, or anyone able to start a FileMaker database from scratch. You’ll want to take this course if you are already familiar with FileMaker Pro and you want to expand your knowledge and skills to get the most out of your software. Intermediate FileMaker Pro will enable you to develop sophisticated and robust solutions for your business.
Focus and Objectives
You’ll ask questions about your specific database needs; and participate in discussions – all while learning and experimenting on your own in-class workstation. You’ll learn how to design your database to make it accessible for other users; improve your layouts; create portals to bring in data from related fields; and run scripts and calculations.
Outcomes
By the end of this class, you’ll be able to:
- Create visually appealing layouts quickly and efficiently
- Create pop-up lists, pop-up menus, radio buttons and check boxes to enable faster and more accurate data entry
- Perform calculations using numbers, dates, and text
- Create reports with sub totals and grand totals
- Write scripts that automate your database
- Create buttons that launch scripts or commands
- Define relationships and understand how they make your database more accurate and useful
- Display related fields (to supplement data on the current record)
- Create portals to link to related fields
FileMaker PRO: ADVANCED SCRIPTING (1 day)
Filemaker Scripts let you extend your database’s functionality in a way that rivals more powerful programming languages – but you don’t need to learn a programming language. Learn all about scripting in this one-day seminar.
Who Should Take This Class?
Recent graduates of Level 2 Intermediate, or equivalent experience.
Focus and Objectives
Learn how to make yor database more powerful and “smarter” with scripting.
Outcomes
By the end of this class, you’ll know how to:
- use Script Parameters & Variables to extend your scripting power
- implement dynamic filtering and sorting in portals
- make scripts multi-purpose by using Script Parameters
- use Custom Dialogs for getting input and feeding back results
- automate Emails and implement Bulk Emailing
- implement mail-merge in emails
- dynamically generate PDF attachments (such as invoices or work orders) and attach them to emails
- use the power of script triggers to improve your user experience
- loop through portals and records