FileMaker 8 @Work : Projects and Techniques to Get the Job Done

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780672328565 | 0672328569
Cover: Paperback
Copyright: 1/1/2006

Sorry, this item is currently not available.

Most books on databases approach the reader with descriptions of how to use tools, and make some reference to putting those tools into a real-world context.FileMaker 8 @Work:Projects and Techniques to Get the Job Doneturns this approach on its ear by introducing key tools in a single chapter, then moves on to what you really want to know - how to use the product to complete the projects that they face at work. This book provides step-by-step coverage of how to complete a variety of projects that a panel of users has verified as common projects those using the application are asked to complete. Tips, tricks, and notes are provided with the information you need to carry over what you learn on these projects to others you'll undoubtedly be asked to create.

Introduction

(1)

Organization of This Book

(1)

Downloading the Book's Project Files

(1)

Conventions Used in This Book

(4)

Part I: Getting Started

Hands-On with FileMaker

(16)

State-of-the-Art FileMaker

(3)

FileMaker Through the Decades

(1)

The FileMaker Family of Products

(1)

Introducing the Database for This Chapter

(1)

Using FileMaker to Browse and Find Data

(7)

Using the Status Area

(1)

Browsing Data

(1)

Finding Data

(2)

Sorting Data

(1)

Using Data Entry Fields

(1)

Exporting FileMaker Data

(1)

Using Table and List Views

(1)

Using FileMaker Layout Mode

(3)

Creating a Layout with FileMaker's Assistance

(1)

Using FileMaker Fields in Layout Mode

(2)

Using Layout Parts

(1)

Creating Reports

(1)

Using FileMaker Preview Mode

(3)

Automating FileMaker

(18)

Introducing ScriptMaker

(8)

Writing a Basic Script

(2)

Designing a Script Architecture

(2)

No Interaction Means No Interaction---Set Error Capture

(1)

Exploring ScriptMaker Features

(1)

Using Control Script Steps

(2)

Debugging Scripts

(2)

Using Data Viewer

(1)

Using Script Parameters

(1)

Using Calculations

(1)

Developing a Runtime (Standalone) Solution

(4)

Part II: Projects

Building FileMaker Solutions

(12)

About the Project

(1)

Prerequisites

(1)

Planning a FileMaker Solution

(2)

What Is the Scope of the Project?

(1)

What Information Do You Need to Handle?

(1)

How Should You Talk About the Data?

(1)

What Are the Rules Governing the Data?

(1)

What Reports Do You Need?

(1)

Do You Need to Import or Export Data?

(1)

Do You Have Ongoing Import/Export Needs?

(1)

What Are Your Security Needs?

(1)

Implementing a FileMaker Solution

(1)

Project: Setting Up Your First Database

(9)

Getting Started

(1)

Creating Tables

(1)

Creating Fields

(1)

Creating Relationships

(3)

Creating a Layout

(1)

Testing Your Solution

(1)

Sharing FileMaker Databases on a Network

(1)

Converting and Normalizing a Spreadsheet

(3)

Managing Inventory

(16)

About the Project

(1)

Prerequisites

(1)

Planning the Project

(2)

What Are You Keeping Track Of?

(1)

What Information Will You Store?

(1)

How Many Items Are There to Keep Track Of?

(1)

What Are the Rules and Characteristics of the Data?

(1)

Project: Inventory Manager

(13)

Getting Started

(1)

Setting Up a One-Table Database

(3)

Setting Auto-Entries for Fields

(1)

Implementing the Data Rules for Validation

(1)

Creating Your First Layout

(1)

Creating the Report

(8)

Managing One-to-Many Relationships

(16)

About the Project

(1)

Prerequisites

(1)

Planning the Project

(1)

Project: Collections Database

(15)

Getting Started

(1)

Adding the Categories Table

(4)

Relating the Categories Table to the Inventory Table

(1)

Creating the Category Report

(4)

Adding Categories to Data Entry

(6)

Managing Many-to-Many Relationships

(14)

About the Project

(1)

Prerequisites

(1)

Planning the Project

(1)

Project: Boutique Manager

(13)

Getting Started

(1)

Setting Up a Join Table

(1)

Creating the Many-to-Many Relationship

(4)

Showing the Relationships in a Layout

(1)

Enabling Data Entry for the Many-to-Many Relationship

(3)

Building the Other End of the Relationship

(4)

Managing Production, Tasks, and Subtasks

(18)

About the Project

(1)

Prerequisites

(1)

Planning the Project

100

(1)

Project: Production Management

101

(16)

Getting Started

101

(1)

Adding the Fields

102

(1)

Cleaning Up the Layout

103

(1)

Creating the Self-join Relationships

104

(1)

Creating the Tabbed Layout

105

(2)

Adding Fields to the Task Info Tab

107

(1)

Adding the Portal to the Subtasks Tab

107

(1)

Implementing Navigation

108

(1)

Creating the Script and Adding the Button to Add New Subtasks

109

(2)

Adding the Drop-down Calendar

111

(2)

Coloring the Date

113

(4)

Creating a Secure Shared Database

117

(16)

About the Project

117

(1)

Prerequisites

117

(1)

Planning the Project

118

(1)

Project: Idea Tracker

119

(14)

Getting Started

119

(1)

Modifying the Database: Changing Fields

119

(1)

Modifying the Database: Renaming Tables

120

(1)

Modifying the Database: Layouts and Scripts

121

Setting Account Privileges

112

(13)

Setting Up Networking

125

(2)

Testing Instant Web Publishing

127

(6)

Implementing a Scheduling Solution

133

(20)

About the Project

133

(1)

Prerequisites

133

(1)

Planning the Project

134

(2)

Planning the Data Rules

134

(1)

Planning the Interface

134

(1)

Preparing to Create New Records with Scripts and Globals

135

(1)

Project: Class Enrollment

136

(17)

Getting Started

137

(1)

Creating the Fields for the Students Table

138

(1)

Creating the Fields for the Classes Table

139

(1)

Creating the Fields for the Enrollments Table

140

(1)

Creating the Fields for the Payments Table

140

(1)

Setting Up the Relationships

140

(2)

Building the Home Layout and Navigation Script

142

(1)

Building the Classes Layout

143

(3)

Building the Students Layout

146

(2)

Implementing the Enroll Process

148

(2)

Implementing the Payment Process

150

(3)

Implementing a Runtime Solution

153

(20)

About the Project

153

(1)

Prerequisites

153

(1)

Planning the Project

154

(1)

Project: Membership List

154

(19)

Getting Started

155

(1)

Adding Basic Fields to the Membership Table

155

(1)

Implementing Data Hiding

155

(2)

Adding Basic Fields to the Dues Table

157

(1)

Creating the Membership/Dues Relationship and Calculating the Balance

158

(2)

Creating the Data Entry Layout

160

(3)

Adding a New Dues Script and Button

163

(1)

Creating the Membership List Layout

164

(1)

Creating Custom Menu Sets

165

(3)

Setting Accounts and Privileges

168

(1)

Finishing Security

168

(1)

Creating the Runtime Solution

169

(4)

Implementing a Simple Web Publishing Solution

173

(14)

About the Project

173

(1)

Prerequisites

173

(1)

Planning the Project

174

(1)

Project: Blog

174

(13)

Getting Started

174

(2)

Creating the Categories Value List

176

(1)

Preparing the Blog Layout

177

(1)

Setting Instant Web Publishing Privileges in the Database

178

(2)

Turning on Instant Web Publishing and Sharing the Database

180

(1)

Using a Browser to Connect to the Blog

181

(2)

Implementing a Respond Button

183

(1)

Creating the Relationships

183

(1)

Cleaning up the Layouts

184

(1)

Implementing Navigation

185

(2)

Converting a Solution to FileMaker Pro 7 or 8

187

(22)

About the Project

187

(1)

Prerequisites

187

(1)

Planning the Project

188

(1)

Project: FileMaker Conversion

189

(12)

Getting Started

190

(1)

Reviewing Field Definitions

190

(1)

Reviewing Value Lists

191

(1)

Reviewing Relationships

191

(2)

Running Conversion

193

(1)

Reviewing Converted Field Definitions and Value Lists

194

(1)

Reviewing Converted Relationships

194

(1)

Reviewing File References

194

(2)

Consolidating Tables (with FileMaker Pro Advanced)

196

(1)

Consolidating Tables (with Other Versions)

197

(4)

Part III: Appendixes

A. FileMaker Error Codes

201

(6)

B. FileMaker Resources

207

(2)

This Book's Resources

207

(1)

FileMaker Resources

207

(1)

Relational Databases

208

(1)

Security

208

(1)

Graphics and Interface

208

(1)

Glossary

209

(4)

Index

213

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

FileMaker 8 @Work : Projects and Techniques to Get the Job Done

Summary

Table of Contents

Supplemental Materials