FileMaker Pro 8:
Basic

Topic-Level Outline

Days: 1

Prerequisites: Windows XP: Basic or equivalent experience

Unit 1 : Getting started

Topic A: 0 Database terminology

A-1: Identifying database terms and concepts

Topic B: 0 Exploring FileMaker Pro 8

B-1: Opening a FileMaker Pro database

B-2: Navigating among modes

B-3: Navigating among layouts

B-4: Navigating among records

B-5: Changing magnification and available screen space

B-6: Previewing for printing

Topic C: 0 Getting help

C-1: Using the Help feature

Unit 2 : Records

Topic A: 0 Working with records

A-1: Viewing and selecting records

A-2: Adding a record to a database

A-3: Editing and deleting records

Topic B: 0 Sorting records

B-1: Sorting database records

Topic C: 0 Finding records

C-1: Performing match requests

C-2: Performing comparison requests

C-3: Finding matching records by using Fast Match

Unit 3 : Creating databases and importing data

Topic A: 0 Defining fields

A-1: Creating a database and defining fields

A-2: Creating a calculation field

A-3: Performing calculations with dates

A-4: Creating a value list

A-5: Displaying a value list

Topic B: 0 Importing data

B-1: Importing records

B-2: Replacing field contents for the found set

Unit 4 : Complex find requests

Topic A: 0 Advanced find requests

A-1: Finding records containing empty fields

A-2: Using the Omit option

Topic B: 0 Multiple criteria searches

B-1: Performing an AND search

B-2: Performing an OR search

B-3: Combining AND and OR searches

B-4: Constraining and extending a found set

Unit 5 : Layout design

Topic A: 0 Adjusting layout objects

A-1: Resizing fields

A-2: Moving fields

A-3: Modifying field labels

A-4: Moving multiple layout objects

A-5: Adding a field to a layout

A-6: Sizing a field to match an existing field

Topic B: 0 Formatting layout objects

B-1: Applying colors to layout objects

B-2: Formatting field borders

B-3: Importing an image to a layout

B-4: Formatting date fields

B-5: Formatting number fields

Topic C: 0 New layouts

C-1: Creating a new columnar report

C-2: Creating mailing labels

Topic D: 0 Tabbed layouts

D-1: Adding a tab control

D-2: Adding items to tab panels

D-3: Modifying a tab control

Unit 6 : Simple table relationships

Topic A: 0 Understanding relationships

A-1: Identifying relationship terms and concepts

Topic B: 0 Relating tables

B-1: Creating an additional table

B-2: Defining a one-to-many relationship

B-3: Placing related fields from the “one” table in the “many” table

B-4: Creating a portal

Unit 7 : Summarizing and sharing data

Topic A: 0 Creating summaries

A-1: Adding a summary part

A-2: Running a summary report

Topic B: 0 Summarizing portal data

B-1: Creating a field to total portal values

Topic C: 0 Saving data to other formats

C-1: Saving a report to PDF

C-2: Saving record data as an Excel file

C-3: Attaching field content to an e-mail message

Unit 8 : Buttons and scripts

Topic A: 0 Simple buttons

A-1: Creating a button to add a new record

A-2: Creating a new button from a duplicate

Topic B: 0 Custom scripts

B-1: Creating a script to switch layouts and modes

B-2: Creating a button for a script

B-3: Creating a script that includes find requests