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
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- 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
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- 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
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining 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
- 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
- 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 with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
Index | 205
Creating See Adding; Defining
Cross-platform, file sharing 24
Currency, formatting 122
Current
date, formatting 123
time, formatting 124
Custom menus, FileMaker Pro
Advanced 12
D
Data
described 19
entering automatically 35, 92
exporting 163
importing 163
privileges for sharing 177
view as form, list, table 29
Data entry 38, 92–96
Data Entry Only privilege set,
described 180
Data sources
described 170
fixing FileMaker references 24
Data types
See also Field types
and calculation results 88
Database locks. See Accounts; Privilege sets
Databases
creating 78
described 19
naming 79
planning 71
printing 61
publishing on web 172
Databases, relational. See Relational
databases
Date fields
described 82
entering and editing values in 39
four-digit years 39, 95
Dates
See also Date fields
displaying calendars 118
entering data 39
finding 46
finding today’s 46
formatting 123
four-digit years, verifying 95
invalid 46
typing in 39
validating 95
Decimal numbers 122
Defining
See also Adding; Placing
accounts 186
calculation fields 85
databases 80
fields 80
lookups 151
passwords 184
privilege sets 189
summary fields 88
tables 97
value lists 119
Deleting
data 40
fields from a layout 118
find requests 55
related records 37, 149
Document preferences 69
Drag and drop, fields onto layout 116
Drop-down calendar 118
Drop-down lists, displaying fields as 119
Duplicate records, finding 51
Duplicating
files 27
records 35
related records 36
E
Electronic documentation 10
Elements. See Objects
φμπ10_υσερσ_γυιδε.βοοκ Παγε 205 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ