Buy and Download - Lynda.com Cris Ippolite FileMaker Pro 14 Essential Training

2015
Lynda
Cris Ippolite
9:22
English

Learn how to design and build smart, secure databases with FileMaker Pro 14—the database solution used everywhere from home offices to Fortune 500 companies all around the world. Cris Ippolite, drawing on years of experience with clients at his own development firm, iSolutions, walks through the essential FileMaker Pro skills, from creating tables and fields to designing layouts that display your data in a smart way. He'll also show you how to find and sort data, create reports, import and export data, write scripts, diagram relationships, and more. Watch now to start learning how to build your first database from scratch.

Introduction
Welcome
Introducing the FileMaker 14 platform
Touring the Launch Center
Using the exercise files
1. Getting Started
What is a database?
Comparing flat vs. relational databases
Reviewing how FileMaker works
Touring essential preferences
Exploring the interface
2. Solution Creation Essentials
Creating solutions from starter solutions
Creating new solutions from spreadsheets
3. Creating Tables
Determining which tables your solution will need
Creating tables in the managing tables window
4. Creating Relationships
Understanding relationship types
Diagramming relationships (with ER diagrams)
Understanding key fields
Defining primary and foreign keys
Creating relationships using FileMaker relationship graph and table occurrences
A message about relationships
5. Working with Fields
Deciding what fields you will need
Understanding field types
Defining fields
Adding fields to layouts
Using field auto-enter options
Using field validation options
6. Working with Container Fields
Using container fields in your database
Applying field options and using remote container storage
7. Working with Records
Creating and duplicating records
Editing and locking records
Deleting records and backing up files
8. Importing and Exporting
Importing data
Importing records to refresh data
Exporting data
9. Creating Layouts
Introducing layouts
Working with layout themes
Using the Layout Assistant to create list views
10. Working with Layouts
Using the Layout Setup dialog
Understanding layout parts
Previewing the Inspector
Exploring layout tools and status area in Layout mode
Managing layouts and layout folders
11. Formatting Layout Objects
Using guides, arranging, aligning, grouping, and locking layout objects
Applying themes to layouts
Working with shapes in your layouts
Applying screen stencils
Working with images and icons on your layouts
Applying gradients
Formatting fields and applying field attributes
Understanding states
Setting field behaviors
Using the tab control feature
Using slide controls in your layouts
Working with popovers in your layouts
Setting the tab order
Learning how to conditionally hide layout objects
12. Finding Data
Using the basic find functions
Reviewing new requests in find mode
Establishing search operators
Constraining or extending found sets
Finding records using date, time, or timestamp criteria
Using Fast Match and Quick Find
13. Sorting Data
Sorting with a single piece of criteria
Sorting with related fields
Sorting with multiple criteria
Sorting using custom values
Sorting using buttons
14. Value Lists
Introducing field control styles
Creating and applying static value lists
Creating and applying dynamic value lists
15. Printing and Saving
Previewing pages and print options
Controlling object visibility when printing
Printing merge letters
Saving as PDF or Excel
16. Reports
Building simple reports with summary fields
Creating subsummary reports
Adding charts to reports
Creating subsummary reports in Table view
Creating quick charts in Table view
17. Calculation Essentials
Introducing calculations
Touring the Calculation Dialog window
Using number functions
Using date and time functions
Using text functions
Using get functions
Using logic functions
18. Script Essentials
Understanding scripts and script steps
Assigning script steps to buttons
Touring the Script workspace
Creating multiline scripts
Adding find criteria to a script
Using the New Window script step
Understanding the If script step
Using script parameters
Reviewing the Send Mail script option
19. Script Triggers
Introducing script triggers
Using object-based triggers
Using layout-based triggers
Using file-based triggers (Open and Close scripts)
Conclusion
Goodbye

lynda.com/FileMaker-Pro-tutorials/FileMaker-Pro-14-Essential-Training/373330-2.html