| Training & Development - Technical Training Curriculum
[Back to course listing]
FileMaker Pro 10, Level 2
This
course begins where Level One ended - with a quick review and
then more valuable information about setting up relationships
between multiple tables.
Key topics include:
setting up relationships between multiple tables, resolving
many-to-many relationships, placing a portal on a layout,
and using calculation fields to manipulate numbers and text.
You'll also learn to create summary reports and executive summary
reports, import data into a FileMaker Pro (FMP) database,
export from FMP to Excel and Word, save backup copies, and get an introduction to the power of scripts in FMP.
Presenter(s): Frank Widman, Senior Technical Training Consultant
Prerequisites: FileMaker
Pro, Level 1 or equivalent
experience.
Enrollment: Use our Online
Registration Form,
or call 459-5565.
Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.
Related Courses:
| Schedule |
| Date |
Time |
Fee |
Location |
|
January 31, 2012
|
9am
- 4pm |
$25 |
Kerr Hall Room 8
|
Course Outline
- Relational Database Introduction
- Defining a relational database
- Key fields
- Relationship types
- Creating a Relational Database
10 basic steps to creating a relational database
- Resolving a many-to-many relationship using a portal
- Calculation Fields
Create a simple calculation field
- Using simple and complex functions for a calculation
- Calculations using text
- Summarizing Data
- Grand Summary layouts
- Defining summary fields
- Adding a grand summary layout part
- Sub-summary layouts
- Saving Copies and Clones
- Distinguishing the 3 Save As... options
Exchanging Information
- Importing data into an existing FileMaker Pro file
- Moving data from another application to FileMaker Pro
- Exporting data from FileMaker Pro to another application
- Scripts
- Creating a script
- Using scripts
- Changing a script
- Using Button
|
