FileMaker Pro 10 : The Missing Manual (Missing Manual) (1ST)

個数:

FileMaker Pro 10 : The Missing Manual (Missing Manual) (1ST)

  • 提携先の海外書籍取次会社に在庫がございます。通常2週間で発送いたします。
    重要ご説明事項
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合、分割発送となる場合がございます。
    3. 美品のご指定は承りかねます。
  • ≪洋書のご注文につきまして≫ 「海外取次在庫あり」および「国内仕入れ先からお取り寄せいたします」表示の商品でも、納期の目安期間内にお届けできないことがございます。あらかじめご了承ください。

  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 809 p.
  • 言語 ENG,ENG
  • 商品コード 9780596154233
  • DDC分類 005.7565

Full Description


The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it - especially with this book as your guide. Clear, thorough, and accessible, "FileMaker Pro 10: The Missing Manual" helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest time-saving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker.This book helps you: get your first database running in minutes and perform basic tasks right away; catalog people, processes, and things with streamlined data entry and sorting tools; use your data to generate reports, correspondence, and other documents with ease; create, connect, and manage multiple tables and set up complex relationships that display just the data you need; crunch numbers, search text, or pin down dates and times with dozens of built-in formulas; and, outfit your database for the Web, and import and export data to other formats. You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need "FileMaker Pro 10: The Missing Manual" - the book that should have been in the box.

Table of Contents

The Missing Credits                                xvii
Introduction 1 (14)
Part One: Getting Started with FileMaker
Working with a Database 15 (32)
A Very Quick Database Tour 15 (4)
Content Area 16 (1)
Scroll Bars 16 (2)
Zoom Controls 18 (1)
Understanding Modes 18 (1)
Opening and Closing Database Files 19 (3)
Opening a Database 21 (1)
Closing a Database 21 (1)
Adding Records to Your Database 22 (6)
Creating a Record 22 (1)
Entering Data 22 (1)
Fields for Lots of Text 23 (2)
Deleting Records 25 (2)
Understanding Browse Mode Error Messages 27 (1)
Navigating Your Database 28 (3)
Navigating Record by Record 29 (1)
Keyboard Shortcuts 30 (1)
Finding Records 31 (4)
Understanding Find Mode Error Messages 34 (1)
Sorting Records 35 (3)
Understanding Sorting 36 (1)
Beyond the Simple Sort 37 (1)
Multiple Sort Fields 37 (1)
Same Database, Different Views 38 (5)
Viewing a List 39 (1)
Viewing a Table 39 (1)
Creating a New Window 40 (1)
Hiding Windows 40 (1)
Automatically Arranging Windows 41 (2)
Saving Your Database 43 (4)
Saving a Copy of Your Database 44 (1)
Saving a Clone of Your Database 45 (1)
Using FileMaker's Help Menu 45 (2)
Organizing and Editing Records 47 (42)
Views 47 (5)
Form View 48 (1)
List View 48 (1)
Table View 48 (4)
Advanced Find Techniques 52 (13)
Modify Last Find 53 (1)
Multiple Requests 53 (1)
Finding by Omitting 54 (2)
Constraining and Extending the Found Set 56 (2)
Refining Searches with Find Operators 58 (4)
Using the Find Pop-up Menu 62 (3)
Editing What's in Your Fields 65 (6)
Drag-and-drop Editing 66 (1)
Using the Replace Command 67 (1)
Find and Replace 68 (3)
Changing Text Appearance 71 (5)
Text Formatting 72 (1)
Paragraph Formatting 73 (1)
The Text Ruler 74 (1)
Formatting Tabs 74 (2)
Checking Spelling 76 (3)
Spell Checking with Menu Commands 76 (2)
Spell Checking as You Type 78 (1)
Managing Spelling Dictionaries 78 (1)
Printing and Preview Mode 79 (3)
Beyond Text: Container Fields 82 (7)
Pictures 83 (1)
QuickTime 84 (1)
Sound 85 (2)
File 87 (2)
Building a New Database 89 (36)
Tables and Fields 89 (4)
Tables: The Foundation of Your Database 90 (1)
Figuring Out What Fields You Need 90 (3)
Defining Fields 93 (11)
Changing a Field's Name 96 (1)
Duplicating a Field 97 (1)
Deleting a Field 97 (1)
Reordering the Field List 97 (2)
Printing Field Definitions 99 (1)
Field Types 99 (5)
Advanced Field Options 104 (21)
Auto-Enter Options 104 (5)
Validation Options 109 (3)
Validation Requirements 112 (4)
Storage Options 116 (1)
Indexing 117 (8)
Part Two: Layouts
Understanding Layouts 125 (62)
What Is a Layout? 126 (6)
Types of Layouts 126 (2)
Making a New Layout 128 (3)
Views 131 (1)
The Layout Bar 132 (4)
Renaming a Layout 133 (2)
Found Sets and Layouts 135 (1)
What Makes a Layout 136 (5)
Part Types 136 (3)
Layout Objects 139 (2)
Customizing a Layout 141 (43)
The Look 141 (2)
Layout Mode 143 (1)
The Status Toolbar 144 (1)
Arranging Parts 144 (3)
Laying Out Fields and Labels 147 (21)
Autoresize 168 (5)
Decorating a Layout 173 (11)
Determining Tab Order 184 (3)
Customizing the Tab Order 184 (1)
Fixing the Tab Order in the People 185 (1)
Database
Preserving the Automatic Order 186 (1)
Building Basic Layouts 187 (50)
The Lowdown on Layout Types 187 (3)
Standard Form 188 (1)
Columnar List/Report 188 (1)
Table View 188 (1)
Labels or Vertical Labels 188 (1)
Envelope 188 (2)
Blank Layout 190 (1)
Creating a Layout from Scratch 190 (16)
Adding a New Layout 190 (2)
Matching Two Layout 192 (3)
Set Up the Body 195 (8)
Setting Layout View 203 (1)
Setting Anchors in List Layouts 204 (2)
Conditional Formatting 206 (5)
Conditional Formatting of Fields 207 (1)
Conditional Formatting of Text Objects 208 (3)
Advanced Conditional Formatting 211 (1)
Removing Conditional Formatting 211 (1)
Web Viewer Objects 211 (6)
Putting a Web Viewer on a Layout 212 (2)
Web Viewer Options 214 (3)
Adding Tab Controls 217 (7)
Creating a Tab Control 218 (3)
Editing Tab Controls 221 (2)
Deleting a Tab Control 223 (1)
Creating Layouts for Printing 224 (13)
Visualize the Result in Preview Mode 224 (1)
Print Margins 225 (2)
Columns 227 (2)
Sliding Layout Objects 229 (6)
Setting Layout Order 235 (1)
Layout Setup 236 (1)
Advanced Layouts and Reports 237 (58)
Value Lists 237 (5)
Creating Value Lists 238 (3)
Editing Value Lists 241 (1)
Advanced Field Controls 242 (12)
Edit Box 242 (1)
Drop-Down List 243 (2)
Pop-Up Menu 245 (1)
Checkbox Set 246 (1)
Radio Button Set 247 (1)
Drop-Down Calendar 247 (3)
Auto-Complete 250 (2)
Repetitions 252 (1)
Display Data From 253 (1)
Format the Number/Date/Time/Graphic 254 (13)
Number Formatting 254 (5)
Date Formatting 259 (3)
Time Formatting 262 (2)
Timestamp Formatting 264 (1)
Graphic Formatting 264 (3)
Adding Buttons 267 (12)
Creating Buttons with the Button Tool 268 (2)
Turning an Existing Layout Object into 270 (2)
a Button
Making a Button Not a Button 272 (1)
Button Actions 273 (6)
Summary Fields and Sub-Summary Parts 279 (16)
Summary Fields 279 (2)
Using Sub-Summary Parts 281 (3)
Leading and Trailing Grand Summaries 284 (2)
Sub-Summary Parts and Printing 286 (1)
Other Summary Field Types 287 (8)
Part Three: Multiple Tables and Relationships
Adding Multiple Tables and Relationships 295 (46)
Relational Databases Explained 295 (2)
Modeling Your Database 297 (18)
Choosing Entities 297 (3)
Finding Relationships 300 (5)
The Entity-Relationship Diagram 305 (5)
Keys 310 (3)
Join Tables 313 (2)
Creating a Relational Database 315 (17)
Creating the Tables 316 (1)
Creating the Fields 317 (4)
Defining the Relationships 321 (3)
Cleaning Up the Relationship Graph 324 (5)
Finishing the Field Definitions 329 (3)
Relational Databases 332 (9)
One Table Occurrence, One Found Set 332 (1)
Viewing Related Fields 333 (1)
Adding or Editing Data with 334 (1)
Relationships
Editing Related Data 335 (6)
Advanced Relationship Techniques 341 (54)
Creating Related Records 341 (15)
Value Lists Based on Fields 342 (3)
Creating Related Records Through a 345 (6)
Portal
Navigating Between Related Records 351 (5)
Table Occurrences 356 (6)
Understanding Table Occurrences 356 (2)
Relationships with Table Occurrences 358 (4)
Managing Data with Data Tunneling 362 (7)
Understanding Data Tunneling 363 (1)
Understanding Table Occurrence Groups 364 (3)
Managing the Relationships Graph 367 (2)
Building a Data Tunneling Interface 369 (6)
Creating a Global Field 369 (1)
Creating a New Table Occurrence Group 370 (2)
Building a Global Field Layout 372 (3)
Connecting Database Files 375 (5)
Adding a Table Occurrence from Another 376 (1)
File
Defining Data Sources Using a Path 377 (3)
Lookups 380 (5)
Creating Lookups 382 (2)
Using a Relookup 384 (1)
Advanced Relationships 385 (10)
Relationships with More than One 385 (2)
Criterion
Other Relationship Operators 387 (1)
Creating the Invoice Finder 388 (7)
Part Four: Calculations
Understanding Calculations 395 (32)
Understanding Calculations 395 (4)
Creating a Calculation 397 (2)
The Structure of a Calculation 399 (13)
Using Fields in Calculations 401 (1)
Using Constants in Calculations 402 (1)
Using Operators in Calculations 403 (4)
Functions 407 (4)
Expressions 411 (1)
Creating a Calculation Field 412 (8)
Understanding the Specify Calculation 415 (5)
Dialog Box
Auto-Enter Calculations 420 (1)
Validate Data Entry with a Calculation 421 (2)
Replacing Data Using a Calculation 423 (2)
Comments 425 (2)
More Calculations and Data Types 427 (30)
Number Crunching Calculations 427 (5)
Number Operators 428 (1)
Number Function Types 428 (1)
Using Number Functions 428 (4)
Going Beyond Basic Calculations 432 (2)
Preparing the Data 432 (1)
Building the Calculation Fields 433 (1)
Constructing the Calculation 433 (1)
Text Calculations 434 (14)
The Concatenation Operator 436 (1)
Text Functions 436 (9)
Text Formatting Functions 445 (3)
Date and Time Calculations 448 (6)
Math with Dates and Times 449 (2)
Parsing Dates and Times 451 (1)
Calculations that Create Dates and Times 452 (2)
Containers in Calculations 454 (3)
Calculations with Pictures, Sounds, 455 (1)
Movies, and Files
Calculations with References 455 (2)
Advanced Calculations 457 (22)
Conditional Formatting Formulas 457 (5)
Understanding Boolean Functions 458 (2)
Using the Self() Function 460 (2)
Using Storage Options 462 (4)
Stored and Unstored Calculation Fields 462 (4)
Global Calculation Fields 466 (1)
Logical Functions 466 (7)
Conditional Functions 466 (4)
Constructing a Conditional Calculation 470 (3)
The Let() Function and Variables 473 (6)
Defining Calculation Variables 473 (2)
The Life of a Variable 475 (2)
Nesting Let() Functions 477 (2)
Extending Calculations 479 (14)
Custom Functions 479 (8)
Defining a Custom Function 481 (2)
Editing Custom Functions 483 (1)
Recursion 484 (3)
Plug-Ins 487 (6)
Installing Plug-ins 488 (1)
Old and New Plug-ins 488 (1)
Finding Plug-ins 489 (1)
Creating Your Own Plug-ins 490 (3)
Part Five: Scripting
Understanding Scripts 493 (36)
Your First Script 494 (9)
Preparing the Database 494 (1)
Planning Your Script 495 (1)
Creating Your Script 495 (5)
Improving Your Script 500 (3)
The Importance of the Layout 503 (2)
When to Switch 504 (1)
Running Scripts 505 (5)
The Scripts Menu 506 (1)
Buttons 507 (1)
Script Triggers 507 (1)
Opening and Closing Scripts 508 (1)
Timer Scripts 509 (1)
Organizing Your Scripts 510 (2)
Creating Script Folders 510 (2)
Creating Menu Separators 512 (1)
Branching and Looping in Scripts 512 (9)
Branching with If, Else If, Else, and 513 (6)
End If
Testing Multiple Conditions 519 (1)
Looping 520 (1)
Script Triggers 521 (8)
Layout Triggers 522 (2)
Object Triggers 524 (2)
A Simple Script Trigger 526 (3)
Exploring Script Steps 529 (46)
Go to Layout 529 (1)
Scripting for Fields 530 (14)
Navigating Fields 531 (1)
Editing Commands 532 (1)
Selecting Text 532 (1)
Editing Field Data 533 (5)
A Field Script in Action 538 (3)
Other Steps That Work with Fields 541 (3)
Working with Records 544 (10)
Creating, Duplicating, and Deleting 545 (1)
Records
Navigating Among Records 546 (3)
Opening, Reverting, and Committing 549 (3)
Records
Copying Records 552 (1)
Working with Portals 553 (1)
Finding Records 554 (9)
Performing People's Find Requests 554 (4)
Static Find Requests 558 (2)
Dynamic Find Requests 560 (1)
Constraining and Extending the Found Set 561 (1)
Omitting Records 562 (1)
Modify Last Find 563 (1)
Sorting Records 563 (1)
Sorting Records Automatically 563 (1)
Working with Windows 564 (5)
Creating Windows 564 (1)
Bringing a Window to the Front 565 (1)
Closing a Window 566 (1)
Moving and Resizing Existing Windows 566 (2)
Other Window-Related Script Steps 568 (1)
Working with Files 569 (2)
Opening and Closing Files 570 (1)
Save a Copy As 570 (1)
Other File-Related Script Steps 571 (1)
Printing 571 (1)
Other Script Steps 572 (3)
Open URL 572 (1)
Dial Phone 572 (1)
Set Web Viewer 572 (1)
Execute SQL 573 (1)
Flush Cache to Disk 574 (1)
Exit Application 574 (1)
Advanced Scripting 575 (56)
Commenting Scripts 575 (2)
Communicating with Database Users 577 (5)
Showing a Simple Message 578 (1)
Asking a Simple Question 578 (2)
Asking a More Complex Question 580 (2)
Organizing Complex Scripts 582 (10)
The Perform Script Script Step 582 (1)
Halt Script and Exit Script 583 (3)
Script Parameters 586 (5)
Script Variables 591 (1)
Handling Errors 592 (4)
The Set Error Capture Script Step 593 (1)
The Get (LastError) Function 594 (2)
The Allow User Abort Script Step 596 (1)
Putting a Complex Script Together 596 (25)
Planning the Script 597 (1)
Considering Exceptions 597 (2)
Creating Subscripts 599 (3)
Finishing the Subscripts 602 (7)
Adding a Script Parameter to a Perform 609 (11)
Script Step
Testing Scripts 620 (1)
Advanced Script Triggers 621 (10)
Install OnTimer Script 621 (1)
Keystroke Triggers 622 (9)
Part Six: Security and Integration
Adding Security 631 (30)
How Security Works 631 (2)
Who Gets Access 632 (1)
What They Can Do 632 (1)
Privilege Sets 633 (16)
Understanding Privilege Sets 634 (1)
Understanding Individual Privileges 635 (14)
Managing Accounts 649 (4)
Adding a New Account 651 (1)
External Authentication 652 (1)
Extended Privileges 653 (3)
Creating an Extended Privilege 654 (1)
Checking for an Extended Privilege 655 (1)
Assigning Extended Privileges 655 (1)
Scripts and Security 656 (5)
Detecting Privileges in a Script 656 (1)
Handling Security Errors 657 (1)
Running Scripts with Full Access 657 (1)
Privileges
Managing Security with Scripts 658 (3)
Sharing Data with Other Systems 661 (42)
Sharing Your Data with Others 661 (5)
Save/Send Records As 662 (4)
External SQL Sources 666 (11)
Setting Up ODBC 667 (3)
Connecting FileMaker to a SQL Data 670 (2)
Source
Adding SQL Tables to a Filemaker 672 (4)
Database
Using SQL Tables 676 (1)
Exporting Data 677 (6)
Grouped Exports 680 (3)
Importing Data 683 (8)
Importing Over Existing Data 688 (2)
Creating Tables on Import 690 (1)
Creating a New Database from an Import 691 (1)
File
Converting Older FileMaker Files 691 (1)
Import Data Sources 691 (9)
File 692 (1)
Folder 692 (2)
Digital Camera 694 (1)
XML Data Source 695 (1)
Bento Data Source 696 (2)
ODBC Data Sources 698 (2)
Importing and Exporting in a Script 700 (3)
Save Records Script Steps 700 (1)
The Import Records Script Step 701 (1)
The Export Records Script Step 701 (2)
Sharing Your Database 703 (30)
FileMaker Network Sharing 704 (5)
Setting Up a Host Computer 704 (2)
Opening a Shared File 706 (1)
The Open Remote File Dialog Box 707 (2)
Sharing over the Internet 709 (6)
Turning on Web Sharing 709 (3)
Connecting from a Web Browser 712 (2)
Custom Home Page 714 (1)
FileMaker Server 715 (15)
File Compatibility 716 (1)
Installing FileMaker Server 717 (3)
Administering FileMaker Server 720 (9)
Testing Your Server 729 (1)
Server Hardware 730 (3)
Applying Developer Utilities 733 (38)
Copying and Pasting Database Structure 734 (2)
Importing Tables and Fields 734 (1)
Copying and Pasting Tables 735 (1)
Copying and Pasting Fields 735 (1)
Copying Scripts and Script Steps 736 (1)
Script Debugger 736 (7)
Controlling Script Execution 737 (3)
Breakpoints 740 (1)
Examining Errors 740 (1)
Pause on Error 741 (1)
Active Scripts 742 (1)
Working with the Debugger Window 743 (1)
The Data Viewer 743 (3)
The Current Tab 744 (1)
The Watch Tab 745 (1)
Disable Script Steps 746 (1)
The Database Design Report 747 (5)
Generating the DDR 748 (1)
Using the DDR 749 (2)
Finding Broken Elements with the DDR 751 (1)
Tooltips 752 (1)
Custom Menus 753 (8)
Editing a Menu 755 (3)
Creating a New Menu 758 (1)
Removing a Menu 759 (1)
Installing Custom Menu Sets 760 (1)
Developer Utilities 761 (10)
Using the Developer Utilities 762 (5)
Delivering a Runtime Solution 767 (4)
Part Seven: Appendixes
Appendix A: Getting Help 771 (8)
Appendix B: FileMaker Error Codes 779 (8)
Index 787