FileMaker Professional Training Foundation Series III Course


Using FileMaker Pro 8

Features and Benefits of FileMaker 8

Learn how to get the most out of the new features of FileMaker 8 including when and how to use script variables and the new GetNthRecord function, and how to create, manage and install custom menus.

Developing FileMaker Pro 8 solutions

Data Modeling

Study the concepts behind relational databases and understand how they are applied in FileMaker Pro 8. Learn how to recognize data relationships, ensure data integrity, and implement multiple table solutions in FileMaker Pro 8.

Developer Skills 1

Learn practical skills required to create and maintain FileMaker Pro 8 databases. Learn how to create tables, define fields and value lists, add auto-entry and validation options to a field, and understand field storage options. This module also guides you in working efficiently with Layouts tools, as well as how to use the new Tab Control object and how to define calculation formulas using a wide variety of functions.

Developer Skills 2

As a companion to Developer Skills 1, delve into scripting techniques and working with the Relationships Graph. Learn also how to create reports and integrate them into the workflow.

Security

Study the account-based security features of FileMaker Pro 8 and learn how to implement privilege sets, tie access to database solutions to external authentication servers, control both access and authoring rights to systems, and extend security controls with scripting.

Converting Solutions to FileMaker Pro 8

Learn the benefits you'll gain from converting older solutions to FileMaker Pro 8. Understand the changes that take place during the conversion process and best practices to prepare for conversion.

Deploying FileMaker Pro 8 databases

Server and Networking Configuration

Review the best practices for setting up and maintaining FileMaker Server 8 and FileMaker Server 8 Advanced. Go through hardware and networking requirements, learn proper backup routines, and be trained in configuration processes.

Using FileMaker Pro with Citrix Presentation Server and Terminal Services

Gain the knowledge of how to address deployment issues with remote terminal technologies. Review configuration and set up processes, learn what options and variables apply, and understand the advantages of offering users virtual desktop connectivity to database systems.

FileMaker Pro 8 Advanced

Examine the tools in FileMaker Pro 8 Advanced including file optimization, script debugging, the database development report, and custom functions. Learn the new Tool tips and Custom Menus features. Study how to create a bound runtime solution, deliver a kiosk system, and customize a solution. Learn how to work with plug-ins and incorporate them into database systems.

Connectivity

Learn how to integrate FileMaker 8 with SQL systems, both as an ODBC client and host. Review configuration processes and learn how to synchronize and control data through standard ODBC/JDBC drivers and SQL queries.

Connecting FileMaker 8 to the web

Instant Web Publishing (IWP)

Study the capabilities of built-in Instant Web Publishing in FileMaker Pro 8 and learn how to develop solutions meant to be published via IWP. Review configuration processes and understand what development techniques to use for optimal results.

Custom Web Publishing

Examine XML-based publishing options in FileMaker Server 8 Advanced and learn how to build websites using FileMaker Pro 8 databases as a backend. Review the XSLT style sheets used for Custom Web Publishing and learn the basics of XML and XSLT.

Web Programming Workshop

Study how to build an XSLT-driven web application using FileMaker Pro 8 using a hands-on approach. Learn how to work with XSLT templates, write style sheets, and how to publish FileMaker Pro 8 data to the web.