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
|
Contents 5
Setting options for fields 65
Defining automatic data entry 65
Defining field validation 66
About storage and indexing options 68
Creating database tables 69
Creating layouts and reports 70
About layout types 72
Setting up a layout to print records in columns 75
Setting up columns in a layout 75
Changing the width of columns 76
Working with objects on a layout 77
Using the Inspector to format objects 78
Using the Inspector to position objects 78
Selecting objects 80
Working with fields on a layout 81
Placing and removing fields on a layout 81
Setting up checkbox sets and other controls on a layout 83
Deciding where to place related fields 84
About merge fields 84
Formatting field data on a layout 85
Allowing or preventing entry into fields 90
Working with parts on a layout 90
About layout part types 91
Displaying data in charts 92
Creating a chart 92
Chapter 4
Working with related tables and files 95
About relationships 95
Relational database terminology 97
About the relationships graph 98
About match fields for relationships 98
Types of relationships 99
Planning a relational database 102
Working with the relationships graph 102
Creating relationships 103
Changing relationships 104
Summarizing data in portals 105
Filtering records in portals 105
About lookups 106
Creating lookups 106
Editing lookups 107