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
148
Databases
creating 54
described 13
naming 55
planning 50
preference for creating new 56
printing 44
protecting 128
publishing on web 127
Databases, relational. See Relational databases
Date fields
described 57
entering and editing values in 27
four-digit years 27
, 67
Dates
See also Date fields
displaying calendars 87
entering data 27
finding 35
finding today’s 35
formatting 91
four-digit years 67
invalid 35
typing in 27
validating 67
Decimal numbers 91
Defining
See also Adding; Placing
accounts 135
calculation fields 61
databases 59
fields 59
lookups 113
passwords 134
privilege sets 137
summary fields 63
tables 70
value lists 87
Deleting
data 27
field definitions 60
fields from a layout 87
find requests 40
related records 26
, 111
Document preferences 49
Drag and drop fields onto layout 86
Drop-down calendar 87
Drop-down lists, displaying fields as 87
Duplicate records, finding 38
Duplicating
files 20
records 24
, 29
related records 25
Dynamic guides, in Layout mode 83
Dynamic reports, creating in Table View 29
, 63
E
Elements. See Objects
Email
sending from FileMaker Pro 120
sending through SMTP 120
Empty or non-empty fields 37
Encryption. See Accounts; Privilege sets
Entering data
automatically 66
Furigana 60
typing in fields 27
Envelope layout
See also Layouts
described 76
Envelopes, printing 45
Excel format
importing and exporting to 121
saving data as 120
Exchanging files
exporting 120
, 125
importing 120
relational databases 100
with other applications 121
Exporting
See also Exchanging files
described 120
file formats 121
formatting 126
Extended privileges
described 129
viewing 138
External data sources 126
External Server account 129
, 137
F
False result 34, 57, 68, 91
Favorite files 17
Field behavior 26
, 94
Field content match 34
Field definitions
copying 20
creating and changing 59
deleting 60
Field labels 86
Field names 56
Field rights. See Accounts; Privilege sets
Field tool 86
Field types
and calculation results 63
described 57
Field values
deleting 27
described 15
entering and editing 27
entering automatically 66
finding and replacing 41
prohibiting change 66