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
140
K
Key fields. See Match fields
Kiosk solutions, creating 129
L
Labels
field 73
layouts for 57
mailing 58
part 78
printing 58
vertical 57
Labels layouts 57
Launch Center
creating solutions 41, 42
opening files 15
, 101
Layout background, setting styles for 61
Layout bar 17
, 18
Layout folders, managing 55
Layout mode
creating charts in 82
described 18
Layout objects. See Objects
Layout parts
described 80
grand summary 80
setting styles for 61
subsummary 80
Layout pop-up menu 17
, 54
Layout themes
changing 42
described 60
importing 60
Layouts 57
adding fields 72
changing theme 60
changing width 42
charting data 81
columns 64
, 65
creating 54
described 9
, 54
managing layouts and layout folders 55
panel controls on 66
popovers on 67
printing 35
testing 128
themes 60
tools 66
types 56
unit of measure 69
views of 19
Leader, setting character for paragraphs 77
Limits
characters in fields 25
field names 43
Line charts 81
List View 19, 20
List view layouts 58
Locked objects 71
Locking shared records 102
Lookups
creating or changing 96
described 84
terminology 87
M
Macros (scripts) 11
Mail merge, using merge fields 75
Mailing labels 57
Margins, displaying in Preview mode 34
Match fields
See also Fields
described 87
, 88
in import update 105
Matching records, updating 105
Mathematical operators 48
Maximum characters in fields 25
Menu sets, customizing 132
Merge fields
described 59
placing on a layout 75
Merge format 103
Microsoft Excel format
importing and exporting 103
saving data as 109
Mode pop-up menu 18
, 54
Modes 18
Moving
field to field 24
record to record 21
Multimedia files 44
N
Network security guidelines 122
Networks
cross-platform 12
, 98
FileMaker Server 98
New Layout/Report assistant 54
Non-shared files 116
Number fields
See also Fields
described 44
entering and editing values in 25
formatting 76
O
Objects, layout
aligning 68
, 69, 70
creating 66
described 66
formatting 68
locked 71
selecting 71
setting styles for 61