Book description
Get the scoop on designing databases for Mac and Windows
Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems
FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too.
Discover how to
Build a layout that works
Create custom triggers and calculated fields
Generate reports automatically
Manage security
Publish your database on the Web
Embed pictures, sound, and video
Table of contents
- Copyright
- About the Author
- Dedication
- Author's Acknowledgments
- Introduction
-
I. Getting to Know FileMaker Pro
- In this part . . .
- 1. Introducing FileMaker Pro
- 2. Creating a Database
- 3. Calculation Programming: You Have the Power!
-
II. Building the Perfect Beast
- In this part . . .
- 4. Designing a Good FileMaker Application
- 5. Whipping the Layout into Shape
- 6. Finding and Sorting Your Data
- 7. Making FileMaker Do Tricks
-
III. Taking Control with FileMaker Programming
- In this part . . .
- 8. It's All in the Script!
- 9. Your Programming Toolbox
-
IV. FileMaker Exposed! Sharing and Protecting Your Database
- In this part . . .
- 10. Share (Data) and Share Alike
- 11. Batten Down the Hatches! Keeping Your Data Safe
- 12. Putting Your Databases on the Web
-
V. The Part of Tens
- In this part . . .
-
13. Ten Cool Things You Can Do with FileMaker
- Making Hidden Buttons
- Giving Your Layouts Pizazz with Graphics
- Making Layout Titles and Text Dynamic
- Reusable Layouts
- Showing Movies in FileMaker
- Using Auto Start & End Script Code
- Sending E-Mail from FileMaker
- Launching a Web Site with FileMaker
- Changing a Field Background Color
- Running Another Application
- 14. Ten (Or So) Items to Aid Your FileMaker Development
-
A. Scripting Reference
- Add Account
- Adjust Window
- Allow Toolbars
- Allow User Abort
- Arrange All Windows
- Beep
- Change Password
- Check Found Set
- Check Record
- Check Selection
- Clear
- Close File
- Close Window
- Comment
- Commit Records/Requests
- Constrain Found Set
- Convert File
- Copy All Records/Requests
- Copy Record/Request
- Copy
- Correct Word
- Cut
- Delete Account
- Delete All Records
- Delete Portal Row
- Delete Record/Request
- Dial Phone
- Duplicate Record/Request
- Edit User Dictionary
- Else If
- Else
- Enable Account
- End If
- End Loop
- Enter Browse Mode
- Enter Find Mode
- Enter Preview Mode
- Execute SQL
- Exit Application
- Exit Loop If
- Exit Script
- Export Field Contents
- Export Records
- Extend Found Set
- Flush Cache to Disk
- Freeze Window
- Go to Field
- Go to Layout
- Go to Next Field
- Go to Portal Row
- Go to Previous Field
- Go to Record/Request/Page
- Go to Related Record
- Halt Script
- If
- Import Records
- Insert Calculated Result
- Insert Current Date
- Insert Current Time
- Insert Current User Name
- Insert File
- Insert From Index
- Insert From Last Visited
- Insert Object (Windows)
- Insert Picture
- Insert QuickTime
- Insert Text
- Install Menu Set
- Loop
- Modify Last Find
- Move/Resize Window
- New File
- New Record/Request
- New Window
- Omit Multiple Records
- Omit Record
- Open Define Database
- Open Define File References
- Open Define Value Lists
- Open File Options
- Open File
- Open Find/Replace
- Open Help
- Open Preferences
- Open Record/Request
- Open Remote
- Open ScriptMaker
- Open Sharing
- Open URL
- Paste
- Pause/Resume Script
- Perform AppleScript (Mac OS)
- Perform Find
- Perform Find/Replace
- Perform Script
- Print Setup
- Recover File
- Refresh Window
- Re-Login
- Relookup Field Contents
- Replace Field Contents
- Reset Account Password
- Revert Record/Request
- Save a Copy as
- Save Records As Excel
- Save Records As PDF
- Scroll Window
- Select All
- Select Dictionaries
- Select Window
- Send DDE Execute (Windows)
- Send Event (Mac OS)
- Send Event (Windows)
- Send Mail
- Set Error Capture
- Set Field
- Set Multi-User
- Set Next Serial Value
- Set Selection
- Set Use System Formats
- Set Variable
- Set Window Title
- Set Zoom Level
- Show All Records
- Show Custom Dialog
- Show Omitted Only
- Show/Hide Status Area
- Show/Hide Text Ruler
- Sort Records
- Speak (Mac OS)
- Spelling Options
- Undo
- Unsort Records
- Update Link (Windows)
- View As
Product information
- Title: FileMaker® Pro Design & Scripting For Dummies®
- Author(s):
- Release date: July 2006
- Publisher(s): Wiley
- ISBN: 9780471786481
You might also like
book
Visual Studio® 2010 All-in-One For Dummies®
A comprehensive, easy-to-understand guide to Visual Studio 2010 Visual Studio is Microsoft's comprehensive development environment that …
book
FileMaker® Pro 13 Absolute Beginner’s Guide
Make the most of FileMaker Pro 13– without becoming a technical expert! This book is the …
book
Beginning Access™ 2007 VBA
This book provides you with the tools and techniques you'll need in order to build more …
book
FileMaker Pro 8: The Missing Manual
Used by millions worldwide, FileMaker Pro is an award-winning database program for managing people, projects, images, …