Team DDU......Page 1
Preface......Page 12
Acknowledgments......Page 20
Contents......Page 24
Part I: The Fundamentals......Page 34
1: What Is a Database?......Page 36
2: FileMaker Pro Basic Operations......Page 54
3: What's New in FileMaker Pro 7?......Page 82
Part II: Database Design Basics......Page 94
4: Creating Your First Database......Page 96
5: Defining Fields......Page 158
6: Layouts......Page 212
7: Setting Preferences......Page 280
Part III: Working with Databases......Page 294
8: Working with Records......Page 296
9: Searching for and Selecting Records......Page 334
10: Sorting Records......Page 362
11: Reports......Page 382
12: Using the Spelling Checker......Page 394
13: Printing......Page 414
Part IV: Putting FileMaker Pro to Work......Page 436
14: Calculations and Computations......Page 438
15: Automating FileMaker Pro......Page 458
16: Exchanging Data......Page 546
17: Creating and Using Templates......Page 584
Part V: Mastering FileMaker Pro......Page 594
18: Linking Tables: Relationships and Lookups......Page 596
19: Using FileMaker Pro in Workgroups......Page 632
20: Web Publishing with FileMaker Pro......Page 658
21: Advanced Database Connectivity with XML and ODBC/JDBC......Page 674
22: Expanding FileMaker's Capabilities Using Plug-Ins......Page 696
Part VI: Developing Databases for Others to Use......Page 706
23: Designing Databases for Others......Page 708
24: Debugging Scripts......Page 736
25: Generating Database Reports......Page 740
26: Creating Custom Database Solutions......Page 748
Part VII: Appendixes......Page 764
Appendix A: Macintosh Keyboard Shortcuts......Page 766
Appendix B: Windows Keyboard Shortcuts......Page 778
Appendix C: FileMaker Pro Function Reference......Page 788
Appendix D: Glossary......Page 864
Appendix E: Resources......Page 884
Appendix F: About the CD......Page 890
Index......Page 894
End-User License Agreement......Page 936