Muutke küpsiste eelistusi

FileMaker Pro 10 2nd edition [Pehme köide]

3.70/5 (40 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 809 pages, kõrgus x laius x paksus: 231x178x43 mm
  • Sari: Missing Manuals
  • Ilmumisaeg: 03-Mar-2009
  • Kirjastus: O'Reilly Media
  • ISBN-10: 0596154232
  • ISBN-13: 9780596154233
Teised raamatud teemal:
  • Pehme köide
  • Hind: 43,68 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 51,39 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
FileMaker Pro 10 2nd editionSuurem pilt
  • Formaat: Paperback / softback, 809 pages, kõrgus x laius x paksus: 231x178x43 mm
  • Sari: Missing Manuals
  • Ilmumisaeg: 03-Mar-2009
  • Kirjastus: O'Reilly Media
  • ISBN-10: 0596154232
  • ISBN-13: 9780596154233
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780596154233.html
Märksõnad:
Describes the fundamentals of FileMaker Pro 10, covering such topics as editing records, creating layouts, calculations, scripting, and security. Designed for FileMaker Pro 10 users who are unaware of the advanced features of this database management software, this comprehensive guide employs clear step-by- step instructions on how to accelerate data entry, publish professional reports and automate the more repetitive functions. Prosser and Coffey are both FileMaker consultants and software developers, and they explain the basics of installation, implementation, layouts, multiple tables and relationships, calculations, scripting and security. Instructions are also given for posting databases online and integrating with such programs as Bento, Excel and MySQL. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com) Clear, thorough, and accessible, FileMaker Pro 9: The Missing Manual helps users get in, build a database, and get the results they need, whether they are running a business, pursuing a hobby, or planning their retirement. Its the ideal guide for non-technical and experienced folks alike. 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 youre running a business, pursuing a hobby, or planning your retirement. Its the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. Youll 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. With this book, you will: 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 Outfit your database for the Web, and import and export data to other formats Youll also get objective advice on which features are really useful, and which arent. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.
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 Database
185(1)
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 a Button
270(2)
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 Relationships
334(1)
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 Portal
345(6)
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 File
376(1)
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 Criterion
385(2)
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 Dialog Box
415(5)
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, Movies, and Files
455(1)
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 End If
513(6)
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 Records
545(1)
Navigating Among Records
546(3)
Opening, Reverting, and Committing Records
549(3)
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 Script Step
609(11)
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 Privileges
657(1)
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 Source
670(2)
Adding SQL Tables to a Filemaker Database
672(4)
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 File
691(1)
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
Susan Prosser is a reformed journalist who's stopped trying to bring information to the people and now helps them manage the data they already have. Susan is a FileMaker Certified Developer and has developed FileMaker databases for 12 years, but returns to her roots by training and writing curriculum for other developers.Geoff Coffey has been helping people solve problems with FileMaker Pro for over 10 years. He is a partner at Six Fried Rice (http://sixfriedrice.com/), a FileMaker Pro consulting and training firm based in Phoenix, Arizona. Six Fried Rice brings the power and simplicity of FileMaker Pro to individuals, workgroups, enterprise, and the web through world-class training, expert advice, and custom development. He lives in downtown Phoenix with his wife of 14 years and his two daughters, Isabel (9) and Sophia (5). If you're a FileMaker fan, you can reach Geoff any time at geoff@sixfriedrice.com.