User manual
Table Of Contents
- Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using FileMaker Pro
- About fields and records
- Opening and closing files
- Opening multiple windows per file
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Sorting records
- Previewing and printing files
- Backing up files
- Setting preferences
- Chapter 3 Designing and creating solutions
- Planning a solution
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Working with layout object, part, and background styles
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with layout parts
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing data
- Sharing databases on a network
- Importing and exporting data
- Supported import/export file formats
- Setting up recurring imports
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing solutions on the web
- Chapter 6 Protecting files
- Protecting databases with accounts and privilege sets
- Creating accounts and privilege sets
- Viewing extended privileges
- Authorizing access to files
- Security measures
- Enhancing physical security
- Enhancing operating system security
- Establishing network security
- Backing up databases and other important files
- Installing, running, and upgrading antivirus software
- Chapter 7 Using FileMaker Pro Advanced
- Index
Index
Symbols
– 43
^ 43
_ 43
, 43
; 43
: 43
:: 43
" 43
, 48
" " 28
( 43
, 48
) 43
, 48
[ 43
] 43
} 43
* 43
/ 43
& 43
+ 43
< 43
= 43
> 43
$ 43
≤ 43
… 43
≥ 43
A
Access privileges. See Accounts; Privilege sets
Access via FileMaker Network 99
, 120
Accounts
creating and editing 117
described 111
External Server account 111
, 118
for hosted files 111
passwords 116
predefined 112
viewing 117
Active record 21
Adding
See also Defining
fields 43
records 22
related records 23
, 95
tables 53
Admin account 114
Aligning
objects 68
text 77
Antivirus software, and database management 123
Apple Open Directory 118
Application preferences 36
Area charts 82
Asian text, formatting fields for 77
Attributes, text 76
Authentication
Apple Open Directory 118
described 111
via external server 118
Windows domain 118
Auto-complete 74
Automating tasks (scripts) 11
Auxiliary files, updating 129
B
Backups
and antivirus software 123
guidelines for 122
, 128
scripts for files 36
Badges in fields, for quick finds 29
Bar charts 81
Baseline offset 77
Baselines, text 77
Binding key
described 126
updating runtime solutions 128
Blank layouts 56
Body part 80
Boolean values
described 44
setting 51
Bottom navigation part 80
Break fields 80
Browse mode
creating charts in 82
described 18
finding data in 28
Browsers, working with published solutions in 109
Browsing records 19
Bubble charts 82
Buttons
including in tab order 24
popover 67
C
Calculation fields
creating 48
described 44
formulas 48
stored and unstored results 51
, 52
Calculations
See also Calculation fields
field references to related fields 48
formatting 76
troubleshooting 133