Course Content
Refreshing on FileMaker 9
- File Size limits
- Database File References
- Defining Databases
- Multiple Table Structure
Defining Fields
- Data Types
- Indexing
- Globals
- Complex calculations
- New functions
Layout Mode
- Selecting the table
- Layout Options
- Auto save vs. Manual
- Views
- Field Behaviour
- Inserting Fields
Interface Design Techniques
Using Tabs to navigate data regions
Colour coding and usability
Building Relationships
- One to One
- One to Many
- Many to Many
- Simple – Equal Match
- Complex – Unequal Match
- Multiple Match
- (Equal and /or Unequal)
- Entity Relationship Diagram and the DOM
- Portals
Scripts
- Web Compatibility
- Accessibility to Scripts
- Looping Scripts
- Multiple User environments
- Custom Dialogues
- New Windows
Importing and Exporting
- Exporting Found Sets
- Formatting Records
- Export Format
- Exporting field content
- Importing from FileMaker
- Importing from Excel
- Field Mapping
Networking Multiple Users
- Network Ports
- Layouts
- Scripts
- User Access and Security
Accounts and Privileges
- Admin User
- Privilege Sets
- Other Users
- Extended Privileges
Advanced Features
- Web Viewer
- Conditional Formatting
- Advanced Tab Control
- Object Navigation and Control
- Custom Functions
- Custom Menus
- Object Anchoring
