FileMaker Training Series Modules

About the FileMaker Training Series at San José State University
Below are descriptions of the individual modules offered in the FileMaker Training Series:
  1. Using FileMaker Pro - Approach FileMaker Pro 11 from the perspective of users: learn techniques for working with FileMaker data, performing Quick Finds, saving Find requests, printing and exporting, setting up recurring imports, and accessing features for working with email, Adobe® PDF, and Microsoft® Excel documents.

    Module Overview
    Module 1 introduces you to the fundamentals of the FileMaker® Pro database application. Understanding the basics of working with data in FileMaker Pro is the first step to full-scale development. In this module, you will be guided through the FileMaker Pro application environment. You will be introduced to all of the menu commands and you will learn how to manipulate data, manage records, find and sort records, print, save data in other file formats, and import and export data.

    Objectives
    This module serves as an introduction to making use of the functionality available in FileMaker Pro. Upon
    completion of this lesson you will be able to:
    • Open, create, and close a file
    • Understand and operate the menu commands
    • Create, edit, and delete records
    • Perform basic and advanced finds, save find requests, and sort data
    • Print and preview data
    • Save data in Excel and PDF formats
    • Understand how to use FileMaker Pro in conjunction with other applications to import and export data
    • Set up recurring imports

    Contents at a Glance
    1.1 Moving Around & Viewing Data
    1.2 Working with Data
    1.3 Finding Data
    1.4 Printing & Previewing Data
    1.5 Importing & Exporting data

    About the FileMaker Training Series at San José State University


  2. Working with Fields - Learn practical skills required to define FileMaker Pro 11 data tables and fields. This module explores data types and options for auto-entry, validation, and field storage. Discover how to manage images and other objects in container fields and work with the Database Design Report in FileMaker Pro Advanced.

    Module Overview

    The purpose of this module is for you to become comfortable creating fields and working with various field options. FileMaker® Pro Software supports several different data types, including text, number, date, time, and timestamp data. You can specify many options for automatically entering data into a field when it is created and/or modified. Setting up field validation and storage options provides an additional layer of control over the data that can be entered into your system. In the first four lessons of this module, you will learn how to define fields and set these types of options.

    Lesson 2.5 focuses on a special type of field in FileMaker Pro called a container field, which can contain any binary data, such as an image, movie, or file. Finally, in Lesson 2.6, you will learn how to create a Database Design Report, which is a valuable resource for investigating how and where fields and other objects are used in a database.

    Objectives
    When you have finished this module, you will:
    • Be familiar with the different field types available in FileMaker Pro
    • Be able to define fields using both the Manage Database dialog and Table View
    • Know how to specify auto-entry and validation options for a field
    • Understand the importance of indexing
    • Be able to insert and export files from container fields
    • Know how and why to run a Database Design Report

    Contents at a Glance

    2.1 Creating and Using Fields

    2.2 Auto-Entry Options

    2.3 Field Validation

    2.4 Field Storage and Indexing

    2.5 Container Fields

    2.6 Documenting Database Schemas


    About the FileMaker Training Series at San José State University


  3. Data Modeling - Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. This module also covers lessons in building layouts using related data fields and portals.

    Module Overview

    FileMaker® Pro can be viewed as both a rapid application development (RAD) tool and a relational database management (RDBM) tool. In order to create effective FileMaker Pro solutions, you will need to master skills related to both aspects of FileMaker Pro. Learning how to write effective calculations and scripts (covered in other modules) is an important part of mastering the RAD capabilities of FileMaker Pro; learning which data tables to create and how to link them together via relationships is a key to mastering its relational database capabilities. The latter skill is often referred to as "data modeling."

    Your FileMaker Pro solutions are intended to address real-world problems. Therefore, you will need to

    translate aspects of the real world into the form and language of a relational database. Suppose you want to build a solution that tracks arboretum members, their personal interests and hobbies, their contact information, and their history of donations. How many FileMaker Pro tables should you create toward this end? Which fields go in which tables? How should they be linked together? The skills you will learn in this module will help you answer these questions with informed decisions.

    This module begins by introducing some of the basic concepts that underlie data modeling. It will delve into such concepts as entities, attributes, and relationships. The second half of the module will show you how to apply these concepts to get effective and useful work done in FileMaker Pro.

    This module is unusual in that some of its lessons involve pencil and paper, or marker and whiteboard, rather than FileMaker Pro.

    Objectives

    When you have finished this module, you will be able to:

    • Break a real-world scenario into a set of entities and their attributes

    • Identify cases where one-to-many or many-to-many relationships are appropriate

    • Create an entity-relationship diagram (ERD)

    • Create relationships between FileMaker Pro tables

    • Understand relationship options

    • View and manage related FileMaker Pro data via a portal

    • Create complex relationships for filtering views of related data


    Contents at a Glance

    3.1 Identifying Entities and Attributes

    3.2 Identifying Relationships

    3.3 Creating One-to-Many Relationships with Keys

    3.4 Working with Many-to-Many Relationships

    3.5 Creating an Entity-Relationship Diagram (ERD)

    3.6 Creating Relationships in FileMaker Pro

    3.7 Working with Complex Relationships


  4. About the FileMaker Training Series at San José State University

  5. Working with Layouts - Discover tools and techniques for creating layouts in FileMaker Pro 11, including the new Inspector tool palette, conditional formatting, auto-resize, Web Viewers, portals, and tab controls. Learn how to organize layouts into groups and how to set Script Trigger options. Understand how to create and use static, dynamic, and relational value lists.


    Module Overview

    FileMaker® Pro developers spend a significant amount of time working with layouts, because layouts are the primary way of presenting and organizing data in FileMaker Pro. Layouts serve both as user interfaces and as areas for design and development. In this module, you will learn how to work efficiently and effectively with layouts, an essential skill for any developer.

    Layouts come in various shapes and forms and can be rather simple or extremely detailed, all depending on the needs of the particular system and the aesthetic sense and design skills of their creator. The lessons in this module explore various types of layout objects and the tools and methods for controlling them. In FileMaker Pro 11, many of these have been reorganized into a centralized object management tool called the Inspector. You will learn how to make user interfaces more intuitive and better organized using tooltips and tab control objects and by setting logical tab orders. You will also learn about auto-resizing of layout objects and conditional formatting, both of which can significantly enhance users’ experience of your database. 


    Objectives

    When you have finished this module, you will:

    • Know how to create and organize layouts using the Layout Setup and Manage Layout dialogs

    • Be adept at adding, selecting, modifying, and formatting layout objects 

    • Know how to change the control style for a field and create static, dynamic, and relational value lists 

    • Be comfortable working with tab controls, portals, and web viewers

    • Be able to set auto-resize options for layout object

    • Understand how to use conditional formatting to alter the appearance of an object under specified conditions

    • Know how to set script trigger options for layouts and objects

    Contents at a Glance

    4.1 Managing and Organizing Layouts

    4.2 Working with Layout Objects

    4.3 Field Control Style and Value Lists

    4.4 Special Layout Objects

    4.5 Advanced Object Formatting


    FREE: Complete self-paced "Working with Layouts" module


  6. About the FileMaker Training Series at San José State University

  7. Calculation Functions - Learn how functions work in the calculation engine in FileMaker Pro 11 and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions.

    Module Overview

    FileMaker® Pro developers use calculation functions on a daily basis for many tasks, including defining calculation fields, setting up field auto-entry and validation options, creating tooltips, filtering portals, displaying conditional formatting, and writing scripts. Because calculation functions are used so pervasively throughout FileMaker Pro, mastering calculations is one of the crucial steps to becoming a proficient developer.

    While there are more than 200 calculation functions available within FileMaker Pro, the typical developer works with a subset of 30-50 of them on a regular basis. In this module, you will learn about this core of useful and practical functions. They are presented by type (number, text, date, etc.) to make them easier to learn and remember.

    In addition to presenting the syntax and common uses of various functions, the lessons in this module each focus on a different area in FileMaker Pro in which you encounter calculation functions. Lesson 5.3, for instance, focuses on using functions in conjunction with field options for validating and auto-entering data, while Lesson 5.7 showcases using calculations in tooltips. The only significant contexts in which calculations are used that are not covered in this module are scripting and record-level security settings; these are subjects covered in Modules 6 and 8, respectively, so you will have an opportunity to practice using functions in those contexts later.


    Objectives

    When you have finished this module, you will:

    • Be familiar with the most common and useful calculation functions

    • Be able to create calculation fields

    • Know how to use calculations for field auto-entry and validation

    • Have experience using calculation functions in a variety of practical contexts

    • Understand how to use custom functions and why they are useful


    Contents at a Glance

    5.1 Working With Calculations

    5.2 Number Functions

    5.3 Text Functions

    5.4 Date and Time Functions

    5.5 Logical Functions

    5.6 Text Formatting Functions

    5.7 Aggregate Functions

    5.8 Custom Functions


    About the FileMaker Training Series at San José State University

  8. Scripts - Explore the Script Trigger features of FileMaker Pro 11, as well as best practices for writing scripts. Learn how to build navigation and window controls, and study logical branching and looping routines.

    Module Overview

    One of the most important and powerful tools in FileMaker® Pro is the Manage Scripts feature, which allows you to create scripted routines that can then be triggered in a variety of ways. Scripts can serve a wide variety of purposes, including automating everything from simple navigation tasks to complex reporting and workflow needs.

    Despite their variety of purposes, there are common design patterns—sequences or arrangements of script steps—that serve as the building blocks for script after script. Examples of these design patterns include interacting with the user, finding data, error trapping, navigating to related records, and looping over a set of records. This module approaches script writing from the standpoint of design patterns. By focusing on the common patterns, you will learn the building blocks necessary for creating scripts in your own database solutions.

    Before working through this module, you should be familiar with the concepts covered in the previous modules in this training series. As you will soon discover, scripting relies heavily on calculation formulas. Similarly, for certain sections in this module, you will need to be familiar with topics such as the Relationships Graph, portals, tab controls, and other concepts covered in previous modules.

    Objectives

    When you have finished this module, you will know how to:

    • Create scripts that interact with users, perform finds, and manipulate data

    • Attach scripts to buttons

    • Set up layout and object level script triggers

    • Use the Script Debugger and Data Viewer to troubleshoot scripts

    • Add error trapping routines to scripts

    • Use script parameters, script results, and script variables

    • Create scripted routines for generating related records

    • Use loops to perform iterative tasks

    Contents at a Glance

    6.1 Working with Scripts

    6.2 Script Triggers

    6.3 Interacting with the User

    6.4 Using Scripts to Find Data

    6.5 Navigation Techniques and Script Context

    6.6 Window Management

    6.7 Looping Techniques


    About the FileMaker Training Series at San José State University

  9. Reporting - Practice creating reports in FileMaker Pro 11 using a variety of techniques. Explore sub-summary reports that group information by break fields. Work with the new FileMaker Charts feature of FileMaker Pro 11. Learn how to build a cross-tab report (with data-driven columns) and an HTML report that is displayed via the Web Viewer object.

    Module Overview

    One of the key features of FileMaker® Pro is its powerful reporting capabilities. As a developer, you can use these capabilities to create reports that allow users to better understand and analyze their data. An effective report can be anything from a simple list view to a basic subsummary or even a chart or complex HTML report. This module will guide you through the process of building several types of reports in FileMaker Pro and demonstrate various uses of each type.

    For most developers, the most frequently used reporting tool is a basic subsummary report, covered in Lesson 7.1. While these reports can be valuable and are quick to develop, there are also circumstances in which it is useful to build reports that are more advanced. Lesson 7.2 explains several such advanced techniques, including how to create reports that contain no body part, ranking reports, and subsummary reports with more than one break field.

    Lesson 7.3 explores the new charting feature of FileMaker Pro 11 in depth. Lessons 7.4 and 7.5 address two other methods to create reports in FileMaker Pro. First, you will learn how to create a crosstab report, which is a more intuitive format than a subsummary report for analyzing certain types of data. You will also learn how to create an HTML report using the web viewer capability in FileMaker Pro; this technique is useful when a more flexible report is needed.


    Objectives

    When you have finished this module, you will:

    • Be able to create a basic subsummary report
    • 
    Be able to create a bodyless subsummary report, a ranked subsummary report, and a subsummary report that summarizes by multiple variables

    • Understand how to create various types of charts, including summary charts and charts that use delimited lists of data

    • Be able to create a crosstab report and understand the advantages and disadvantages of subsummary and crosstab reporting

    • Understand the uses of the web viewer in the context of reporting


    Contents at a Glance

    7.1 Basic Subsummary Reports

    7.2 Advanced Subsummary Reports

    7.3 Working with Charts

    7.4 Crosstab Reports

    7.5 Reporting Using Web Viewers

    FREEComplete self-paced "Reporting" module

  10. About the FileMaker Training Series at San José State University

  11. Security - Study the account-based security features of FileMaker Pro 11, 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.

    Module Overview

    Implementing a proper security model often requires going beyond controlling whether or not someone can

    log into a database. FileMaker® Pro includes a robust set of features for controlling which users have access

    to what information and what they can do with that information via the accounts and privileges settings.

    This module will demonstrate how to isolate legitimate users from sensitive operations or information within

    a database, how to associate privileges with authenticated accounts, and how to control specific features

    within a database based on a given user’s assigned privileges.


    Database administration and server security is covered in Module 10 – FileMaker Server.


    Objectives

    When you have finished this module, you will:

    • Be familiar with the security controls in FileMaker Pro

    • Know how to create and manage user accounts

    • Grasp how to control access within a group of files

    • Understand how to associate privilege sets with accounts

    • Know how to manage privilege settings

    • Be able to control record deletion

    • Know how to control record level access


    Contents at a Glance

    8.1 Creating Accounts & Granting Access

    8.2 Setting Up Privilege Sets

    8.3 Restricted Conditional Deletes

    8.4 Conditional Record Access

    FREEComplete self-paced "Security" module

  12. About the FileMaker Training Series at San José State University

  13. Intermediate & Advanced Techniques - Explore how to implement custom menu sets in FileMaker Pro 11. Learn advanced techniques with portals, including portal sorting and dynamically controlling the contents with a portal with a filter. Use advanced scripting techniques and Script Triggers to implement an audit trail.

    Module Overview

    The techniques presented in the following lessons are somewhat larger in breadth than in prior modules and build upon other materials presented throughout this courseware. The lessons in this module also present specific techniques that FileMaker® Pro developers often face in real-world situations. It is important to note that the authors of this material do not offer these lessons as examples of the only or best ways to create certain functionality in FileMaker Pro databases. These lessons attempt to conform to what would be considered reasonable best practices but, in the end, the lessons in this module are presented for instructional purposes.

    Objectives

    When you have finished this module, you will:

    • Know how to implement custom menus in a FileMaker Pro solution

    • Be able to control the contents of a portal dynamically 

    • Understand two techniques for sorting records within a portal

    • Understand a technique for creating a “filtered sub-summary list”

    • Be familiar with more advanced scripting techniques and the use of script triggers


    Contents at a Glance

    9.1 Custom Menus

    9.2 Filtered Portals

    9.3 Dynamic Portal Sorting

    9.4 Filtered Sub-summary List

    9.5 Audit trail


    About the FileMaker Training Series at San José State University


  14. FileMaker Server - Learn the best practices for setting up and maintaining FileMaker Server 11 and FileMaker Server 11 Advanced. Understand how and why to use server-side scripts. Review hardware and networking requirements, learn proper backup routines, and be trained in configuration processes.

    Module Overview

    FileMaker® Server software is the linchpin in deploying FileMaker Pro solutions to many users. Using FileMaker Server, a FileMaker solution can be shared among tens or hundreds of FileMaker Pro clients at once, all of them simultaneously accessing and, depending on their allotted privileges, modifying data in the system.

    Without FileMaker Server, the alternative is to create standalone solutions that run in isolation on the desktops of your users, who never share data with one another. You may also share files using the sharing capability built into the FileMaker Pro or Pro Advanced client itself, but doing this limits sharing to only 9 additional users.

    This module illustrates why it is vital to use FileMaker Server if you plan to deploy a multi-user FileMaker Pro solution for significant production use. FileMaker Server provides a stable, scalable platform for multi-user solutions. The added protection of integrity checks and regular backups, assuming you configure your installation to manage such things, assures data integrity.

    To follow the examples and exercises in this module, you will need an installed copy of FileMaker Server Advanced. If you do not already have a copy installed, you can visit http://www.filemaker.com/products/filemaker-server/index.html and follow the links at the right to download a 30-day trial of the software.

    Objectives

    When you have finished this module, you will be able to:

    • Install and configure FileMaker Server and FileMaker Server Advanced

    • Upload databases to FileMaker Server

    • Back up and maintain your databases using FileMaker Server backup tools

    • Integrate FileMaker Server backups with organizational backup strategies

    • Administer FileMaker Server from the command line

    • Trigger FileMaker Pro and operating system scripts from FileMaker Server 


    Contents at a Glance

    10.1 Installing FileMaker Server

    10.2 Configuring FileMaker Server

    10.3 Backing Up FileMaker Pro Databases

    10.4 Running Scripts with FileMaker Server

    About the FileMaker Training Series at San José State University


  15. Connectivity - Learn how to integrate FileMaker 11 with SQL systems, both through ODBC connections and with the External SQL Data Source capabilities. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.

    Module Overview

    One of the great strengths of FileMaker® Pro software is its ability to share data with other applications. Not only can FileMaker Pro make its own data available, via technologies such as the Web or Open Database Connectivity (ODBC), it can also access data stored in other systems as well.

    This module covers some of the ways in which FileMaker Pro can share data using ODBC, a database interchange technology. Using ODBC, you can import data from sources, such as SQL databases, into your FileMaker Pro solution. Likewise, you can make data from your FileMaker Pro solution available to other programs that use ODBC, whether they are spreadsheets or programs written in languages like Java or Visual Basic. Through the External SQL Sources (ESS) feature in FileMaker Pro, you can access certain kinds of SQL-based data directly from within a FileMaker Pro system.


    Setup Notes

    To follow all of the examples and exercises in this module, you will need to download, install, and configure Microsoft SQL Server 2008 Express Edition with Advanced Services. You will also need to use Microsoft Query in conjunction with Microsoft Excel 2007. Please refer to the Appendix for Module 11 for guided setup instructions.

    All databases used in this module may be opened with an account name of Admin and a blank password.


    Objectives

    When you have finished this module, you will be able to:

    • Understand the different ways of getting data into and out of FileMaker Pro using ODBC technologies

    • Configure Data Source Names (DSNs) to connect to specific ODBC data sources

    • Use ODBC Import feature in FileMaker Pro to populate a FileMaker Pro database with records from an ODBC data source

    • Use ODBC Import feature in FileMaker Pro to perform a one-way synchronization of data from an ODBC data source to FileMaker Pro

    • Understand and use the External SQL Sources (ESS) features in FileMaker Pro 10

    • Use the ESS feature to integrate SQL data sources directly with your FileMaker Pro solutions

    • Use a FileMaker Pro solution as an ODBC data source• 


    Contents at a Glance

    11.1 FileMaker Pro Connectivity Options

    11.2 Configuring a DSN For Use by FileMaker Pro

    11.3 Importing Records from an ODBC Data Source

    11.4 Working with External SQL Sources

    11.5 Using FileMaker Pro as an ODBC Data Source  

    About the FileMaker Training Series at San José State University


  16. Web Publishing - Understand the capabilities of both Instant Web Publishing (IWP) and Custom Web Publishing in FileMaker Pro 11 and learn how to develop solutions to publish via the web. Review the PHP Site Assistant and gain hands-on experience with IWP.

    Module Overview

    With FileMaker® Server, it is possible to make a FileMaker Pro solution available to up to 250 FileMaker Pro

    users on either a local area network (LAN) or a wide area network (WAN). Using FileMaker Server Advanced,

    a sufficiently powerful server, and a well-constructed database, you can make your solution available to as

    many FileMaker Pro users as your hardware can handle. Suppose, however, that you need to make your

    FileMaker Pro data more widely available, perhaps to many hundreds of people spread across a large

    geographic area. These users may have lower-bandwidth connections or they may not wish to acquire or

    install the FileMaker Pro client software. FileMaker Server’s web publishing technologies offer a solution to

    this problem.

    The web technologies in FileMaker Server allow you to give your solutions a very broad reach—potentially

    as wide as the web itself. However, there are some tradeoffs to be aware of which this module will discuss

    in detail. For instance, web-based applications have neither the rich user interface nor the seamless ready

    connectivity of a native networked FileMaker Pro solution without considerable additional work from

    the developer. Under circumstances in which you need to make some subset of a solution’s functionality

    available to a very wide audience, the web technologies in FileMaker Server may be the right answer.


    Web technologies allow users to interact with a FileMaker Pro solution using only a web browser. In some

    cases, such as with Instant Web Publishing, the browser may display a fairly faithful rendering of a FileMaker

    Pro solution’s look and feel and require little additional development effort. With Custom Web Publishing,

    screen fidelity and automated functionality are traded for increased power and flexibility. The web

    publishing option you choose will be guided by your project aims.


    All of the files used in this module may be opened using an account name of
    Admin and a blank password.


    Objectives

    When you have finished this module, you will be able to:

    • Understand the different web publishing options available with FileMaker Pro

    • Configure FileMaker Pro and FileMaker Server Advanced to publish data using Instant Web Publishing

    • Create web-friendly layouts and scripts for use with Instant Web Publishing

    • Create a custom home page for Instant Web Publishing

    • Use the PHP Site Assistant to generate a variety of web sites that publish FileMaker Pro data by using

    Custom Web Publishing with PHP


    Contents at a Glance

    12.1 FileMaker Web Publishing

    12.2 Configuring FileMaker Pro and FileMaker Server Advanced for Instant Web Publishing

    12.3 Designing for Instant Web Publishing

    12.4 Scripting for Instant Web Publishing

    12.5 Creating a Custom Home Page

    12.6 Using the PHP Site Assistant

About the FileMaker Training Series at San José State University
Comments