Training for the Design, Publishing, Printing,
and Web Authoring Industries
414 258 1646

MacTraining Enterprises' FileMaker Pro

This is a three day session

We all use databases; who doesn't have an address book? FileMaker Pro lets us take all those important lists we try to maintain, and computerize them. Not only are they easier to maintain in electronic form, they are much more versatile. Eliminate one source of clutter and see how efficient you can be!

This three day class will cover the use of FileMaker Pro through the entire process of planning, developing and using a flat file and relational database system.

Topics include creating a database from scratch, data entry, importing records, creating different report formats including mailing labels, finding a specific set of records, sorting the data, and using the lookup feature. Additional topics include repeating fields, scripting basics, and creating summary reports.
We'll learn various data entry options, including importing records, creating custom and specialized lists; create reports that summarize just the information you need; define relationships between multiple files and design a relational database system; key fields; learn the three types of relationships and when to use them, and create a link file to resolve a many to many relationship, and more....

The relational database system section of the class builds on the techniques above and includes understanding key fields and how they work in FileMaker, lookups (a review), additional reporting considerations, summary fields and subsummary reports, and the development of a simple customer invoicing system to ensure understanding of relational database systems.
Converting files from a flat file into a relational system, more indepth summary reports, and some specialized calculations will be covered during the third day as well as additional calculations, use of global fields, and nested sub-summaries....

Each student in the two day session receives a workbook covering the topics outlined below.

Top of page

I. Part One - Database Basics
    A. Introduction
       1. Database terminology
       2. Key fields
       3. Modes and commands
       4. Planning the database solution
    B. Overview of FileMaker Pro
        1. Browse
        2. Entering records
        3. Viewing layouts
    C. Creating a flat file database
         1. Defining fields
         2. Adding records
         3. Importing records
         4. Creating new layouts
         5. Finds and sorts
         6. Simple scripts
         7. Buttons
    D. Connecting flat files
         1. Defining lookups
         2. Calculations
     E. Summarizing data
         1. Grand summaries
         2. Sub-summaries

Top of page

II. Part Two - Relational Databases
     A. Introduction to relational databases
         1. Review of key fields
         2. Review of lookups
         3. Lookup vs. relational exercise
     B. Types of relationships
         1. One to one
         2. One to many
         3. Many to many
     C. Creating relationships
         1. Adding related fields to the layout
         2. Adding fields to a portal
     D. Planning your database - Entity relationship model
         1. Entities
         2. Relationships
         3. Identify key and match fields
         4. Final model
     E. Completing the Design
         1. Creating the files
         2. Defining the relationships
         3. Using a link file
         4. Creating a report from a relationship
         5. Creating value lists from related files
         6. Fine tuning the design

Participants attending the three day session will receive the above materials, and additional references which we use to delve further into FileMaker's capabilities.

Pricing:

Three day hands-on class: $845 per person; 3-6 attending the same class: 25% discount.

Two day Essentials hands-on class: $645 per person; 3-6 attending the same class: 25% discount.

Call (414) 258-1646 today or email registration@mactraining.com; class limited to 6 students.
Prerequisite: You need a working knowledge of your computer and it's operating system, including use of the mouse, standard menus, and commands; as well as how to open, save, and close files.

Top of page

TSS/MTE is a member of the Apple Consultants Network, an Authorized Training Center for Quark, Inc. and a training center for FileMaker, Microsoft and Adobe products, a member of the Printing Industries of Wisconsin and the West Suberban Chamber of Commerce; TSS is an Apple Value Added Reseller and Network Specialist.

© MacTraining Enterprises (414) 258-1646