| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| FileMaker Pro 7: Advanced |
| Course Number: AP0070 |
| Category: Database & Collaboration Tools |
| Duration: 1.00 day |
Description
This ILT Series course builds on the fundamentals taught in FileMaker Pro 7: Basic. Students will learn how to create more complex field definitions and calculations, how to work with many-to-many relationships, lookups, and table data summaries, and how to design more efficient layouts. In addition, course activities cover advanced scripting, networking databases, and publishing a database to the Web. An appendix provides an overview of complex relationships The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success.
Outline
- Unit 1: Field options
- Topic A: Advanced value lists
- Topic B: Advanced calculations
- Topic C: Field auto-entry
- Topic D: Field validation
- Topic E: Container fields
- Unit 2: Many-to-many relationships
- Topic A: Relationship types
- Topic B: Many-to-many relationship formation
- Topic C: Lookups
- Topic D: Related table summary
- Unit 3: Advanced Layouts
- Topic A: Layout efficiency boosters
- Topic B: Layout parts
- Topic C: Object appearance
- Topic D: Merge fields
- Topic E: Field entry behavior
- Unit 4: Complex scripts
- Topic A: Chained scripts
- Topic B: Related record script steps
- Topic C: Intercepting errors
- Topic D: Parameters
- Topic E: Script problems
- Unit 5: Networking databases
- Topic A: Database security
- Topic B: Multiple user access
- Topic C: Web publishing
- Appendix A: Complex relationships
- Topic A: Self-joining relationships
- Topic B: Dependent value lists
- Topic C: Multiple relationships to one table
- Topic D: Complex criteria relationships