2013
Infinite Skills
Ray Cologon
9:30
English
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.
01. Introduction
0101 Overview
0102 Getting Going With FileMaker
0103 Starting A Database From Scratch
0104 Starting With The Manage Database Dialog
0105 The Language Of FileMaker
0106 Getting Used To The Status Toolbar
0107 Setting Up FileMaker Preferences
0108 Working With Data - Creating Records
0109 Basics Of Finding And Sorting
02. What Belongs Where?
0201 Important Database Concepts
0202 Why Relationships Matter
0203 Modes Of Operation
0204 Basic Anatomy
0205 Preliminary Data Design
0206 Creating Structure For Your Data - Part 1
0207 Creating Structure For Your Data - Part 2
0208 Building Different Views
0209 Setting Up User Navigation
0210 Basics Of Data Security
0211 Controlling File Access
0212 FileMaker Advanced Features Overview
03. Building The Interface
0301 Layouts And Context
0302 Using Layout Tools
0303 Creating And Formatting Objects
0304 Controlling Object Size And Position
0305 Layout Parts In Action
0306 FileMaker Visual Design
0307 Helping The User With Visual Cues
0308 Setting The Tab Order
0309 Objects And Associated Actions
04. Adding Visual Power
0401 Setting Up Buttons
0402 Tab Control Objects
0403 Portals And Their Uses
0404 The World Of Web Viewers
0405 Specifying Tooltips
0406 Conditional Formatting
0407 Autosizing Objects
0408 Basic Data Presentation
05. The Basics Of Working With Data
0501 Aids To Data Entry
0502 Committing Or Reverting Changes
0503 Values And Lists
0504 Shortcuts And Alternate Methods
0505 Finding And Omitting
0506 Finding Matching Records
0507 Compound Searches
0508 Multi-Request Finds
0509 Constraining And Extending
0510 Sorting And Summarizing
0511 Accessing Related Data
0512 Summarizing Related Data
0513 Incorporating Charts
0514 Importing And Exporting Data
0515 Saving And Sending Data
06. Database Design Fundamentals
0601 Tables And Table Occurrences
0602 Fields And Data Type
0603 Global Field Behaviour
0604 Setting Up Basic Calculations
0605 Coding Logic
0606 Stored And Unstored Calculations
0607 Working With The Relationships Graph
07. Automation Options
0701 Following The Script
0702 Creating A Script
0703 Actions In Sequence
0704 Script Editing Basics
0705 Working With Named Objects
0706 Scripted Navigation
0707 Scripting Conditional Sequences
0708 Scripting With Loops
0709 Buttons And Triggers
0710 Using Script Parameters
08. Calculation Basics
0801 The Language Of Calculations
0802 Using Calculation Functions
0803 Understanding Boolean Logic
0804 Beyond Arithmetic
0805 Working With The Calculation Dialog
0806 More About Text Literals
0807 Dynamic Data And Dependencies
0808 Compound Calculation Expressions
09. Relationship Techniques
0901 Key Fields And Their Characteristics
0902 Primary And Foreign Keys
0903 Relationship Operators
0904 Using Join Tables
0905 Filtering Portals
0906 Sorting Related Data
0907 Allow Create Relationships
10. Deployment Considerations
1001 Single User Systems
1002 Parallel Solutions And Synchronization
1003 Networking And Peer-To-Peer
1004 Multi-User Considerations
1005 Using Snapshot Links
1006 Backups And File Handling
11. Conclusion
1101 Where To Go From Here
1102 Getting Help When You Need It
1103 Examples And Resources
1104 About The Author
http://www.infiniteskills.com/

Download File Size:1.88 GB

---