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
138
Duplicating
records 22, 27
related records 23
tables in the relationships graph 93
Dynamic guides, for designing layouts 70
Dynamic Link Libraries (DLLs) 127
Dynamic reports, creating in Table View 27
, 49
E
Edit boxes, displaying fields as 74
Elements. See Objects
Email, sending from FileMaker Pro or through SMTP 109
Encrypted connection (SSL) to host 101
Entering data
automatically 51
typing in fields 25
Envelopes layouts 58
Envelopes, printing 58
Excel format
importing and exporting to 103
saving data as 109
Exchanging files
importing and exporting 103
relational databases 84
with other applications 103
Exporting
described 103
file formats supported 103
formatting 108
Expressions, monitoring 133
Extended privileges
described 111
viewing 120
External data sources 108
External Server account 111
, 118
F
False result 44, 51
Favorite files, opening 15
Field behavior 24
, 78
Field labels, placing on a layout 73
Field names, guidelines 43
Field Picker dialog box, for defining fields 46
Field tool 73
Field types
and calculation results 49
described 44
Field values
deleting 25
described 15
entering and editing 25
entering automatically 51
Field/Control tool 73
Fields
adding to a layout 72
creating and changing 43
defining 43
, 46, 47
deleting from a layout 74
described 14
displaying 9
, 54
dragging to a layout 73
entry options 50
, 74
formatting data 76
Furigana 51
global 53
indexing 51
, 52
merge fields 75
monitoring 133
naming 46
options for 51
placing on a layout 72
placing related on a layout 75
removing from a layout 74
restricting data entry 78
selecting 24
, 71
stored and unstored results 51, 52
text baselines 77
types 44
typing in 25
validation options 51
File formats supported for importing and exporting 103
File options 36
File references. See Data sources
File sharing, enabling 99
FileMaker Developer. See FileMaker Pro Advanced
FileMaker documentation 7
FileMaker Go
and sharing files 98
designing layouts for 70
extended privileges for 112
layout themes for 61
privileges for 119
FileMaker Pro
documentation information 7
file format 103
product overview 8
FileMaker Pro Advanced
described 125
upgrading from earlier versions 126
FileMaker Pro format 103
FileMaker Server
described 118
privileges for 112
, 120
recommended use 98
uploading files to 103
FileMaker WebDirect
described 109
extended privileges for 112
privileges for 119