O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning FileMaker Pro 13

Video Description

In this FileMaker Pro 13 training course, expert author Ray Cologon teaches you the basics of managing your data using the FileMaker Pro database. This course is designed for the absolute beginner, meaning no previous experience with FileMaker is required.

You will start by learning about the new features in FileMaker Pro 13, then jump into covering important database concepts, preliminary data design, and the basics of data security. Ray will then teach you how to build the interface, including using the layout tools, creating and formatting objects, and setting the tab order. This video tutorial will also cover how to add visual power, work with data, the fundamentals of database design, automation options, and calculation basics. Finally, you will learn about relationship techniques, such as using join tables and sorting related data, as well as deployment considerations, including single user systems and backups and file handling.

Once you have completed this computer based training course, you will have a solid understanding of how to create your own database using FileMaker. Working files are included, allowing you to follow along with the author throughout the lessons.


Download the working files for this course at: http://www.infiniteskills.com/01968

Table of Contents

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