FileMaker Pro 7 Advanced Study Guide

1-4188-4076-9 © 2006 Publish date: March 7, 2005

Buy Now: $25.99

 

Are you ready to learn more advanced techniques for using FileMaker Pro? If so, choose the FileMaker Pro 7 Advanced study guide. This advanced course takes what you learned in the basic course and builds on that fundamental knowledge. You will learn ways of creating more complex field definitions and calculations and start working with many-to-many relationships, lookups, and table data summaries.

The FileMaker Pro 7 Advanced courseware also teaches you how to design more efficient layouts. From there, you'll participate in course activities that teach you about advanced scripting, how to network databases, and how to publishing your database to the Internet. At the end of the book, an overview of complex relationships is laid out in the appendix.

Our advanced computer training books such as this one teach you advanced techniques for using software and getting the most out of it. If you have basic skills but want to work more productively and take advantage of the many powerful features available in FileMaker, then the FileMaker Pro 7 Advanced courseware is for you.

This course is five units long and shouldn't take you too long to work through. You'll learn a variety of techniques that you can immediately put into practice working on your own databases.

Course Objectives

By following this courseware, you will learn how to set field options to make data entry and values more efficient and accurate, how to make many-to-many relationships, how to control the way field data appears on-screen and on the printed page using layout parts, merge fields, sliding, and field behavior options.

You will also work with complex scripts troubleshooting using chained scripts, parameters, error checking, and conditional code. Finally, you will learn how to share your database through local networks and the Internet.

Course Contents

Unit 1 introduces field options

• Advanced value lists
• Advanced calculations
• Field auto-entry
• Field validation
• Container fields

Unit 2 covers many-to-many relationships

• Relationship types
• Forming many-to-many relationships
• Lookups
• Related table summary

Unit 3 discusses advanced Layouts

• Layout efficiency boosters
• Layout parts
• Object appearance
• Merge fields
• Field entry behavior

Unit 4 covers complex scripts

• Chained scripts
• Related record script steps
• How to intercept errors
• Parameters
• Script problems

Unit 5 discusses networking databases

• Database security
• Multiple user access
• Internet publishing

Appendix A covers complex relationships

• Self-joining relationships
• Dependent value lists
• Multiple relationships to one table
• Complex criteria relationships