FileMaker Pro 7 |
 |
| Author:Jesse Feiler | |
| Language:english | |
| Category:Databases, | |
| Lessons:0 | 0 hrs | |
| Buy Now or get more information about FileMaker Pro 7 | |
FileMaker Pro 7FileMaker Pro 7: Discovery Computer Training author Jesse Feiler introduces you to FileMaker 7: the biggest change to FileMaker in a decade. If you’re a beginner, you’ll see how to get started using the Starter Solution templates to manage your data. When you’re ready to move on to creating your own database, Feiler shows you how to design effective layouts and how to use the new database design tools to create powerful yet elegant solutions. Feiler shows you how to define multi-table database files, how to manage complex relationships, how to use the new unified security model, and how to work with file references. You’ll also see how to effortlessly publish your databases on the Web using the new Instant Web Publishing features. To get started today, simply click on one of the links belowListed below are all of the chapter and lesson contents for the FileMaker Pro 7 Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for FileMaker Pro 7 freely available. Click on any of the linked lesson listings below to preview Free! FileMaker Pro 7
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):
FileMaker Pro 7
Introducing FileMaker 7
About this TutorialFileMaker 7 Overview
The FileMaker Family
Starter Solutions
Entering Data in Browse Mode
Getting Started with FileMakerThe Browse Mode Menus
Working with a Data Layout
Using the Status Area in Browse Mode
Entering Text
Using Container Fields
Inserting Other Data with the Insert Menu
Using the Records Menu and Auto-Entering Data
Validation
Replacing Data
Using the Browse Mode View Menu
Using the Toolbars
Sorting Data
Printing and Presenting Data in Preview Mode
Using the Status AreaSliding Fields
Printing Labels
Print Options on Windows
Print Options on Macintosh
Designing the Interface in Layout Mode
Using Layout ModeShowing Objects on a Layout pt. 1
Showing Objects on a Layout pt. 2
Working With Rulers
Using the Status Area
Using the Status Area Fill and Pen Controls
Positioning Objects on a Layout by Alignment
Positioning Objects on a Layout with Tools
Adding and Formatting Fields
Other Basic Layout Mode Features
Finding Data in Find Mode
Finding Data the Simple WayConstraining and Extending Found Sets
Using Multiple Find Criteria
Using Find Requests (OR)
Using the Status Area and Omitting Records
Finding Text pt. 1
Finding Text pt. 2
Finding Numbers/Dates/Times
Using the Design Database Dialog
Database TerminologyDesign Database Dialog Basics
Creating Fields
Working with Field Types
Creating Relationships
Making Databases Robust
Creating One-to-One Relationships
Displaying Data in Related Fields
Displaying Data in Portals
Using Auto-Enter Field Options
Using Validation Field Options
Using Storage Field Options
Putting It Together: Database Design and Layout
Creating Join Tables and RelationshipsBuilding the Join Tables Layout
Entering Data pt. 1
Entering Data pt. 2
Finding Data
Advanced Relationships
Using Tables in Other Databases pt. 1Using Tables in Other Databases pt. 2
Using File References
Using Self-Joins
Using Complex Relationships
Using Relationships to Find Data
Working with Value Lists
Creating Value ListsCreating Value Lists from Other Sources
Using Value Lists Lists (Windows)
Using Value Lists (Mac OS X)
Using Value Lists for Sorting and Validation
More on Layouts
Formatting Numbers pt. 1Formatting Numbers pt. 2
Formatting Dates
Formatting Times
Formatting Graphics
Formatting Buttons
Formatting Portals
Field Formats and Behaviors
Formatting Borders
Format Painter
Putting It Together: Improving Data Entry
Using Value ListsFinishing Up the Layout
Restructuring the Database File
Working with Functions and Calculations
Using the Specify Calculation Dialog pt. 1Using the Specify Calculation Dialog pt. 2
Using Functions
Specifying Calculation Storage
Aggregate Functions
Date Functions
Design Functions
Get Functions
Logical Functions: If/Case/Choose
Logical Functions: Let
Number Functions
Repeating Functions
Summary Functions
Text Functions pt. 1
Text Functions pt. 2
Text Formatting Functions
Time and Timestamp Functions
Trigonometric/Custom/External Functions
Introducing Scripts
Introducing ScriptMakerUsing the ScriptMaker Edit Window
Using Script Parameters
Running Scripts Automatically
Control
Navigation pt. 1
Navigation pt. 2
Editing
Fields
Records
Found Sets
Windows
Files
Accounts/Spelling/Open Menu Item/Misc.
Summaries and Design
Fleshing Out the DatabaseImplementing the Relationships
Using Summary Fields on Layouts
Creating a Summary Layout pt. 1
Creating a Summary Layout pt. 2
Creating a Summary Layout pt. 3
Creating a Summary Layout pt. 4
Improving the Database: Joins for Searching
Setting Up Security
The Unified Security ModelSetting Up Accounts
Setting Up Privileges
Instant Web Publishing
Instant Web Publishing OverviewSetting Up IWP
FileMaker Networking
Using a Networked DatabaseSharing a FileMaker Database
Importing and Exporting Data
Importing Data pt. 1Importing Data pt. 2
Importing Options
Exporting Data
ODBC
ODBC for Import/Export (Windows) pt. 1ODBC for Import/Export (Windows) pt. 2
ODBC for Import/Export (Mac OS X)
Credits
Useful LinksAbout this Author
01 Introducing FileMaker 7
0101 About this Tutorial
0102 FileMaker 7 Overview
0103 The FileMaker Family
0104 Starter Solutions
02 Entering Data in Browse Mode
0201 Getting Started with FileMaker
0202 The Browse Mode Menus
0203 Working with a Data Layout
0204 Using the Status Area in Browse Mode
0205 Entering Text
0206 Using Container Fields
0207 Inserting Other Data with the Insert Menu
0208 Using the Records Menu and Auto-Entering Data
0209 Validation
0210 Replacing Data
0211 Using the Browse Mode View Menu
0212 Using the Toolbars
0213 Sorting Data
03 Printing and Presenting Data in Preview Mode
0301 Using the Status Area
0302 Sliding Fields
0303 Printing Labels
0304 Print Options on Windows
0305 Print Options on Macintosh
04 Designing the Interface in Layout Mode
0401 Using Layout Mode
0402 Showing Objects on a Layout pt. 1
0403 Showing Objects on a Layout pt. 2
0404 Working With Rulers
0405 Using the Status Area
0406 Using the Status Area Fill and Pen Controls
0407 Positioning Objects on a Layout by Alignment
0408 Positioning Objects on a Layout with Tools
0409 Adding and Formatting Fields
0410 Other Basic Layout Mode Features
05 Finding Data in Find Mode
0501 Finding Data the Simple Way
0502 Constraining and Extending Found Sets
0503 Using Multiple Find Criteria
0504 Using Find Requests (OR)
0505 Using the Status Area and Omitting Records
0506 Finding Text pt. 1
0507 Finding Text pt. 2
0508 Finding Numbers/Dates/Times
06 Using the Design Database Dialog
0601 Database Terminology
0602 Design Database Dialog Basics
0603 Creating Fields
0604 Working with Field Types
0605 Creating Relationships
0606 Making Databases Robust
0607 Creating One-to-One Relationships
0608 Displaying Data in Related Fields
0609 Displaying Data in Portals
0610 Using Auto-Enter Field Options
0611 Using Validation Field Options
0612 Using Storage Field Options
07 Putting It Together: Database Design and Layout
0701 Creating Join Tables and Relationships
0702 Building the Join Tables Layout
0703 Entering Data pt. 1
0704 Entering Data pt. 2
0705 Finding Data
08 Advanced Relationships
0801 Using Tables in Other Databases pt. 1
0802 Using Tables in Other Databases pt. 2
0803 Using File References
0804 Using Self-Joins
0805 Using Complex Relationships
0806 Using Relationships to Find Data
09 Working with Value Lists
0901 Creating Value Lists
0902 Creating Value Lists from Other Sources
0903 Using Value Lists Lists (Windows)
0904 Using Value Lists (Mac OS X)
0905 Using Value Lists for Sorting and Validation
10 More on Layouts
1001 Formatting Numbers pt. 1
1002 Formatting Numbers pt. 2
1003 Formatting Dates
1004 Formatting Times
1005 Formatting Graphics
1006 Formatting Buttons
1007 Formatting Portals
1008 Field Formats and Behaviors
1009 Formatting Borders
1010 Format Painter
11 Putting It Together: Improving Data Entry
1101 Using Value Lists
1102 Finishing Up the Layout
1103 Restructuring the Database File
12 Working with Functions and Calculations
1201 Using the Specify Calculation Dialog pt. 1
1202 Using the Specify Calculation Dialog pt. 2
1203 Using Functions
1204 Specifying Calculation Storage
1205 Aggregate Functions
1206 Date Functions
1207 Design Functions
1208 Get Functions
1209 Logical Functions: If/Case/Choose
1210 Logical Functions: Let
1211 Number Functions
1212 Repeating Functions
1213 Summary Functions
1214 Text Functions pt. 1
1215 Text Functions pt. 2
1216 Text Formatting Functions
1217 Time and Timestamp Functions
1218 Trigonometric/Custom/External Functions
13 Introducing Scripts
1301 Introducing ScriptMaker
1302 Using the ScriptMaker Edit Window
1303 Using Script Parameters
1304 Running Scripts Automatically
1305 Control
1306 Navigation pt. 1
1307 Navigation pt. 2
1308 Editing
1309 Fields
1310 Records
1311 Found Sets
1312 Windows
1313 Files
1314 Accounts/Spelling/Open Menu Item/Misc.
14 Summaries and Design
1401 Fleshing Out the Database
1402 Implementing the Relationships
1403 Using Summary Fields on Layouts
1404 Creating a Summary Layout pt. 1
1405 Creating a Summary Layout pt. 2
1406 Creating a Summary Layout pt. 3
1407 Creating a Summary Layout pt. 4
1408 Improving the Database: Joins for Searching
15 Setting Up Security
1501 The Unified Security Model
1502 Setting Up Accounts
1503 Setting Up Privileges
16 Instant Web Publishing
1601 Instant Web Publishing Overview
1602 Setting Up IWP
17 FileMaker Networking
1701 Using a Networked Database
1702 Sharing a FileMaker Database
18 Importing and Exporting Data
1801 Importing Data pt. 1
1802 Importing Data pt. 2
1803 Importing Options
1804 Exporting Data
19 ODBC
1901 ODBC for Import/Export (Windows) pt. 1
1902 ODBC for Import/Export (Windows) pt. 2
1903 ODBC for Import/Export (Mac OS X)
20 Credits
2001 Useful Links
2002 About this Author
