Advanced File Maker Pro 5.5: Techinques for Developers with CDR

Overview

With more than seven million users around the world, FileMaker is one of the most popular database packages on the market. But until now, there have not been any books for FileMaker Pro 5.5 developers that discuss advanced topics. Advanced FileMaker Pro 5.5 Techniques for Developers covers such topics as relational theory, security implementations, audit trails, recursive relationships, advanced use of portals, and reporting. FileMaker consultants Chris Moyer and Bob Bowers cover the foundation skills, and more, ...
See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia)
  • All (13) from $2.72   
  • New (1) from $45.00   
  • Used (12) from $2.72   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$45.00
Seller since 2014

Feedback rating:

(146)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

With more than seven million users around the world, FileMaker is one of the most popular database packages on the market. But until now, there have not been any books for FileMaker Pro 5.5 developers that discuss advanced topics. Advanced FileMaker Pro 5.5 Techniques for Developers covers such topics as relational theory, security implementations, audit trails, recursive relationships, advanced use of portals, and reporting. FileMaker consultants Chris Moyer and Bob Bowers cover the foundation skills, and more, that are required for complex FileMaker systems.
Read More Show Less

Product Details

  • ISBN-13: 9781556228599
  • Publisher: Wordware Publishing, Inc.
  • Publication date: 4/25/2002
  • Series: Wordware Filemaker Library
  • Edition description: BK&CD-ROM
  • Pages: 376
  • Product dimensions: 7.56 (w) x 9.24 (h) x 1.15 (d)

Table of Contents

Foreword x
Acknowledgments xi
Chapter 1 The Relational Model 1
Databases as Vessels of Meaning 2
Roots of the Relational Model 7
Set Theory 7
First Order Predicate Logic 12
Overview of the Relational Model 15
Objects 15
Operators 21
Union 21
Intersection 22
Subtraction 22
Product 22
Join 24
Project 25
Restrict 25
Divide 25
Integrity 26
Null Values 27
Candidate Keys 29
Primary Keys 31
Foreign Keys 32
Summary 33
Chapter 2 The Relational Model and FileMaker Pro 35
Building Relational Systems with FileMaker Pro 35
Relational Closure Property 40
Relational Operators 41
Project 41
Restrict 42
Joins 42
Natural Join (aka Inner Join) 43
Outer Join 44
Union Join 46
Cross Join 46
Cartesian Product (Multiplication, or Product) 46
Difference 48
Division 50
Intersection 55
Union 55
Domains 56
Date Domains 57
Enforcing Other Domain Types 58
Scalar Values 59
Primary Keys 60
Referential Integrity 63
Restricted Deletes 64
Restricted Updates 65
Cascading Deletes 65
Cascading Updates 65
Summary 66
Chapter 3 Normalization 67
Functional Dependence 68
First Normal Form (1NF) 70
Second Normal Form (2NF) 73
Third Normal Form (3NF) 76
Boyce-Codd Normal Form (BCNF) 78
Fourth Normal Form (4NF) 79
Fifth Normal Form (5NF) 83
Summary 83
Chapter 4 Audit Trails 85
Capturing Changes to Fields 86
The Audit Log 92
Rollback Considerations 97
Types of Rollbacks 99
Rolling Back Updates to a Single Field 99
Rolling Back a Record 99
Rolling Back Changes Made by a Certain User 100
Rolling Back a Table or System 100
Recreating Transactions Since the Last Backup 101
Constructing a Rollback Mechanism 101
Summary 106
Chapter 5 Relational Design 107
Process Description 109
Entity Relationship Diagramming 114
Prototyping the Interface 120
Building the Structure 122
The XP Approach 122
Summary 128
Chapter 6 Database Security Issues 129
Guarding Against Physical File Access 130
Invisible Files 133
Protecting FileMaker Pro Master Password Access 135
Binder to the Rescue 136
No New Relationships 138
ScriptMaker Issues 138
Those Pesky Value Lists 139
Binder Review 140
Zen and the Art of Annoyance 141
Protecting Your Intellectual Property with Easter Eggs 143
A Little Help from Your Friends 146
External Functions 146
Summary 148
Chapter 7 Secure Login Systems 151
The Basic Login System 152
The User Table 153
Setting FileMaker Security 154
Startup Scripts 156
Authentication Routine 156
Checking Privileges 159
Logging Activity 160
Patching Holes 163
Alternate Methods of Opening Files 166
The Secure Login System 167
Login and Password Authentication 169
Creating and Checking Privileges 172
The Admin Interface 175
Creating and Deleting Users 176
Creating and Deleting Privileges 181
Assigning Privileges 183
Other Features You Might Want to Add 185
Summary 186
Chapter 8 Advanced Use of Portals 187
Portals and Relationships 187
Portal Setup Options 191
Deletion of Related Records 192
Selection Portals 194
Selection Portal Variation 202
Portal Filters 205
Multiple Portal Filters 210
Type-Ahead Portals 212
Highlighting Portal Rows 216
Highlighting Multiple Portal Rows 220
Portal Sorting 227
Extra Credit 232
Hidden Portals 236
Summary 240
Chapter 9 Reporting 241
Year-Over-Year Reporting 242
Method 1 Customer Table 244
Method 2 Invoice Table 247
Data Warehousing with Utility Files 250
Step 1 Creating the Utility Table 250
Step 2 Getting Data into the Warehouse 251
Step 3 Accessing the Data in the Warehouse 257
Bucket Reports 259
Another Approach to Bucket Reports 263
Charting 271
Task 1 Pie Chart 272
Task 2 Line Chart 277
Summary 278
Chapter 10 Recursive Data Structures 279
One-to-Many Recursion: The Organizational Chart 280
The Data Accordion 290
Many-to-Many Recursion 298
The Product Database 299
Navigating the Hierarchy 305
Calculating Inventory Levels 307
Quantity Received 307
Quantity Produced 309
Quantity Used in Production 311
Quantity Shipped 312
Finishing the Job 313
Extra Credit 313
Summary 315
Chapter 11 Complex Calculations 317
Text Manipulation Tools 318
Number Functions 327
Date and Time Formulas 336
Summary 349
Appendix A References 351
Appendix B Keyboard Shortcuts and Other Time-Saving Techniques 355
Appendix C Glossary 363
Index 373
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)