
FileMaker Pro 12: 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, 9, 10, 11 and 12 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting, interface design and new FileMaker Pro 12 features including charting, snapshot links and the inspector. 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 begin learning today, simply click on the movie links.
Course content
Introduction17 lessons
- About John Mark Osborne4:51Free
- System Requirements3:17Free
- FileMaker 12 Family of Products6:48Free
- About the Tutorial Series pt. 15:08Free
- About the Tutorial Series pt. 24:55Free
- Why an Invoicing Solution?4:21Free
- Work Files1:32Free
- Locked Files6:28Free
- Conversion3:24Free
- What is a Database? pt. 15:02Free
- What is a Database? pt. 25:23Free
- Planning Your Solution5:02Free
- New FileMaker 12 Features Overview8:17Free
- New FileMaker 12 Functions8:12Free
- New FileMaker 12 Scripts7:09Free
- New Filemaker 12 Charting2:23Free
- New FileMaker 12 Layout6:04Free
Creating a Database8 lessons
- Quick Start4:141 credit or ad
- New Empty File8:031 credit or ad
- Creating Fields8:001 credit or ad
- Housekeeping Fields pt. 15:041 credit or ad
- Housekeeping Fields pt. 28:161 credit or ad
- Adding Fields to a Layout6:311 credit or ad
- Modifying and Organizing Fields6:041 credit or ad
- Other Tabs4:291 credit or ad
Working with the Database13 lessons
- Data Entry5:581 credit or ad
- Importing Data pt. 16:471 credit or ad
- Importing Data pt. 27:571 credit or ad
- Status Toolbar7:361 credit or ad
- Customizing the Status Toolbar2:441 credit or ad
- The Four Modes6:121 credit or ad
- Records Menu pt. 16:431 credit or ad
- Records Menu pt. 26:501 credit or ad
- Previewing Pages4:581 credit or ad
- New Layout pt. 15:361 credit or ad
- New Layout pt. 25:361 credit or ad
- Table View5:521 credit or ad
- Schema from Table View2:391 credit or ad
Finding and Sorting13 lessons
- Basic Find5:231 credit or ad
- How the Index Works5:511 credit or ad
- New Requests6:521 credit or ad
- Range Finds6:291 credit or ad
- Wildcards5:181 credit or ad
- The Rest of the Operators8:051 credit or ad
- Found Sets without Find Mode5:581 credit or ad
- Constrain & Extend3:381 credit or ad
- Sorting Records6:511 credit or ad
- New Window4:291 credit or ad
- Quick Find2:261 credit or ad
- Save Find Requests7:101 credit or ad
- Snapshot Links3:071 credit or ad
Layouts Beginner10 lessons
- Status Toolbar pt. 16:041 credit or ad
- Status Toolbar pt. 26:221 credit or ad
- Arrow Tool6:231 credit or ad
- Field Tool4:151 credit or ad
- Text Tool5:341 credit or ad
- Working with Text pt. 14:051 credit or ad
- Working with Text pt. 24:041 credit or ad
- Line Tool4:521 credit or ad
- Rectangles & Ovals7:311 credit or ad
- More with Text Blocks6:241 credit or ad
Layouts Intermediate12 lessons
- Tab Control pt. 18:511 credit or ad
- Tab Control pt. 26:111 credit or ad
- Themes5:231 credit or ad
- Field Control7:591 credit or ad
- Value Lists pt. 14:471 credit or ad
- Value Lists pt. 24:541 credit or ad
- Explicit Layout Size2:501 credit or ad
- Parts Overview7:251 credit or ad
- Adding & Modifying Parts5:201 credit or ad
- Layouts Menu pt. 17:171 credit or ad
- Layouts Menu pt. 26:371 credit or ad
- Format Menu5:341 credit or ad
Layouts Advanced11 lessons
- Arrange Menu7:051 credit or ad
- View Menu7:521 credit or ad
- Inspector Basics3:001 credit or ad
- Inspector - Position Tab5:431 credit or ad
- Inspector - Appearance Tab pt. 16:481 credit or ad
- Inspector - Appearance Tab pt. 24:261 credit or ad
- Inspector - Data Tab7:041 credit or ad
- Insert Menu4:481 credit or ad
- Positioning Objects Precisely6:011 credit or ad
- Other Tools pt. 14:131 credit or ad
- Other Tools pt. 25:221 credit or ad
Working with Container Fields7 lessons
Auto-Entry8 lessons
Validation6 lessons
Printing19 lessons
- Layout Assistant5:041 credit or ad
- Printing Philosophy3:571 credit or ad
- Creating a Print Layout7:191 credit or ad
- Contact List6:401 credit or ad
- Print Options4:021 credit or ad
- Labels5:441 credit or ad
- Adjusting Labels5:251 credit or ad
- Merge Letters6:591 credit or ad
- More Merge Letters8:231 credit or ad
- Sliding Objects6:381 credit or ad
- Envelopes2:441 credit or ad
- Building a Report6:071 credit or ad
- Viewing a Report6:521 credit or ad
- Summarizing a Report4:421 credit or ad
- Varying a Report5:111 credit or ad
- Improved Contact List pt. 16:491 credit or ad
- Improved Contact List pt. 24:251 credit or ad
- Quick Charts4:331 credit or ad
- Charting in Reports5:231 credit or ad
Scripting and Calculations22 lessons
- Definition of a Script5:031 credit or ad
- Basic Script5:331 credit or ad
- Script Steps with Depth7:531 credit or ad
- Evil Script Steps5:381 credit or ad
- Activating Scripts6:491 credit or ad
- Definition of a Calculation5:491 credit or ad
- Basic Calculation4:551 credit or ad
- Layout Navigation4:371 credit or ad
- Record Navigation2:061 credit or ad
- More Scripts2:581 credit or ad
- Manage Scripts4:381 credit or ad
- Deleting a Record5:531 credit or ad
- Printing a Layout6:231 credit or ad
- Open Script4:471 credit or ad
- Open Script Considerations6:211 credit or ad
- Close Script4:571 credit or ad
- Recreate the Status Toolbar6:121 credit or ad
- Case vs. If5:181 credit or ad
- Billing or Shipping Labels4:161 credit or ad
- Fixing the Label Calculation4:211 credit or ad
- Age Display6:461 credit or ad
- Birthdays Find5:491 credit or ad
Importing and Exporting8 lessons
Miscellanneous Features10 lessons
- Global Fields Defined5:291 credit or ad
- Custom Report Title6:161 credit or ad
- Multi-User Global Fields3:481 credit or ad
- Repeating Fields6:311 credit or ad
- Furigana4:031 credit or ad
- Spell Checking5:501 credit or ad
- Find/Replace5:221 credit or ad
- Send Email6:131 credit or ad
- Tooltips5:001 credit or ad
- Tab Order3:151 credit or ad