User manual

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 6

231

232

233

234

235

236

237

238

239

240

Table Of Contents

Preface Learning how to use FileMakerPro
- Registration and customer support
- Using the FileMakerPro documentation
  - How this guide is organized
  - A note about the illustrations
- Using FileMakerPro Help
Chapter 1 FileMaker Pro basics
- About databases
- About FileMaker Pro files
- Performing menu commands
  - Using toolbars
  - Using context menus
- Managing files
Chapter 2 Adding and viewing data
- About working with records in Browse mode
- Viewing records
- Adding and duplicating records
  - Adding and duplicating related records
- Deleting records
- About entering data in records
- About working with graphics, sounds,andmovies
- About working with text
- Working with OLE objects
Chapter 3 Finding and sorting information
- Finding records
- Sorting records
Chapter 4 Previewing and printing information
- About printing information in a database
- Preparing to print
- Previewing data on a layout
- Printing
Chapter 5 Creating a database
- Planning a database file
- Creating a FileMaker Pro file
- About defining database fields
- Setting options for fields
- Changing field definitions
- Deleting field definitions and data
Chapter 6 Creating and managing layouts and reports
- About layouts and reports
- Creating layouts and reports
- Working with, duplicating, deleting, orrenaming layouts
  - Setting up to print records in columns
  - Setting up View as Form, View as List, and View as Table
- About working with objects on a layout
- About working with fields on a layout
- About layout parts
Chapter 7 Customizing layouts
- Customizing fields on a layout
- Customizing the appearance of a layout
- Arranging objects
- Using tools to precisely position objects
- Controlling how things print
Chapter 8 Working with related files
- Displaying data from related files
- Working with relational databases
- Changing relationships
  - Choosing a different relationship for a portal
  - Summarizing data in portals
- Defining lookups between files
Chapter 9 Protecting databases with passwords and groups
- Defining passwords
- Deleting or changing passwords
- Defining groups
- Deleting or changing groups
- Passwords and groups: a comparison
Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
  - Planning scripts
  - Storing settings before creating a script
  - Defining scripts
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
  - Deleting scripts
- Importing scripts
  - To import a script
- Listing scripts in the Scripts menu
- Using buttons with scripts
  - Defining buttons
  - Copying, changing, or deleting buttons
- Example of a ScriptMaker script
  - Finding duplicate records
Chapter 11 Using formulas and functions
- About formulas
- About functions
Chapter 12 Importing and exporting data
- About import and export
  - About file formats
- Importing data into FileMaker Pro
  - Importing data into an existing file
  - Converting a data file into a new FileMakerPro file
- Exporting data from FileMaker Pro
  - Exporting subsummary data
Chapter 13 Sharing databases on a network
- About sharing files on a network
  - Working with shared files
- About hosting files
- Opening files as the host
- Closing shared files
- Opening files as a guest
Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
Chapter 15 Using ODBC with FileMakerPro
- About ODBC
  - ODBC terminology
  - ODBC support in FileMakerPro
- Sharing FileMakerPro data via ODBC
- Accessing FileMakerPro data from an ODBC client application
  - Configuring the ODBC control panel
- Importing data from other data sources
- An ODBC import example
- Importing ODBC data with a join
  - Specifying a SQL join
- Automating ODBC connections
Appendix A Customizing FileMaker Pro
- Setting application preferences
- Setting document preferences
  - Setting general document preferences
  - Setting document spelling preferences
Appendix B Backing up and recovering files
- Backing up files
  - Using a backup script
- Maintaining files
  - Saving a compressed copy
  - Understanding file damage
- Recovering damaged files
  - When to recover
Appendix C FileMaker Pro Quick Reference (Windows)
- Keyboard and mouse shortcuts
Appendix D FileMaker Pro Quick Reference (Mac OS)
- Keyboard and mouse shortcuts
Index
- Symbols
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z

Appendix C

FileMaker Pro Quick Reference (Windows)

Keyboard and mouse shortcuts

Working with layout objects

Align objects using the current settings Ctrl+K

Align to grid off while resizing/moving an object Alt+resize / Alt+drag

Bring an object forward Ctrl+Shift+[

Bring an object to the front Ctrl+Alt+[

Constrain a line to 45° increments Ctrl+drag

Constrain a rectangle to a square Ctrl+drag

Constrain an oval to a circle Ctrl+drag

Constrain movement to vertical or horizontal Shift+drag

Constrain resizing to vertical or horizontal Shift+resize

Display an object’s format Alt+double-click

Drag the selected layout part past an object Alt+drag

Duplicate by dragging Ctrl+drag

Field Borders dialog box Alt+Ctrl+Shift+B

Field Format dialog box Ctrl+Shift+M

Group objects Ctrl+R

Lock an object Alt+Ctrl+L

Move the selected object one pixel at a time Arrow keys

Redefine a field on a layout Double-click

Reorder the selected part Shift+drag

Re-orient the part labels Ctrl+click

Reset the default format based on an object Ctrl+click

Rotate an object Alt+Ctrl+R

Select items partially contained in the marquee Ctrl+drag

Select objects by type Ctrl+Shift+A

Send an object backward Ctrl+Shift+]

Send an object to the back Alt+Ctrl+]

Set Alignment dialog box Ctrl+Shift+K

Show/Hide T-squares Ctrl+T

Square the object being resized Ctrl+resize

Toggle the current tool with the selection tool Enter (numeric keypad)

Toggle the object grids Ctrl+Y

Ungroup objects Ctrl+Shift+R

Unlock an object Alt+Ctrl+Shift+L

Formatting text (Layout and Browse)

Align text center (horizontally) Ctrl+\

Align text left Ctrl+[

Align text right Ctrl+]

Align text full (full justification) Ctrl+Shift+\

Insert a tab character in text Ctrl+Tab

Next point size down Ctrl+<, Ctrl+, (comma)

Next point size up Ctrl+>, Ctrl+. (period)

Nonbreaking space Ctrl+Space bar

One point larger Ctrl+Shift+>

One point smaller Ctrl+Shift+<

Selecting text (Layout and Browse)

Extend selection to end of line Shift+End

Extend selection to end of text Ctrl+Shift+End

Extend selection to next end of word Ctrl+Shift+B

Extend selection to previous start of word Ctrl+Shift+A

Extend selection to start of line Shift+Home

Extend selection to start of text Ctrl+Shift+Home

Move insertion point to end of line End

Move insertion point to end of text Ctrl+End