Muutke küpsiste eelistusi

Filemaker Pro 9 the Missing Manual [Pehme köide]

3.92/5 (24 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 778 pages, kõrgus x laius: 232x178 mm, Illustrations
  • Ilmumisaeg: 11-Sep-2007
  • Kirjastus: O'Reilly Media
  • ISBN-10: 0596514131
  • ISBN-13: 9780596514136
Teised raamatud teemal:
  • Pehme köide
  • Hind: 47,79 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Filemaker Pro 9 the Missing ManualSuurem pilt
  • Formaat: Paperback / softback, 778 pages, kõrgus x laius: 232x178 mm, Illustrations
  • Ilmumisaeg: 11-Sep-2007
  • Kirjastus: O'Reilly Media
  • ISBN-10: 0596514131
  • ISBN-13: 9780596514136
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780596514136.html
Describes the fundamentals of FileMaker Pro 9, covering such topics as editing records, creating layouts, calculations, scripting, and security.

Appropriate for the beginner, especially executives, this guide explains how to enter data into a FileMaker Pro database, organize records, create layouts for reports, connect and manage multiple tables, and perform mathematical calculations. The closing chapters describe the scripting, security, integration, and development tools available in FileMaker Pro Advanced edition. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)

FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto.

The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual, you can:

  • 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.
  • Learn to use layout tools to organize the appearance of your database.
  • Use your data to generate reports, correspondence and other documents with ease.
  • Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need.
  • Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas.
  • Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language.
  • Protect your database with passwords and set up privileges to determine what others can do once they gain entry.
  • Outfit your database for the Web and import and export data to other formats.
Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box.
The Missing Credits xvii
Introduction 1(14)
Part One: Introduction to FileMaker Pro
Your First Database
15(28)
A Very Quick Database Tour
15(5)
Content Area
16(1)
Mode Pop-up Menu
16(4)
Creating a New Database
20(1)
Choosing a Starter Solution
20(1)
Opening and Closing Database Files
21(3)
Opening a Database
22(2)
Closing a Database
24(1)
Saving Your Databases
24(2)
Saving a Copy of Your Database
25(1)
Adding Records to Your Database
26(7)
Creating a Record
27(1)
Editing a Record
27(2)
Adding More Records
29(4)
Navigating Your Database
33(6)
Navigating Record by Record
33(1)
Keyboard Shortcuts
34(1)
Finding Records
35(4)
Same Database, Multiple Windows
39(4)
Automatically Arranging Windows
40(1)
Hiding Windows
41(2)
Organizing and Editing Records
43(48)
Views
43(3)
Form View
44(1)
List View
44(1)
Table View
44(2)
Advanced Find Mode
46(10)
Finding by Omitting
46(1)
Constraining and Extending the Found Set
47(2)
Refining Searches with Find Symbols
49(4)
Refining a Found Set with Omit Commands
53(3)
Changing Multiple Records
56(1)
Sorting Records
57(3)
Multiple Sort Fields
58(2)
Editing What's in Your Fields
60(11)
Find and Replace
60(3)
Fields for Lots of Text
63(1)
Drag-and-drop Editing
64(2)
Text Formatting
66(5)
Paragraph Formatting
71(6)
Align Text
71(1)
Line Spacing
72(1)
The Text Ruler
72(1)
Detailed Formatting in the Paragraph Box
73(1)
Tabs
74(3)
Beyond Text: Container Fields
77(6)
Pictures
78(1)
QuickTime
79(1)
Sound
79(2)
File
81(2)
Checking Spelling
83(4)
Spell Checking in One Pass
83(2)
Spell Checking as You Type
85(1)
Managing Spelling Dictionaries
85(2)
Printing and Preview Mode
87(4)
Building a New Database
91(36)
Tables and Fields
91(3)
Tables: The Foundation of Your Database
92(1)
Figuring Out What Fields You Need
92(2)
Defining Fields
94(11)
Changing a Field's Name
96(2)
Duplicating a Field
98(1)
Deleting a Field
98(1)
Reordering the Field List
98(2)
Printing Field Definitions
100(1)
Field Types
100(5)
Advanced Field Options
105(18)
Auto-Enter Options
105(6)
Validation Options
111(2)
Validation Requirements
113(4)
Storage Options
117(2)
Indexing
119(4)
Bringing It All Together
123(4)
Part Two: Layout Basics
Layout Basics
127(54)
What Is a Layout?
128(2)
Types of Layouts
128(2)
Switching Between Layouts
130(1)
What Makes a Layout
131(7)
Layout Parts
131(5)
Layout Objects
136(2)
Layout Mode
138(43)
The Status Area
139(1)
View Options
140(4)
Layout Setup
144(3)
Layout Tools
147(4)
Working with Parts
151(2)
Adding and Editing Text
153(6)
Formatting Fields
159(2)
Field Controls
161(4)
Laying Out the Layout
165(5)
Adding a Dividing Line Between Layout Parts
170(1)
Finishing Touches
171(1)
Autoresize
172(7)
Wrapping up
179(2)
Creating Layouts
181(38)
The Lowdown on Layouts
181(3)
Standard Form
181(1)
Columnar List/Report
182(1)
Table View
182(1)
Labels or Vertical Labels
182(1)
Envelope
183(1)
Blank Layout
184(1)
Creating a Layout from Scratch
184(16)
Adding a New Layout
184(2)
Set Up the Header
186(3)
Set Up the Body
189(7)
Setting Layout View
196(2)
Setting Anchors in List Layouts
198(2)
Creating Layouts for Reports
200(19)
Visualize the Result Preview Mode
200(2)
Creating a Report Layout with an Assistant
202(4)
Print Margins
206(1)
Improving the Report Layout
207(3)
Sliding Layout Objects
210(7)
Setting Layout Order
217(2)
Advanced Layouts and Reports
219(84)
Value Lists
219(5)
Creating Value Lists
220(4)
Editing Value Lists
224(1)
Advanced Field Controls
224(12)
Edit Box
226(1)
Drop-down List
226(2)
Pop-up Menu
228(1)
Checkbox Set
229(1)
Radio Button Set
230(1)
Drop-down Calendar
231(1)
Auto-Complete
232(2)
Repetitions
234(1)
Display Data From
235(1)
Field Behavior
236(2)
Field Entry
236(1)
Select Entire Contents of Field on Entry
237(1)
Input Method
237(1)
Field-level Visual Spell Checking
237(1)
Go To Next Field Using
238(1)
Conditional Formatting
238(6)
Conditional Formatting of Fields
239(2)
Conditional Formatting of Text Objects
241(1)
Multiple Conditions
242(1)
More Formatting Options
243(1)
Removing Conditional Formatting
244(1)
Print-related Layout Options
244(2)
Non-printing Objects
244(1)
Columns
244(2)
Format the Number/Date/Time/Graphic
246(12)
Number Formatting
246(4)
Date Formatting
250(3)
Time Formatting
253(1)
Timestamp Formatting
254(1)
Graphic Formatting
255(3)
Adding Buttons
258(11)
Creating Buttons with the Button Tool
259(1)
Turning an Existing Layout Object into a Button
260(2)
Making a Button Not a Button
262(1)
Button Actions
263(6)
Tab Order
269(3)
Buttons in the Tab Order
270(1)
Customizing the Tab Order
270(1)
Fixing the Tab Order in the People Database
271(1)
Preserving the Automatic Order
272(1)
Web Viewer Controls
272(7)
Putting a Web Viewer on a Layout
273(4)
Web Viewer Options
277(2)
Tab Controls
279(7)
Creating a Tab Control
280(3)
Editing Tab Controls
283(3)
Deleting a Tab Control
286(1)
Reports and Summary Fields
286(17)
Summary Fields
287(1)
Creating a Summary Report
288(8)
Other Summary Field Types
296(7)
Part Three: Multiple Tables and Relationships
Multiple Tables and Relationships
303(46)
Relational Databases Explained
303(2)
Modeling Your Database
305(18)
Choosing Entities
305(4)
Finding Relationships
309(3)
The Entity-relationship Diagram
312(6)
Keys
318(3)
Join Tables
321(2)
Creating a Relational Database
323(16)
Creating the Tables
323(1)
Creating the Fields
324(4)
Defining the Relationships
328(3)
Cleaning Up the Relationship Graph
331(6)
Finishing the Field Definitions
337(2)
Relational Databases
339(10)
One Table Occurrence, One Found Set
339(1)
Viewing Related Fields
340(1)
Adding or Editing Data with Relationships
341(1)
Editing Related Data
342(7)
Advanced Relationship Techniques
349(52)
Creating Related Records
349(13)
Value Lists Based on Fields
350(2)
Creating Related Records Through a Portal
352(6)
Navigating Between Related Records
358(4)
Table Occurrences
362(6)
Understanding Table Occurrences
362(3)
Relationships with Table Occurrences
365(3)
Managing Data with Data Tunneling
368(8)
Understanding Data Tunneling
369(2)
Understanding Table Occurrence Groups
371(2)
Managing the Relationships Graph
373(3)
Building a Data Tunneling Interface
376(6)
Creating a Global Field
376(1)
Creating a New Table Occurrence Group
376(3)
Building a Global Field Layout
379(3)
Connecting Databases
382(4)
Adding a Table Occurrence from Another File
382(1)
Defining Data Sources Using a Path
383(3)
Lookups
386(5)
Creating Lookups
387(3)
Triggering a Lookup
390(1)
Advanced Relationships
391(10)
Relationships with More than One Criterion
391(2)
Other Relationship Operators
393(1)
Creating the Invoice Finder
394(7)
Part Four: Introduction to Calculations
Introduction to Calculations
401(30)
Understanding Calculations
401(3)
Creating a Calculation
402(2)
The Structure of a Calculation
404(13)
Fields
406(1)
Constants
406(2)
Operators
408(4)
Functions
412(4)
Expressions
416(1)
Creating a Calculation Field
417(7)
The Specify Calculation Dialog Box
419(5)
Auto-Enter Calculations
424(2)
Validate Data Entry with a Calculation
426(1)
Replacing Data Using a Calculation
427(2)
Comments
429(2)
Calculations and Data Types
431(28)
Number Crunching Calculations
431(2)
Number Operators
431(1)
Number Function Types
432(1)
Precision
432(1)
Going Beyond Basic Calculations
433(3)
Preparing the Data
433(1)
Building the Calculation Fields
434(1)
Constructing the Calculation
434(2)
Text Parsing Calculations
436(13)
The Concatenation Operator
436(2)
Text Function Types
438(1)
Text Functions
438(7)
Text Formatting Functions
445(4)
Date and Time Calculations
449(6)
How FileMaker Looks at Time
449(1)
Math with Dates and Times
450(2)
Parsing Dates and Times
452(1)
Calculations that Create Dates and Times
453(2)
Aggregate Calculations
455(2)
Numerical Aggregate Functions
456(1)
The List Function
456(1)
Containers in Calculations
457(2)
Calculations with Pictures, Sounds, Movies, and Files
457(1)
Calculations with References
457(2)
Advanced Calculations
459(22)
Conditional Formatting
459(4)
Understanding Boolean Functions
460(3)
Using the Self Function
463(1)
Stored, Unstored, and Global Fields
464(4)
Stored and Unstored Calculation Fields
464(4)
Global Calculation Fields
468(1)
Logical Functions
468(7)
Conditional Functions
468(4)
Constructing a Conditional Calculation
472(3)
The Let Function and Variables
475(6)
Defining Calculation Variables
475(2)
The Life of a Variable
477(2)
Nesting Let Functions
479(2)
Extending Calculations
481(12)
Custom Functions
482(5)
Defining a Custom Function
482(2)
Editing Custom Functions
484(1)
Recursion
484(3)
Plug-ins
487(6)
Installing Plug-ins
488(2)
Old and New Plug-ins
490(1)
Finding Plug-ins
490(1)
Creating Your Own Plug-ins
490(3)
Part Five: Scripting
Scripting Basics
493(28)
Your First Script
493(9)
Preparing the Database
494(1)
Planning Your Script
494(1)
Creating Your Script
495(4)
Improving Your Script
499(3)
The Importance of the Layout
502(2)
When to Switch
503(1)
Running Scripts
504(3)
The Scripts Menu
504(1)
Defining Buttons
504(3)
Opening and Closing Scripts
507(1)
Understanding ScriptMaker's Windows
507(2)
Organizing Your Scripts
509(3)
Creating Script Groups
510(2)
Creating Menu Separators
512(1)
Branching and Looping in Scripts
512(9)
Branching with If, Else If, Else, and End If
512(5)
Testing Multiple Conditions
517(1)
Looping
518(3)
Script Steps
521(44)
Go to Layout
521(1)
Scripting for Fields
522(13)
Navigating Fields
523(1)
Editing Commands
523(1)
Selecting Text
524(1)
Editing Field Data
525(3)
A Field Script in Action
528(3)
Other Steps That Work with Fields
531(4)
Working with Records
535(9)
Creating, Duplicating, and Deleting Records
535(1)
Navigating Among Records
536(4)
Opening, Reverting, and Committing Records
540(2)
Copying Records
542(1)
Working with Portals
543(1)
Finding Records
544(8)
Performing the User's Find Requests
545(2)
Static Find Requests
547(2)
Dynamic Find Requests
549(1)
Constraining and Extending the Found Set
550(1)
Omitting Records
550(1)
Modify Last Find
551(1)
Save Records as
551(1)
Sorting Records
552(1)
Working with Windows
553(5)
Creating Windows
553(1)
Bringing a Window to the Front
554(1)
Closing a Window
554(1)
Moving and Resizing Existing Windows
554(2)
Other Window-related Script Steps
556(2)
Working with Files
558(2)
Opening and Closing Files
559(1)
Save a Copy As
559(1)
Other File-Related Script Steps
559(1)
Printing
560(1)
Other Script Steps
560(5)
Open URL
560(1)
Dial Phone
561(1)
Set Web Viewer
561(1)
Send Email
561(1)
Execute SQL
562(1)
Flush Cache to Disk
563(1)
Exit Application
563(2)
Advanced Scripting
565(44)
Commenting Scripts
565(1)
Asking and Telling the User
566(5)
Showing a Simple Message
567(1)
Asking a Simple Question
567(1)
Asking a Not-so-simple Question
568(3)
Organizing Complex Scripts
571(9)
The Perform Script Script Step
572(1)
Halt Script and Exit Script
573(2)
Script Parameters
575(3)
Script Variables
578(2)
Handling Errors
580(4)
The Set Error Capture Script Step
581(1)
The Get (LastError) Function
582(1)
The Allow User Abort Script Step
583(1)
Putting a Complex Script Together
584(25)
Planning the Script
584(1)
Considering Exceptions
585(2)
Creating Subscripts
587(3)
Finishing the Subscripts
590(4)
Adding a Script Parameter to a Perform Script Step
594(10)
Testing Scripts
604(5)
Part Six: Security and Integration
Security
609(28)
How Security Works
609(2)
Who Gets Access
610(1)
What They Can Do
610(1)
Privilege Sets
611(15)
Managing Privilege Sets
612(2)
Other Privileges
614(1)
Data Access and Design Privileges
615(11)
Managing Accounts
626(4)
Adding a New Account
627(2)
External Authentication
629(1)
Extended Privileges
630(3)
Creating an Extended Privilege
631(1)
Checking for an Extended Privilege
631(1)
Assigning Extended Privileges
632(1)
Scripts and Security
633(4)
Detecting Privileges in a Script
633(1)
Handling Security Errors
634(1)
Running Scripts with Full Access Privileges
634(1)
Managing Security with Scripts
634(3)
Sharing Data with Other Systems
637(38)
Sharing Your Data with Others
637(4)
Save/Send Records As
638(3)
External SQL Sources
641(10)
Setting Up ODBC
641(5)
Connecting FileMaker to a SQL Data Source
646(1)
Adding SQL Tables to a FileMaker Database
647(3)
Using SQL Tables
650(1)
Exporting Data
651(6)
Importing Data
657(8)
Importing Over Existing Data
662(2)
Creating Tables on Import
664(1)
Creating a New Database from an Import File
664(1)
Converting Older FileMaker Files
665(1)
Import Data Sources
665(7)
File
665(1)
Folder
666(1)
Digital Camera
667(2)
XML Data Source
669(2)
ODBC Data Sources
671(1)
Importing and Exporting in a Script
672(3)
Save Records Script Steps
673(1)
The Import Records Script Step
674(1)
The Export Records Script Step
674(1)
Sharing Your Database
675(28)
FileMaker Network Sharing
676(5)
Setting Up a Host Computer
676(2)
Opening a Shared File
678(1)
The Open Remote File Dialog Box
679(2)
Sharing over the Internet
681(5)
Turning on Web Sharing
681(3)
Connecting from a Web Browser
684(1)
Custom Home Page
685(1)
FileMaker Server
686(15)
File Compatibility
687(1)
Installing FileMaker Server
688(5)
Administering FileMaker Server
693(7)
Testing Your Server
700(1)
Server Hardware
701(2)
Developer Utilities
703(54)
Copying and Pasting Database Structure
704(2)
Importing Tables and Fields
704(1)
Copying and Pasting Tables
705(1)
Copying and Pasting Fields
705(1)
Copying Scripts and Script Steps
706(1)
Script Debugger
706(7)
Controlling Script Execution
708(2)
Breakpoints
710(1)
Examining Errors
711(1)
Pause on Error
711(1)
Active Scripts
712(1)
Working with the Debugger Window
712(1)
The Data Viewer
713(3)
The Current Tab
713(1)
The Watch Tab
714(2)
Disable Script Steps
716(1)
The Database Design Report
717(6)
Generating the DDR
717(2)
Using the DDR
719(2)
Finding Broken Elements with the DDR
721(2)
Tooltips
723(1)
Custom Menus
724(7)
Editing a Menu
725(2)
Creating a New Menu
727(2)
Removing a Menu
729(1)
Installing Custom Menu Sets
730(1)
Developer Utilities
731(5)
Using the Developer Utilities
732(4)
Delivering a Runtime Solution
736(1)
File Maintenance
736(5)
Part Seven: Appendixes
Appendix A: Getting Help
741(8)
Appendix B: FileMaker Error Codes
749(8)
Index 757