FileMaker Pro 4

Preface How this Book is Organized Acknowledgements PART 1 Database Systems: Design and Management 1 Introduction to Database Management 1.1 Introduction 1.2 Elements of a Database System 1.3 Data Modelling 1.4 Data Processing - A Look Back 1.5 Requirements of Database Management Systems and Processing 1.6 Review of Chapter 2 Parts and Functions of a Database Management System 2.1 Introduction 2.2 Functions of a DBMS 2.3 Types of Database Transactions 2.4 Supporting Transactions 2.5 Database Recovery 2.6 Database Integrity 2.7 Database Security 2.8 Review of Chapter 3 Successful Database Design 3.1 Successful Database Design Requirements 3.2 What is Successful Database Design 3.3 Requirements Document Structure 3.4 Information Requirements 3.5 Processing Requirements 3.6 Conceptual Data Modelling 3.7 Conceptual Design Methodologies 3.8 Attribute Synthesis: The Bottom-Up Approach 3.9 Review of Chapter 4 An Example of an Employee and Projects Database Design and Analysis 4.1 Introduction 4.2 Requirements Analysis 4.3 Requirements Analysis: Step 1 4.4 The Conceptual Design: Step 2 4.5 Implementation of the Design: Step 3 4.6 Review of Chapter 5 The Relational Model 5.1 Introduction to the Relational Model 5.2 Key Terminology 5.3 Relationships 5.4 Functional Dependence 5.5 The Forms of Normalization 5.6 Brief Overview of Operators 5.7 The Flat File Database 5.8 Review of Chapter PART 2 Filemaker Pro 4.1 Examined 6 Filemaker Pro 4.1: A New Feature Overview 6.1 Introduction 6.2 New Features Introduced 6.3 General Overview of Filemaker Pro 3.0 Features 6.4 Technical Specification 7 Defining Fields 7.1 Introduction 7.2 Defining Fields 7.3 Essential Fields 7.4 New Enhancements 7.5 Data Types Supported 7.6 Working with Field Types 7.7 Auto-Formatting Field Types 7.8 Working with Global Fields 7.9 Making Global Fields Effective 7.10 Data Entry Options 7.11 Data Entry Validation 7.12 Storage Options - Indexing of Fields 7.13 Review of Chapter 8 Defining Calculations 8.1 Introduction 8.2 The Calculation Dialogue 8.3 Defining Calculations 8.4 Functions 8.5 Successful Calculation Design 8.6 Calculated Storage Options 8.7 More Calculations And Function Examples 8.8 Review of Chapter 9 Relating Files 9.1 Introduction 9.2 Terminology 9.3 Designing the Database Model 9.4 Adding More Files 9.5 Establishing the Relationships 9.6 Portals 9.7 Portals on a Layout 9.8 Creating New Records 9.9 Modifying Records 9.10 Deleting Records 9.11 Record Selection and Portals 9.12 Duplicating Records 9.13 Using the Copy and Paste Function 9.14 Sorting Records 9.15 Importing Records 9.16 Exporting Records 9.17 Lookups vs Relationships 9.18 Working with Repeating Fields 9.19 Review of Chapter 10 Working with Layouts 10.1 Introduction 10.2 Creating Layouts 10.3 Understanding Defaults 10.4 Parts and Layouts 10.5 Working with Summary Fields 10.6 Setting Up Layouts 10.7 Working with Page Margins 10.8 Creating Labels 10.9 Working with Rulers 10.10 Enhancing Layouts 10.11 Review of Chapter 11 Navigating Filemaker Pro 4.1 11.1 Introduction 11.2 Finding Records 11.3 Replacing Records the Smart Way 11.4 Entering Data in Find Mode 11.5 Sorting Records 11.6 Summary Field Sorting 11.7 Handling Empty Fields (Null Values) 11.8 Review of Chapter 12 Scriptmaker 12.1 Introduction 12.2 Before Writing Scripts 12.3 New Script Enhancements 12.4 Starting Scripting 12.5 Defining Script Procedures 12.6 Writing the Script 12.7 Exploring Conditionals 12.8 Defining Complex Scripts 12.9 Finding Duplicate Records 12.10 Sorting Records by Value 12.11 Status Functions 12.12 Automatic Telephone Dialling 12.13 Scripting Tips 12.14 Review of Chapter 13 Importing and Exporting Data 13.1 Introduction 13.2 New Import Files 13.3 Using Filters 13.4 Working with Clarisworks Office 5.0 13.5 Importing and Manipulation 13.6 Other Effects of Exporting Records 13.7 Data Transfer via the Clipboard 13.8 Exporting Records 13.9 Exporting Summary Data 13.10 ODBC Support 13.11 Review of Chapter 14 Object Linking and Embedding 14.1 Introduction 14.2 What is Object Linking and Embedding (OLE) 14.3 Object Linking and Embedding vs Dynamic Data Exchange (OLE Vs DDE) 14.4 OLE and Client-Server 14.5 What's New in OLE 2.0 14.6 Variations of OLE 14.7 Linking Objects 14.8 Embedding Objects 14.9 Linking and Embedding Packages 14.10 Filemaker Pro and OLE 14.11 Deactivating Events 14.12 Dragging and Dropping 14.13 Filemaker Pro 4.1 as a Drag Target 14.14 Validating Dropped Objects 14.15 Dragging Objects 14.16 Linked Objects and Filemaker Pro 4.1 14.17 Making Connections with OLE 14.18 More Linked Objects 14.19 Inserting Objects 14.20 Object Conversion 14.21 OLE and Networking 14.22 Scripting OLE Objects 14.23 Review Of Chapter 15 Filemaker Pro and Networking 15.1 Introduction 15.2 Networking Filemaker Pro 4.1 15.3 Networks Supported 15.4 Multi-User Filemaker Pro 4.1 15.5 Filemaker Pro 4.1 as Client-Server 15.6 Securing Data 15.7 Setting a Default Password 15.8 Cross-Platform Design Issues 15.9 Review of Chapter 16 Filemaker Pro and Applescript 16.1 Introduction 16.2 What is Applescript 16.3 Applescript - The Beginning 16.4 Creating the First Script 16.5 Additional Applescript Information 16.6 Recording Scripts 16.7 Filemaker Pro and Applescript 16.8 Going Further 16.9 Inside Filemaker Pro 16.10 Understanding Events 16.11 Further Scripting Steps 16.12 Filemaker Pro 4.1 and the Internet 16.3 Review of Chapter 17 Filemaker Pro and Windows 95/98 17.1 Introduction 17.2 Putting a Face on Things 17.3 16-Bit vs 32-Bit 17.4 Filemaker Pro 4.1 and Windows 95 17.5 The Windows 95 Registry 17.6 Long Filenames 17.1 Review of Chapter 18 Filemaker Pro and the World Wide Web 18.1 Introduction 18.2 The World Wide Web - A Background 18.3 Publishing on the Web 18.4 Beginning CDML 18.5 Review of Chapter 19 Filemaker Pro and Hypertext Markup Language (HTML) 19.1 Introduction 19.2 Understanding HTML 19.3 HTML Tags 19.4 Linking Web Pages 19.5 Review of Chapter 20 Filemaker Pro Forms and the Claris Dynamic Markup Language (CDML) 20.1 Introduction 20.2 Before Publishing your Database 20.3 Filemaker Pro Forms and Sites 20.4 Designing the Format Files 20.5 Adding Tags to Format Files Using the CDML Tool 20.6 Creating a Format File with the CDML Tool 20.7 Adding Text Fields with the CDML Tool 20.8 The CDML Menu Tags Explained 20.9 Using the Filemaker Pro Assistant of Homepage 3.0 20.10 Review of Chapter 21 Binding Filemaker Pro Files 21.1 Introduction 21.2 Preparing Files for Binding 21.3 Final Steps Before Binding 21.4 Protecting the Database 21.5 Specifying the Primary File 21.6 Converting Solution Files 21.7 Review of Chapter 22 External Functions and Apis 22.1 Introduction 22.2 Loading Plug-Ins 22.3 Understanding Hoe External Functions Work 22.4 Going into More Detail 22.5 Designing your Plug-In and Getting Started 22.6 How External Functions are Defined 22.7 Review of Chapter 23 Filemaker Pro and Java 23.1 Introduction 23.2 The Java Virtual Machine 23.3 Programming with Java 23.4 The First Java Program 23.5 What is an Applet 23.6 Integrating Java and Filemaker Pro 4.1 23.7 The Web Companion and Java Classes 23.8 Review of Chapter Function Appendix Undocumented Features Appendix CDML Tag Reference Appendix Filemaker