Beginners FileMaker Pro 12 Training – A Practical Guide

Course Curriculum

Chapter 1: Introduction

Lecture 1: How To Get Your Working Files – Download These First

Lecture 2: 0101 Overview

Lecture 3: 0102 Getting Going With FileMaker

Lecture 4: 0103 Starting A Database From Scratch

Lecture 5: 0104 Starting With The Manage Database Dialog

Lecture 6: 0105 The Language Of FileMaker

Lecture 7: 0106 Getting Used To The Status Toolbar

Lecture 8: 0107 Setting Up FileMaker Preferences

Lecture 9: 0108 Working With Data – Creating Records

Lecture 10: 0109 Basics Of Finding And Sorting

Chapter 2: What Belongs Where?

Lecture 1: 0201 Important Database Concepts

Lecture 2: 0202 Why Relationships Matter

Lecture 3: 0203 Modes Of Operation

Lecture 4: 0204 Basic Anatomy

Lecture 5: 0205 Preliminary Data Design

Lecture 6: 0206 Creating Structure For Your Data – Part 1

Lecture 7: 0207 Creating Structure For Your Data – Part 2

Lecture 8: 0208 Building Different Views

Lecture 9: 0209 Setting Up User Navigation

Lecture 10: 0210 Basics Of Data Security

Lecture 11: 0211 Controlling File Access

Lecture 12: 0212 FileMaker Advanced Features Overview

Chapter 3: Building The Interface

Lecture 1: 0301 Layouts And Context

Lecture 2: 0302 Using Layout Tools

Lecture 3: 0303 Creating And Formatting Objects

Lecture 4: 0304 Controlling Object Size And Position

Lecture 5: 0305 Layout Parts In Action

Lecture 6: 0306 FileMaker Visual Design

Lecture 7: 0307 Helping The User With Visual Cues

Lecture 8: 0308 Setting The Tab Order

Lecture 9: 0309 Objects And Associated Actions

Chapter 4: Adding Visual Power

Lecture 1: 0401 Setting Up Buttons

Lecture 2: 0402 Tab Control Objects

Lecture 3: 0403 Portals And Their Uses

Lecture 4: 0404 The World Of Web Viewers

Lecture 5: 0405 Specifying Tooltips

Lecture 6: 0406 Conditional Formatting

Lecture 7: 0407 Autosizing Objects

Lecture 8: 0408 Basic Data Presentation

Chapter 5: The Basics Of Working With Data

Lecture 1: 0501 Aids To Data Entry

Lecture 2: 0502 Committing Or Reverting Changes

Lecture 3: 0503 Values And Lists

Lecture 4: 0504 Shortcuts And Alternate Methods

Lecture 5: 0505 Finding And Omitting

Lecture 6: 0506 Finding Matching Records

Lecture 7: 0507 Compound Searches

Lecture 8: 0508 Multi-Request Finds

Lecture 9: 0509 Constraining And Extending

Lecture 10: 0510 Sorting And Summarizing

Lecture 11: 0511 Accessing Related Data

Lecture 12: 0512 Summarizing Related Data

Lecture 13: 0513 Incorporating Charts

Lecture 14: 0514 Importing And Exporting Data

Lecture 15: 0515 Saving And Sending Data

Chapter 6: Database Design Fundamentals

Lecture 1: 0601 Tables And Table Occurrences

Lecture 2: 0602 Fields And Data Type

Lecture 3: 0603 Global Field Behaviour

Lecture 4: 0604 Setting Up Basic Calculations

Lecture 5: 0605 Coding Logic

Lecture 6: 0606 Stored And Unstored Calculations

Lecture 7: 0607 Working With The Relationships Graph

Chapter 7: Automation Options

Lecture 1: 0701 Following The Script

Lecture 2: 0702 Creating A Script

Lecture 3: 0703 Actions In Sequence

Lecture 4: 0704 Script Editing Basics

Lecture 5: 0705 Working With Named Objects

Lecture 6: 0706 Scripted Navigation

Lecture 7: 0707 Scripting Conditional Sequences

Lecture 8: 0708 Scripting With Loops

Lecture 9: 0709 Buttons And Triggers

Lecture 10: 0710 Using Script Parameters

Chapter 8: Calculation Basics

Lecture 1: 0801 The Language Of Calculations

Lecture 2: 0802 Using Calculation Functions

Lecture 3: 0803 Understanding Boolean Logic

Lecture 4: 0804 Beyond Arithmetic

Lecture 5: 0805 Working With The Calculation Dialog

Lecture 6: 0806 More About Text Literals

Lecture 7: 0807 Dynamic Data And Dependencies

Lecture 8: 0808 Compound Calculation Expressions

Chapter 9: Relationship Techniques

Lecture 1: 0901 Key Fields And Their Characteristics

Lecture 2: 0902 Primary And Foreign Keys

Lecture 3: 0903 Relationship Operators

Lecture 4: 0904 Using Join Tables

Lecture 5: 0905 Filtering Portals

Lecture 6: 0906 Sorting Related Data

Lecture 7: 0907 Allow Create Relationships

Chapter 10: Deployment Considerations

Lecture 1: 1001 Single User Systems

Lecture 2: 1002 Parallel Solutions And Synchronization

Lecture 3: 1003 Networking And Peer-To-Peer

Lecture 4: 1004 Multi-User Considerations