User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Working with data in Table View
- Finding records
- Performing quick finds in Browse mode
- Making find requests in Find mode
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Viewing, repeating, or changing the last find
- Saving find requests
- Deleting and reverting requests
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Creating and changing fields
- Setting options for fields
- Creating database tables
- Creating layouts and reports
- Working with layout themes
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Creating and editing charts
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record 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 databases on the web
- Chapter 6 Protecting databases
- 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 Converting databases from FileMaker Pro 11 and earlier
- Index
153
Pointer tool. See Selection tool
Pointers to files. See Relationships
Pop-up menus, displaying fields as 87
Portals
See also Relational databases
adding records 25
deleting records 26
described 103
, 105
filtering records in 112
omitting related records 40
placing related records 88
selecting 84
selecting records 23
summarizing data in 112
Positive/negative column charts 97
Preferences
application 49
described 49
file 49
Preview mode, described 21, 44
Previewing printing. See Printing
Previewing columns 77
Primary keys. See Match fields
Print area, viewing 44
Printing
Asian text 94
blank records 45
described 43
envelopes 45
information about database 47
labels 45
previewing 44
records 44
records in columns 77
scripts 47
setting up 45
Privilege sets
Data Entry Only 131
defining 137
described 129
Full Access 131
, 139
predefined 131
Read-Only Access 131
viewing 134
Protecting files. See Accounts; Authorizing files; Privilege sets
Publishing databases on the web 127
Q
Quick charts, creating 29, 98
Quick finds
See also Finding records
badges in fields 31
configuring 31
described 30
enabling 31
performing 30
Quick Start Screen, described 15
Quotation marks in searches 33
R
Radio buttons, displaying fields as 87
Ranges of information, finding 36
Read-Only Access privilege set, described 131
Recent files 17
Record locking 118
Records
active 23
adding 24
, 29, 122
adding new in Table View 55
browsing
in a list 21
individual 21
copying 24
, 29
deleting 29
deleting related 26
described 15
, 16
displaying sorted related 111
duplicating 24
, 29
exporting 125
filtering in portals 112
finding 30
hiding 41
locked 118
matching 123
moving through 24
omitting 39
printing in columns 77
selecting 23
sorting 34
, 42
in Table View 29
related records 111
viewing as forms, lists, or tables 21
working with in Table View 29
Recurring imports
account for setting up 121
described 121
Related fields
See also Fields; Relational databases
calculations 62
described 103
on layouts 86
planning 53
summarizing data 112
Related files, restricting access 54
Related records
See also Records; Relational databases
adding 25
, 111
copying 25
deleting 26
, 111
described 103
displaying in portals 88
duplicating 25
finding and omitting 37
placing in portals 88
sorting 111
summarizing data 112