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)
()
Ex_Files_FMP_14_EssT.zip
(135.0 MB)