by | Released April 2013 | ISBN: 9781771370844

In this FileMaker Pro 12 training course, renowned trainer and author Ray Cologon introduces you to the basics of managing your data with the FileMaker Pro database. FileMaker 12 is a very popular cross-platform, relational database application that is known for its easy of use, and powerful, feature set.This video based tutorial is designed for the beginner, and no previous experience in database design or FileMaker is required. You will start by exploring what a relational database is, and why you should use it. Ray then takes you through the initial steps of building your interface using the FileMaker layout tools. You will learn how to work with your data - how to enter it, find it, and format it. Ray also teaches you database design fundamentals, to ensure the integrity of your data. Other topics that are covered in this video tutorial for FileMaker Pro include; automating functions, using calculations with your data, identifying and using different relationship techniques, and of course, deploying your data.Once you have completed this FileMaker Pro 12 beginners training course, you will have a clear understanding of what a relational database is and how you can create your database with FileMaker. You will understand how to create a basic interface for entering and accessing your data, and how to deploy your completed database. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Introduction
   • Overview 00:05:07
   • Getting Going With FileMaker 00:04:50
   • Starting A Database From Scratch 00:07:02
   • Starting With The Manage Database Dialog 00:03:30
   • The Language Of FileMaker 00:05:11
   • Getting Used To The Status Toolbar 00:15:16
   • Setting Up FileMaker Preferences 00:13:02
   • Working With Data - Creating Records 00:07:28
   • Basics Of Finding And Sorting 00:10:09
2. What Belongs Where?
   • Important Database Concepts 00:04:06
   • Why Relationships Matter 00:13:30
   • Modes Of Operation 00:04:57
   • Basic Anatomy 00:03:56
   • Preliminary Data Design 00:06:11
   • Creating Structure For Your Data - Part 1 00:08:25
   • Creating Structure For Your Data - Part 2 00:08:02
   • Building Different Views 00:12:16
   • Setting Up User Navigation 00:06:20
   • Basics Of Data Security 00:04:38
   • Controlling File Access 00:06:30
   • FileMaker Advanced Features Overview 00:05:36
3. Building The Interface
   • Layouts And Context 00:05:52
   • Using Layout Tools 00:08:09
   • Creating And Formatting Objects 00:05:12
   • Controlling Object Size And Position 00:02:54
   • Layout Parts In Action 00:02:16
   • FileMaker Visual Design 00:04:47
   • Helping The User With Visual Cues 00:05:02
   • Setting The Tab Order 00:03:49
   • Objects And Associated Actions 00:04:08
4. Adding Visual Power
   • Setting Up Buttons 00:03:35
   • Tab Control Objects 00:06:07
   • Portals And Their Uses 00:04:23
   • The World Of Web Viewers 00:03:53
   • Specifying Tooltips 00:02:11
   • Conditional Formatting 00:03:53
   • Autosizing Objects 00:02:25
   • Basic Data Presentation 00:07:19
5. The Basics Of Working With Data
   • Aids To Data Entry 00:05:39
   • Committing Or Reverting Changes 00:04:23
   • Values And Lists 00:04:02
   • Shortcuts And Alternate Methods 00:02:57
   • Finding And Omitting 00:05:38
   • Finding Matching Records 00:02:55
   • Compound Searches 00:02:15
   • Multi-Request Finds 00:04:28
   • Constraining And Extending 00:03:56
   • Sorting And Summarizing 00:06:24
   • Accessing Related Data 00:04:51
   • Summarizing Related Data 00:03:55
   • Incorporating Charts 00:05:12
   • Importing And Exporting Data 00:05:19
   • Saving And Sending Data 00:02:30
6. Database Design Fundamentals
   • Tables And Table Occurrences 00:06:29
   • Fields And Data Type 00:04:38
   • Global Field Behaviour 00:03:38
   • Setting Up Basic Calculations 00:08:15
   • Coding Logic 00:05:52
   • Stored And Unstored Calculations 00:05:46
   • Working With The Relationships Graph 00:09:58
7. Automation Options
   • Following The Script 00:03:40
   • Creating A Script 00:08:40
   • Actions In Sequence 00:05:41
   • Script Editing Basics 00:11:26
   • Working With Named Objects 00:07:22
   • Scripted Navigation 00:04:25
   • Scripting Conditional Sequences 00:06:53
   • Scripting With Loops 00:05:59
   • Buttons And Triggers 00:07:18
   • Using Script Parameters 00:06:11
8. Calculation Basics
   • The Language Of Calculations 00:09:27
   • Using Calculation Functions 00:15:32
   • Understanding Boolean Logic 00:05:36
   • Beyond Arithmetic 00:09:37
   • Working With The Calculation Dialog 00:08:32
   • More About Text Literals 00:06:49
   • Dynamic Data And Dependencies 00:08:26
   • Compound Calculation Expressions 00:06:26
9. Relationship Techniques
   • Key Fields And Their Characteristics 00:09:41
   • Primary And Foreign Keys 00:09:33
   • Relationship Operators 00:11:41
   • Using Join Tables 00:09:34
   • Filtering Portals 00:04:21
   • Sorting Related Data 00:03:06
   • Allow Create Relationships 00:04:12
10. Deployment Considerations
    • Single User Systems 00:05:04
    • Parallel Solutions And Synchronization 00:04:18
    • Networking And Peer-To-Peer 00:05:22
    • Multi-User Considerations 00:03:52
    • Using Snapshot Links 00:04:17
    • Backups And File Handling 00:04:11
11. Conclusion
    • Where To Go From Here 00:02:51
    • Getting Help When You Need It 00:02:58
    • Examples And Resources 00:02:19
    • About The Author 00:01:51
Show and hide more