
FileMaker Pro 9: Beginner
FileMaker Pro is powerful enough to handle most database jobs, yet easy enough to create simple solutions in minutes. This practical \"how to\" course by FileMaker expert John Mark Osborne, starts from beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5 and 9 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting and interface design. Examples of the invoice file are provided at every stage of the creation process, so the user can easily review one section without starting from the beginning. To being learning today, simply click on one of the FileMaker Pro 9: Beginner links.rn<p>rn<font color=\"red\">The completed invoicing solution included on the beginner, intermediate (soon-to-be-released) and advanced (soon-to-be-released) FileMaker Pro 9 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution. If you would like to purchase the completed invoicing solution, please visit the <a class=\"linkNineAlt\" href=\"http://www.databasepros.com/\" target=\"_blank\">www.databasepros.com</a> web site.</font></p>rn<p><i>* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary. </i></p>rn<p><i>** This tutorial is part one in an upcoming 3-part FileMaker Pro 9 series. </i></p>
Course content
Introduction15 lessons
- About John Mark Osborne4:19Free
- FileMaker 9 Family of Products pt. 15:15Free
- FileMaker 9 Family of Products pt. 24:46Free
- New FileMaker Pro 9 Features pt. 15:39Free
- New FileMaker Pro 9 Features pt. 25:47Free
- New FileMaker Pro 9 Features pt. 36:21Free
- New FileMaker Pro 9 Advanced Features pt. 14:11Free
- New FileMaker Pro 9 Advanced Features pt. 23:35Free
- About the Tutorial Series pt. 16:01Free
- About the Tutorial Series pt. 23:32Free
- Why an Invoicing Solution? pt. 17:15Free
- Why an Invoicing Solution? pt. 24:09Free
- What is a Database? pt. 16:00Free
- What is a Database? pt. 22:22Free
- Planning Your Solution6:05Free
Creating a Database8 lessons
Working With the Database9 lessons
- Data Entry pt. 16:521 credit or ad
- Data Entry pt. 26:471 credit or ad
- Status Area5:521 credit or ad
- The Four Modes5:511 credit or ad
- Records Menu pt. 14:431 credit or ad
- Records Menu pt. 25:551 credit or ad
- Previewing Pages6:481 credit or ad
- New Layout pt. 15:381 credit or ad
- New Layout pt. 27:191 credit or ad
Finding & Sorting12 lessons
- Basic Find6:091 credit or ad
- How the Index Works pt. 14:011 credit or ad
- How the Index Works pt. 26:071 credit or ad
- New Requests4:291 credit or ad
- Symbols pt. 13:571 credit or ad
- Symbols pt. 25:471 credit or ad
- Wildcards & More On Symbols pt. 13:351 credit or ad
- Wildcards & More On Symbols pt. 26:011 credit or ad
- Found Sets Without Find Mode4:141 credit or ad
- Constrain & Extend3:421 credit or ad
- Sorting Records6:591 credit or ad
- New Window3:121 credit or ad
Modifying Layouts6 lessons
Modifying Layouts Advanced14 lessons
- Tab Control pt. 16:521 credit or ad
- Tab Control pt. 23:551 credit or ad
- Field Control pt. 17:061 credit or ad
- Field Control pt. 27:271 credit or ad
- Parts pt. 17:351 credit or ad
- Parts pt. 25:311 credit or ad
- Layout Menu pt. 14:411 credit or ad
- Layout Menu pt. 24:591 credit or ad
- Format Menu pt. 16:511 credit or ad
- Format Menu pt. 24:441 credit or ad
- Arrange Menu pt. 17:081 credit or ad
- Arrange Menu pt. 22:591 credit or ad
- View Menu pt. 17:201 credit or ad
- View Menu pt. 23:131 credit or ad
Working With Container Fields6 lessons
Auto-Entry7 lessons
Validation6 lessons
Printing13 lessons
- Print Layouts pt. 17:241 credit or ad
- Print Layouts pt. 24:261 credit or ad
- Contact List pt. 16:011 credit or ad
- Contact List pt. 23:301 credit or ad
- Labels pt. 15:361 credit or ad
- Labels pt. 24:021 credit or ad
- Merge Letters pt. 15:351 credit or ad
- Merge Letters pt. 26:551 credit or ad
- Merge Letters pt. 35:311 credit or ad
- Sub-Summary Reports pt. 16:471 credit or ad
- Sub-Summary Reports pt. 27:131 credit or ad
- Improved Contact List pt. 17:011 credit or ad
- Improved Contact List pt. 23:241 credit or ad
Scripting & Calculations18 lessons
- Definition of a Script pt. 14:081 credit or ad
- Definition of a Script pt. 26:041 credit or ad
- Definition of a Script pt. 36:561 credit or ad
- Definition of a Calculation pt. 13:461 credit or ad
- Definition of a Calculation pt. 25:381 credit or ad
- Navigation pt. 15:371 credit or ad
- Navigation pt. 27:011 credit or ad
- Advanced Navigation pt. 15:501 credit or ad
- Advanced Navigation pt. 25:511 credit or ad
- Advanced Navigation pt. 36:311 credit or ad
- Open Script pt. 15:311 credit or ad
- Open Script pt. 23:181 credit or ad
- Recreate the Status Area5:451 credit or ad
- Billing or Shipping Labels pt. 13:451 credit or ad
- Billing or Shipping Labels pt. 24:011 credit or ad
- Billing or Shipping Labels pt. 37:061 credit or ad
- Birthdays pt. 16:161 credit or ad
- Birthdays pt. 24:551 credit or ad
Importing & Exporting11 lessons
- Import & Export Defined6:411 credit or ad
- Importing FileMaker Files pt. 15:311 credit or ad
- Importing FileMaker Files pt. 27:441 credit or ad
- Importing a Folder7:041 credit or ad
- Data Sources pt. 14:071 credit or ad
- Data Sources pt. 25:211 credit or ad
- Exporting Files4:451 credit or ad
- Group By6:521 credit or ad
- Export to HTML4:281 credit or ad
- Importing Schema pt. 15:121 credit or ad
- Importing Schema pt. 23:431 credit or ad
Miscellanneous Features14 lessons
- Global Field pt. 15:171 credit or ad
- Global Field pt. 26:061 credit or ad
- Repeating Field pt. 13:051 credit or ad
- Repeating Field pt. 25:161 credit or ad
- Furigana3:391 credit or ad
- Spell Checking6:051 credit or ad
- Find & Replace3:581 credit or ad
- Engraving & Embossing pt. 13:471 credit or ad
- Engraving & Embossing pt. 23:241 credit or ad
- Send Email pt. 14:131 credit or ad
- Send Email pt. 24:211 credit or ad
- Improved Print Script5:211 credit or ad
- Tooltips pt. 15:011 credit or ad
- Tooltips pt. 25:071 credit or ad