

#FILEMAKER PRO TRAINING HOW TO#
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. In order to create effective FileMaker Pro solutions, you will need to master skills related to both aspects of FileMaker Pro. This module also covers lessons in building layouts using related data fields and portals.įileMaker® Pro can be viewed as both a rapid application development (RAD) tool and a relational database management (RDBM) tool. Know how and why to run a Database Design Reportĭata Modeling - Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions.Be able to insert and export files from container fields.Know how to specify auto-entry and validation options for a field.Be able to define fields using both the Manage Database dialog and Table View.Be familiar with the different field types available in FileMaker Pro.When you have finished this module, you will: 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. 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.

In the first four lessons of this module, you will learn how to define fields and set these types of options. Setting up field validation and storage options provides an additional layer of control over the data that can be entered into your system. You can specify many options for automatically entering data into a field when it is created and/or modified.
#FILEMAKER PRO TRAINING SOFTWARE#
FileMaker® Pro Software supports several different data types, including text, number, date, time, and timestamp data. The purpose of this module is for you to become comfortable creating fields and working with various field options. Discover how to manage images and other objects in container fields and work with the Database Design Report in FileMaker Pro Advanced. This module explores data types and options for auto-entry, validation, and field storage. Working with Fields - Learn practical skills required to define FileMaker Pro 11 data tables and fields.

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.
#FILEMAKER PRO TRAINING SERIES#
About the FileMaker Training Series at San José State Universityīelow are descriptions of the individual modules offered in the FileMaker Training Series:
