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
142
Records
active 21
adding 22, 27, 104
browsing 19
, 27
copying 22, 27
deleting 27
described 15
duplicating 22
, 27
exporting 107
finding 28
hiding 32
locked 102
matching 105
moving through 21
printing in columns 63
selecting 21
sorting 27
, 33, 95
viewing as forms, lists, or tables 19
Recurring imports 12
Related fields
See also Fields; Relational databases
calculations 48
described 87
on layouts 73
planning 40
Related files, restricting access 41
Related records
See also Records; Relational databases
adding 23
, 95
copying 23
deleting 24
, 95
described 87
duplicating 23
finding and omitting 31
in portals 75
sorting 95
Related tables
described 87
planning 37
Relational databases
and portals 87
described 14
, 84
match fields 87, 88
planning 37
, 84
related tables 37
, 87
terminology 87
Relational operators 87
, 91, 95
Relationships
See also Relational databases
changing 94
comparative 91
creating 94
described 87
multi-criteria 90
planning 40
returning range of records 92
self-joining 93
single-criteria 89
Relationships graph
creating relationships 94
described 87
, 88
text notes in 94
Repeating find requests 31
Report layouts 58
Reports
See also Layouts; Subsummaries
creating 54
database 134
previewing 34
records in columns 63
with grouped data 35, 58
Retrieving data from other files. See Exchanging files
Reverting find requests 32
Rulers, showing and hiding 69
Runtime application, compared to FileMaker Pro 126
Runtime solutions
creating 125
documenting 126
preparing files 125
updating 128
upgrading 126
S
Saving
data automatically 17
files 17
found set as snapshot link 11
shared files 99
to Excel and PDF formats 109
Scatter charts 82
Schemas, database, documenting 134
Screen stencils 70
Script triggers 11
Scripts 11
Secondary files. See Relational databases
Security, file
network guidelines 122
operating system guidelines 121
planning 114
, 121
Selecting
fields 24, 71
files in Launch Center 15
objects 71
records 21
text 71
Selection tool 71
Self-joins 93
Server. See Host; FileMaker Server
Settings. See Preferences