Learning FileMaker 17

Course details

Learn how to design and build custom apps with FileMaker 17—the latest version of the powerful platform used everywhere from home offices to Fortune 500 companies all around the world. Drawing on over 20 years of experience with clients at his own development firm, iSolutions, Cris Ippolite walks through the essential FileMaker Pro skills, from creating tables and fields to designing layouts that display your data in a smart way. He also shows you how to work with data, create reports, import and export data, write scripts, perform calculations, and more. Watch now to start learning how to build your first database from scratch.

Learning objectives
Database basics
New features in the FileMaker 17 platform
Getting going with starter apps
Creating tables
Adding fields
Using container fields
Creating, editing, and deleting records
Importing and exporting data
Creating layouts
Formatting layouts
Working with styles ad themes
Searching for data
Sorting data
Building reports
Calculations and functions
Scripting

Concepts

0. Introduction

01 - Welcome
02 - Introducing the FileMaker platform
03 - Touring the new My Apps window
04 - Using the exercise files

1. Getting Started

05 - What is a database
06 - How FileMaker works
07 - Essential preferences
08 - Getting to know the interface

2. FileMaker App Creation Essentials

09 - Getting going with starter apps and add-on tables

3. Creating Tables

10 - Determining which tables your FileMaker app will need
11 - Creating tables in the managing tables window
12 - An important note about relationships

4. Working with Fields

13 - Deciding what fields you will need
14 - Understanding field types
15 - Defining fields
16 - Adding fields to layouts
17 - Field options - Auto enter
18 - Field options - Validation

5. Working with Container Fields

19 - Using container fields in your FileMaker app
20 - Applying container field options
21 - Container storage options

6. Working with Records

22 - Creating and duplicating records
23 - Editing and locking records
24 - Deleting records and backing up files

7. Importing and Exporting

25 - Importing data
26 - Exporting data

8. Creating Layouts

27 - Introducing layouts
28 - Using the Layout Assistant to create new layouts

9. Working with Layouts

29 - Understanding layout parts
30 - The Inspector pane
31 - Layout tools and status area in Layout mode
32 - Managing layouts and layout folders

10. Formatting Layout Objects

33 - Using guides and arranging, aligning, grouping, and locking layout objects
34 - Applying themes to layouts
35 - Applying screen stencils
36 - Formatting fields and applying field attributes
37 - Controlling layout object behaviors
38 - Using the Tab Control feature
39 - Slide controls in your layouts
40 - Popovers in your layouts
41 - Setting the tab order

11. Finding Data

42 - Using the basic find functions
43 - New requests in Find mode
44 - Search operators
45 - Constraining or extending found sets
46 - Using Fast Match and Quick Find

12. Sorting Data

47 - Sorting with single criteria
48 - Sorting with multiple criteria
49 - Sorting using custom values
50 - Sorting using buttons

13. Value Lists

51 - Drop downs, radio buttons, and other field control options
52 - Creating and applying static value lists

14. Printing and Saving

53 - Previewing pages and print options

15. Reports

54 - Building simple reports with summary fields
55 - Creating subsummary reports

16. Calculation Essentials

56 - What are calculations
57 - Touring the Calculation dialog window
58 - Number functions
59 - Date and time functions
60 - Text functions
61 - Logic functions

17. Script Essentials

62 - What are scripts and script steps
63 - Assigning script steps to buttons
64 - Touring the Script Workspace and Script Debugger
65 - Creating multiline scripts
66 - Adding find criteria to a script
67 - Using the New Window script step
68 - Understanding the If script step

18. New Features in Version 17

69 - Starter apps and add-on tables
70 - Master-detail layouts
71 - Sensor support in FileMaker Go
72 - FileMaker data migration tool
73 - FileMaker Server Admin Console

Conclusion

74 - Next steps