E-Book Overview
Learn FileMaker?® Pro 9 provides a logical, hands-on approach to understanding the features of FileMaker Pro, both for beginners and those who have experience with previous versions of the software. From defining database terms and converting files created in previous FileMaker Pro versions to producing reports and using files on the web, this book covers the fundamentals as well as the newest features that considerably enhance FileMaker Pro s database management capabilities. Learn how to: Format layout objects with Autoresize and conditional formatting. Harness the power of the new External SQL Data Source tools. Adapt one script to many purposes to cut development time and expense. Work with the enhanced Web Viewer to harvest data for your applications. Share data as PDF and Excel files and export data as e-mail attachments. Organize your relationships with the anchor-buoy method. Use the alignment tools to quickly align objects on your layout.
E-Book Content
Jonathan Stars
Wordware Publishing, Inc.
Library of Congress Cataloging-in-Publication Data Stars, Jonathan. Learn FileMaker Pro 9 / by Jonathan Stars. p. cm. Includes index. ISBN-13: 978-1-59822-046-9 (pbk.) ISBN-10: 1-59822-046-2 1. FileMaker pro. 2. Database management. I. Title. QA76.9.D3S72465 2007 005.75'65--dc22 2007030011
© 2008, Wordware Publishing, Inc. All Rights Reserved 1100 Summit Ave., Suite 102 Plano, Texas 75074
No part of this book may be reproduced in any form or by any means without permission in writing from Wordware Publishing, Inc. Printed in the United States of America
ISBN-13: 978-1-59822-046-9 ISBN-10: 1-59822-046-2 10 9 8 7 6 5 4 3 2 1 0709
FileMaker and ScriptMaker are registered trademarks of FileMaker, Inc. Other brand names and product names mentioned in this book are trademarks or service marks of their respective companies. Any omission or misuse (of any kind) of service marks or trademarks should not be regarded as intent to infringe on the property of others. The publisher recognizes and respects all marks used by companies, manufacturers, and developers as a means to distinguish their products. This book is sold as is, without warranty of any kind, either express or implied, respecting the contents of this book and any disks or programs that may accompany it, including but not limited to implied warranties for the book’s quality, performance, merchantability, or fitness for any particular purpose. Neither Wordware Publishing, Inc. nor its dealers or distributors shall be liable to the purchaser or any other person or entity with respect to any liability, loss, or damage caused or alleged to have been caused directly or indirectly by this book.
All inquiries for volume purchases of this book should be addressed to Wordware Publishing, Inc., at the above address. Telephone inquiries may be made by calling: (972) 423-0090
iii
Contents Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xx Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi
Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiv Part 1
Learning the Basics Chapter 1 Getting Acquainted with FileMaker Pro . . . . . . . . . . . . 2 Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 What Is a Database? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Using FileMaker Pro . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Opening FileMaker Pro . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Opening a FileMaker Pro File . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Database Concepts . . . . .