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
- 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
- Displaying data in 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 6 and earlier
- Index
|
Index 145
D
Data
charting
92
described 15
entering automatically 25, 65
exporting 114
formatting 78
importing 114
privileges for sharing 124
view as form, list, table 22
viewing in Table View 29
Data entry 27, 65–68
Data Entry Only privilege set, described 126
Data sources
described
120
fixing FileMaker references 19
Data types
See also Field types
and calculation results
63
Database locks. See Accounts; Privilege sets
Databases
creating
55
described 15
naming 56
planning 51
preference for creating new 57
printing 44
protecting 123
publishing on web 121
Databases, relational. See Relational databases
Date fields
described
58
entering and editing values in 27
four-digit years 27, 67
Dates
See also Date fields
displaying calendars
83
entering data 27
finding 35
finding today’s 35
formatting 87
four-digit years 67
invalid 35
typing in 27
validating 67
Decimal numbers 86
Defining
See also Adding; Placing
accounts
130
calculation fields 61
databases 59
fields 59
lookups 106
passwords 128
privilege sets 132
summary fields 63
tables 69
value lists 83
Deleting
data
28
field definitions 60
fields from a layout 83
find requests 40
related records 26, 105
Document preferences 49
Drag and drop fields onto layout 82
Drop-down calendar 83
Drop-down lists, displaying fields as 83
Duplicate records, finding 37
Duplicating
files
20
records 25, 29
related records 26
Dynamic reports, creating in Table View 30, 63
E
Electronic documentation 9
Elements. See Objects
Email
sending from FileMaker Pro
114
sending through SMTP 114
Empty or non-empty fields 37
Encryption. See Accounts; Privilege sets
Entering data
automatically
65
Furigana 60
typing in fields 27
Envelope layout
See also Layouts
described
75
Envelopes, printing 45
Excel format
importing and exporting to
114
saving data as 114