Introduction to FileMaker
Description: A 2-day class that covers the concepts to create and use a FileMaker Pro database. Learn to use FileMaker Pro to search and enter data; import and export data; create fields and understand data types; setup auto-enter and validation options; create layouts and layout objects (fields, portals, tab controls); manipulate layout objects (auto-resize, conditional formatting, field formatting).
| Class |
Dates |
Price |
|
| Introduction to FileMaker |
Aug 11-12
Oct 13-14
|
$695 |
Level: Beginner. Want to go further? Try Intermediate FileMaker.
Prerequisites: Proficiency with word processor, spreadsheet and browser software. No prior database experience necessary.
Using FileMaker Pro - Approach FileMaker Pro from the perspective of users: learn techniques for working with FileMaker data, printing and exporting, performing Find requests, and accessing features for working with email, Adobe PDF and Microsoft Excel documents.
- Understand and operate the menu commands
- Create, edit and delete records
- Perform advanced finds and sorts on data
- Skillfully setup how to print and preview data
- Save data in Excel and PDF formats
- Understand how to use FileMaker Pro in conjunction with other applications to import and export data
|
Working with Fields - Learn practical skills required to define FileMaker Pro tables and fields. This module explores data types and options for auto-entry, validation, and field storage. Discover how to manage images and other objects in container fields and work with the Database Design Report in FileMaker Pro Advanced.
- Be familiar with different field types available in FileMaker Pro
- Know how to specify auto-entry and validation options for a field
- Understand the importance of indexing
- Be able to insert and export files from container fields
|
Working with Layouts - Review new features in FileMaker Pro, such as conditional formatting and auto-resize, while learning how to work with layout objects. Understand how field behavior and tab orders are controlled, learn to create different kinds of value lists, and work with the Web Viewer object, Tab Control object, and tool tips.
- Be able to create and modify layouts using status area tools and basic layout controls
- Be adept at setting auto resize options for layout objects
- Know how to facilitate a user's interaction with layouts using value lists
- Have practical examples for accessing the internet and displaying web pages using web viewer objects
- Understand how to use conditional formatting to alter the appearance of an object under specified conditions
|
|
