> Event Dates
> What You'll Learn
> Directions to Event
Register for Event
> Online Registration
> Fax Registration (PDF) |
What You'll Learn
FileMaker Intermediate (Day 1)
1. How do I create a new database?
- Create a data table
- Define fields/field types
- Field options
- Validation
- Storage
2. How do I add functionality using calculations and functions?
- Use Operators to concatenate data and perform math functions
- Use Logical functions to create conditional calculations
- Use Aggregate functions to count and sum data
3. How can I view my data?
- Creating layouts
- View as form/list/table
- Parts of a layout
- reate a summary report
- Create a form letter
4. How do I create organized, space-saving layouts?
- Use tab controls to save layout real estate
- Use autoresize to dynamically change layout element dimensions*
- Use color to offset layout parts and drawing objects to group fields
- Use tooltips to provide on-screen help for users
- Use conditional formatting to create dynamic layouts*
5. How do I help users quickly enter accurate data?
- Use field behaviors and tab order to speed up data entry
- Use the field Control/Setup box to set fields to auto-complete
- Format fields as checkboxes, radio buttons, dropdown lists, pop-up menus, or dropdown calendars
- Learn how custom menus can help protect your data
FileMaker Intermediate (Day 2)
6. How do I create a relational database in FileMaker?
- Planning a relational database
- Learn the different types of relationships
- Resolve complex relationships
- Translate planning into a FileMaker database
7. How do I add relational data?
- Establish relationships between tables
- Create a portal to view related data
- Enter data in the portal row
- Delete related record from a portal row
8. How do I automate workflow with buttons and scripts?
- Create buttons to create records, delete records, enter find mode, sort records and go to related records
- Use tab order to activate a button without using a mouse
- See the new and improved FileMaker 9 script manager in action*
- Write scripts that perform multiple commands and assign them to buttons to extend a button’s functionality
- Use script parameters and script variables to temporarily store and re-use data within scripts and beyond
- Learn how to debug scripts and use the new and improved data viewer to track down potential problems*
|
