Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases
by: Mark Conway Munro
ISBN-10: 1484228626
ISBN-13: 9781484228623
Edition 版本: 1st ed.
Released: 2017-10-05
Pages: 917
Book Description
Extend FileMaker’s built-in functionality and totally customize your data management environment with specialized functions and menus to super-charge the results and create a truly unique and focused experience. This book includes everything a beginner needs to get started building databases with FileMaker and contains advanced tips and techniques that the most seasoned professionals will appreciate. Written by a long time FileMaker developer,this book contains material for developers of every skill level.
FileMaker Pro 16 is a powerful database development application used by millions of people in diverse industries to simplify data management tasks,leverage their business information in new ways and automate many mundane tasks. A custom solution built with FileMaker can quickly tap into a powerful set of capabilities and technologies to offer users an intuitive and pleasing environment in which to achieve new levels of efficiency and professionalism.
What You’ll learn
Create SQL queries to build fast and efficient formulas
Discover new features of version 16 such as JSON functions,Cards,Layout Object window,SortValues,UniqueValues,using variables in Data Sources
Write calculations using built-in and creating your own custom functions
Discover the importance of a good approach to interface and technical design
Apply best practices for naming conventions and usage standards
Explore advanced topics about designing professional,open-ended solutions and using advanced techniques
Who This Book Is For
Casual programmers,full time consultants and IT professionals.
Contents
Part I: Using FileMaker
Chapter 1: Introducing FileMaker
Chapter 2: Exploring the Application
Chapter 3: Exploring a Database Window
Chapter 4: Working with Records
Chapter 5: Transferring Data
Part II: Defining Data Structures
Chapter 6: Working with Database Files
Chapter 7: Working with Tables
Chapter 8: Defining Fields
Chapter 9: Connecting Tables with Relationships
Chapter 10: Managing Containers
Chapter 11: Managing Value Lists
Part III: Writing Formulas and Using Functions
Chapter 12: Writing Formulas
Chapter 13: Text Functions
Chapter 14: Text Functions (JSON)
Chapter 15: Text Formatting Functions
Chapter 16: Number Functions
Chapter 17: Date,Time,and Timestamp Functions
Chapter 18: Container Functions
Chapter 19: Aggregate,Summary,and Repeating Functions
Chapter 20: Financial and Trigonometric Functions
Chapter 21: Logical Functions
Chapter 22: Get Functions
Chapter 23: Design Functions
Chapter 24: Mobile Functions
Chapter 25: Creating Custom Functions
Chapter 26: Introducing ExecuteSQL
Part IV: Designing Interfaces
Chapter 27: Introducing Layout Mode
Chapter 28: Getting Started with Layouts
Chapter 29: Exploring Layout Palettes
Chapter 30: Creating Layout Objects
Chapter 31: Manipulating Objects
Chapter 32: Using Themes and Styles
Chapter 33: Customizing Menus
Part V: Automating Tasks with Scripts
Chapter 34: Introduction to Scripting
Chapter 35: Common Scripting Tasks
Chapter 36: Debugging Scripts
Chapter 37: Using Script Triggers
Chapter 38: Extending Features with Plugins
Part VI: Sharing and Networking
Chapter 39: Introducing Network Sharing
Chapter 40: Securing Database Access
Chapter 41: Advanced Sharing and Analysis Tools
Chapter 42: Getting Connected
