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
139
Files
See also Databases; Solutions
accounts 111
authorizing access to protected files 120
backing up 36
closing 16
copying 17
creating 42
described 8
, 14
encrypted connection (SSL) to host 101
exporting to 107
hosted 101
naming 42
opening 15
, 101
planning 37
privilege sets 111
protecting 110
publishing on the web 109
saving 17
shared
on web 109
planning security for 115
Find mode 18
Find requests
See also Finding records
described 29
editing 32
operators in 30
repeating 31
Finding records
all records 31
described 28
omitting records 30
quick finds 28
related fields and records 31
saving and sending as snapshot link 11
, 29
showing all records 31
Folder structure for runtime solutions 127
Fonts not on user’s system 127
Footer part 80
Form letters 75
Form View 19
, 20
Formatting
calculations 76
export data 108
fields 76
import data 103
layout objects 68
paragraphs 77
text 76
Formulas
calculation fields 48
for custom functions 130
monitoring 133
Found set
See also Finding records
described 18
, 29
omitting records from 30
saving and sending as snapshot link 11
, 29
switching with omitted set 32
Four-digit years
in date fields 25
, 51
in timestamp fields 25
Full Access privilege set 113
, 120
Functions
custom 129
described 48
monitoring in formulas 134
Furigana fields 51
G
Getting Started tour 8
Global storage options 53
Grand summaries 80
Grid, for designing layouts 69
Groups. See Accounts; Privilege sets
Guides, for designing layouts 69
, 70
H
Header part 80
Help, getting for FileMaker Pro 7
Hiding records 32
Highlighting text 77
Horizontal charts 81
Host
described 99
encrypted connection (SSL) 101
FileMaker Server 98
performing tasks 102
saving files 99
solutions on the web 109
HTML format for Database Design Reports 134
HTML table format 103
I
Importing
described 103
file formats supported 103
layout themes 60
recurring imports 12
terminology 104
Indexing fields 51
, 52
Inserting files into container fields 25
Inspector
described 66
opening 68
Intranet
See also Web publishing
files shared on 109
J
JDBC
field name considerations 43
privileges for 112
, 119
Join expressions. See Relationships
Join fields. See Match fields