FileMaker Pro 14: The Missing Manual
Published on 13. May 2015
972 pages
978-1-4919-1745-9 (ISBN)
Description
You don't need a technical background to build powerful databases with FileMaker Pro 14. This crystal-clear, objective guide shows you how to create a database that lets you do almost anything with your data so you can quickly achieve your goals. Whether you're creating catalogs, managing inventory and billing, or planning a wedding, you'll learn how to customize your database to run on a PC, Mac, web browser, or iOS device.
The important stuff you need to know:
- Dive into relational data. Solve problems quickly by connecting and combining data from different tables.
- Create professional documents. Publish reports, charts, invoices, catalogs, and other documents with ease.
- Access data anywhere. Use FileMaker Go on your iPad or iPhone?or share data on the Web.
- Harness processing power. Use new calculation and scripting tools to crunch numbers, search text, and automate tasks.
- Run your database on a secure server. Learn the high-level features of FileMaker Pro Advanced.
- Keep your data safe. Set privileges and allow data sharing with FileMaker's streamlined security features.
More details
Other editions
Additional editions
Susan Prosser | Stuart Gripman
Filemaker Pro 14: The Missing Manual
Book
06/2015
O'Reilly
€37.50
Shipment within 10-20 days
Content
- Intro
- The Missing Credits
- Introduction
- Why FileMaker Pro?
- About This Book
- Macintosh and Windows
- About the Outline
- What's New in FileMaker Pro 14
- The Very Basics
- About the Online Resources
- Safari® Books Online
- Part One: Getting Started with FileMaker Pro
- Chapter 1: Working with Your Database
- A Very Quick Database Tour
- Opening and Closing Database Files
- Adding Data to Your Database
- Navigating Your Database
- Finding Records
- Sorting Records
- Same Database, Different Views
- Saving Your Database
- Using FileMaker's Help Menu
- Chapter 2: Organizing and Editing Records
- Views
- Advanced Find Techniques
- Editing the Contents of Your Fields
- Changing Text Appearance
- Checking Spelling
- Preview Mode and Printing
- Chapter 3: Getting to Know FileMaker Go
- Hello Go
- Part Two: Building Your First Database
- Chapter 4: Creating a Custom Database
- Creating a New Database
- Creating and Managing Fields in Form View
- Understanding Layouts
- Customizing a Layout
- Creating a New Layout
- Arrange and Align Tools
- Chapter 5: Adding Power to Your Database
- Creating a Simple Calculation
- Creating a Related Table
- Creating and Using Portals
- Using Tab Controls
- Adding Merge Fields
- Writing a Basic Script
- Creating a Dynamic Report with the Assistant
- Creating a Trailing Group Report
- Creating Charts in Table View
- Changing the Default Account
- Summing Up
- Part Three: Thinking Like a Developer
- Chapter 6: Creating and Managing a Relational Database
- Understanding Relational Databases
- Modeling Your Database
- Creating a Relational Database
- Using Relational Database Power
- Lookups
- Reviewing Relationship Concepts
- Chapter 7: Field Options
- Understanding Field Types
- Auto-Enter Field Options
- Validation Options
- Storage Options
- Beyond Text: Container Fields
- Chapter 8: Layout Mechanics
- Layout Types
- Layout Parts
- Formatting Fields
- Field Behavior
- Data Formatting
- Tab Order
- Creating Layouts for Printing
- Chapter 9: Layout Design
- Layout Themes
- Styles
- Formatting Object States
- Alignment Tools
- Screen Stencils
- Merge Fields
- Merge Variables
- Tooltips
- Autosizing
- Buttons
- Slide Controls
- Chapter 10: Understanding Calculations
- Understanding Calculations
- Using a Related Field in a Calculation
- Understanding the Specify Calculation Dialog Box
- Auto-Enter Calculations
- Validate Data Entry with a Calculation
- Commenting in Calculations
- Chapter 11: More Calculations and Data Types
- Number Crunching Calculations
- Going Beyond Basic Calculations
- Text Calculations
- Date and Time Calculations
- Containers in Calculations
- Chapter 12: Understanding Scripts
- Understanding Scripts
- Your First Script
- Shortcuts to the Script Workspace
- The Importance of the Layout
- Running Scripts
- Organizing Your Scripts
- Branching and Looping in Scripts
- Script Triggers
- Chapter 13: Exploring Script Steps
- Go to Layout
- Go to Object
- Scripting for Fields
- Working with Records
- Finding Records
- Sorting Records
- Working with Windows
- Working with Files
- Printing
- Working with FileMaker Go
- Other Script Steps
- Part Four: Becoming a Power Developer
- Chapter 14: Applying Developer Utilities
- Copying Database Structure
- Script Debugger
- The Data Viewer
- Disable Script Steps
- The Database Design Report
- Custom Functions
- Custom Menus
- Developer Utilities
- File Maintenance
- Chapter 15: Advanced Relationship Techniques
- Advanced Relationships
- Portal Filtering
- Understanding Table Occurrences
- Table Occurrence Groups
- Understanding Graph Arrangements
- Connecting Database Files
- Using Multiple Relationship Techniques
- Chapter 16: Reporting and Analysis
- Summary Fields and Subsummary Parts
- Web Viewer Objects
- Conditional Formatting
- Basic Charting
- Chart Formatting
- Charting and Reports
- Advanced Charting
- Chapter 17: Advanced Calculations
- Understanding Boolean Functions
- Using Storage Options
- Logical Functions
- The Let() Function and Variables
- Recursion
- Plug-Ins
- Chapter 18: Advanced Scripting
- Commenting Scripts
- Communicating with Database Users
- Creating Modular Scripts
- Script Parameters
- Script Variables
- Handling Errors
- Advanced Script Triggers
- Putting a Complex Script Together
- Part Five: Security and Integration
- Chapter 19: Adding Security
- How Security Works
- Managing Accounts
- Managing Privilege Sets
- Extended Privileges
- Managing External File Access
- Scripts and Security
- Chapter 20: Sharing Data Using FileMaker Server
- Understanding Database Sharing
- FileMaker Network Sharing
- Setting Up a Host Computer
- Opening a Shared File
- FileMaker Server
- Server Hardware
- Chapter 21: Sharing Data with WebDirect and FileMaker Go
- Understanding WebDirect
- Enabling WebDirect in a Database
- Opening a Database in FileMaker Go
- Designing for WebDirect and FileMaker Go
- Designing for Go
- Designing for WebDirect
- Sharing Databases on the Internet without WebDirect
- Chapter 22: Sharing Data with Other Systems
- Sharing Your Data with Others
- Snapshot Link
- External SQL Sources
- Exporting Data
- Importing Data
- Import Data Sources
- Importing and Exporting in a Script
- Part Six: Appendixes
- Appendix A: Getting Help
- Getting Help from FileMaker Pro
- FileMaker's Installed Extras
- Getting Help from the Community
- Appendix B: Layout Badges
- Appendix C: Using the Insert Commands with Container Fields
- Appendix D: FileMaker Error Codes
- Index
