
FileMaker Pro 13: 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 12 and 13. Feature that include: field creation, finding, sorting, layout mode, container fields, auto entry, validation, printing, scripts, calculations, importing,rnexporting, interface design as well as new FIleMaker Pro 13rnfeatures: 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. Click on the links below to begin learning.
Course content
Introduction15 lessons
- About John Mark Osborne4:34Free
- System Requirements2:14Free
- FileMaker 13 Family of Products pt. 14:08Free
- FileMaker 13 Family of Products pt. 24:00Free
- About the Tutorial Series pt. 14:50Free
- About the Tutorial Series pt. 23:22Free
- Why an Invoicing Solution?2:58Free
- Work Files2:08Free
- What is a Database? pt. 14:26Free
- What is a Database? pt. 25:27Free
- Planning your Solution5:52Free
- New FileMaker 13 Features Overview pt. 16:33Free
- New FileMaker 13 Features Overview pt. 25:45Free
- New FileMaker 13 Features Overview pt. 34:17Free
- New FileMaker 13 Features Overview pt. 44:40Free
Creating a Database9 lessons
- Quick Start5:201 credit or ad
- Considerations6:391 credit or ad
- New Empty File3:551 credit or ad
- Creating Fields7:551 credit or ad
- Housekeeping Fields pt. 14:121 credit or ad
- Housekeeping Fields pt. 24:581 credit or ad
- Adding Fields to a Layout6:561 credit or ad
- New Field Picker4:181 credit or ad
- Modifying and Organizing Fields5:411 credit or ad
Working with a Database13 lessons
- Data Entry5:081 credit or ad
- Importing Data pt. 16:181 credit or ad
- Importing Data pt. 27:141 credit or ad
- Status Toolbar7:531 credit or ad
- Customizing the Status Toolbar3:221 credit or ad
- The Four Modes6:101 credit or ad
- Records Menu pt. 16:031 credit or ad
- Records Menu pt. 26:071 credit or ad
- Previewing Pages3:371 credit or ad
- New Layout pt. 14:191 credit or ad
- New Layout pt. 25:381 credit or ad
- Table View5:361 credit or ad
- Schema from Table View3:141 credit or ad
Finding and Sorting13 lessons
- Basic Find6:291 credit or ad
- How the Index Works6:281 credit or ad
- New Requests5:431 credit or ad
- Range Finds7:321 credit or ad
- Wildcards5:171 credit or ad
- The Rest of the Operators6:421 credit or ad
- Found Sets without Find Mode4:001 credit or ad
- Constrain and Extend4:471 credit or ad
- Sorting Records6:111 credit or ad
- New Window3:251 credit or ad
- Quick Find2:521 credit or ad
- Save Find Requests5:231 credit or ad
- Snapshot Links2:471 credit or ad
Layouts Beginner9 lessons
Layouts Intermediate12 lessons
- Tab Control pt. 17:481 credit or ad
- Tab Control pt. 25:481 credit or ad
- New Slide Control4:401 credit or ad
- New Themes3:101 credit or ad
- Field Control and New Field Picker4:431 credit or ad
- Value Lists7:281 credit or ad
- Explicit Layout Size3:491 credit or ad
- Parts Overview5:371 credit or ad
- Adding & Modifying Parts5:011 credit or ad
- Layouts Menu pt. 16:121 credit or ad
- Layouts Menu pt. 27:221 credit or ad
- Format Menu5:191 credit or ad
Layouts Advanced15 lessons
- Arrange Menu6:451 credit or ad
- View Menu pt. 17:251 credit or ad
- View Menu pt. 25:111 credit or ad
- Inspector Basics3:251 credit or ad
- Inspector - Position Tab pt. 15:051 credit or ad
- Inspector - Position Tab pt. 23:511 credit or ad
- Inspector - New Styles Tab and Themes4:251 credit or ad
- Inspector - Appearance Tab pt. 18:161 credit or ad
- Inspector - Appearance Tab pt. 25:531 credit or ad
- Inspector - Data Tab8:541 credit or ad
- Insert Menu5:131 credit or ad
- Positioning Objects Precisely7:011 credit or ad
- Button Tool4:341 credit or ad
- Web Viewer Tool4:321 credit or ad
- Smart Duplicate and Select Same3:031 credit or ad
Working with Container Fields7 lessons
Auto-Entry8 lessons
- Serial Numbers pt. 17:151 credit or ad
- Serial Numbers pt. 26:471 credit or ad
- Value from Last Visited4:381 credit or ad
- Calculated Auto-Enter pt. 13:581 credit or ad
- Calculated Auto-Enter pt. 26:431 credit or ad
- Lookups pt. 15:241 credit or ad
- Lookups pt. 26:321 credit or ad
- RecordID and UUID7:111 credit or ad
Validation6 lessons
Printing19 lessons
- Printing Philosophy3:561 credit or ad
- Creating a Print Layout8:021 credit or ad
- Contact List pt. 15:261 credit or ad
- Contact List pt. 23:241 credit or ad
- Print Options4:331 credit or ad
- Labels4:561 credit or ad
- Adjusting Labels5:031 credit or ad
- Merge Letters6:181 credit or ad
- More Merge Letters6:031 credit or ad
- Tabs3:001 credit or ad
- Envelopes2:451 credit or ad
- Building a Report3:581 credit or ad
- Viewing a Report6:231 credit or ad
- Summarizing a Report3:131 credit or ad
- Varying a Report4:261 credit or ad
- Improved Contact List pt. 17:131 credit or ad
- Improved Contact List pt. 23:581 credit or ad
- Quick Charts5:171 credit or ad
- Charting in Reports3:391 credit or ad
Scripting and Calculations22 lessons
- Definition of a Script5:211 credit or ad
- Basic Script6:111 credit or ad
- Script Steps with Depth5:371 credit or ad
- Evil Script Steps5:541 credit or ad
- Activating Scripts7:331 credit or ad
- Definition of a Calculation6:331 credit or ad
- Basic Calculation5:181 credit or ad
- Layout Navigation4:181 credit or ad
- Record Navigation1:581 credit or ad
- More Scripts4:291 credit or ad
- Manage Scripts5:231 credit or ad
- Deleting a Record6:531 credit or ad
- Printing a Layout6:311 credit or ad
- Open Script4:351 credit or ad
- Open Script Considerations6:191 credit or ad
- Close Script4:501 credit or ad
- Recreate the Status Toolbar6:011 credit or ad
- Case vs. If4:281 credit or ad
- Billing or Shipping Labels4:191 credit or ad
- Fixing the Label Calculation4:531 credit or ad
- Age Display5:501 credit or ad
- Birthdays Find4:401 credit or ad
Importing and Exporting8 lessons
Miscellanneous Features10 lessons
- Global Fields Defined3:521 credit or ad
- Custom Report Title6:251 credit or ad
- Multi-User Global Fields3:291 credit or ad
- Repeating Fields5:521 credit or ad
- Furigana3:491 credit or ad
- Spell Checking4:201 credit or ad
- Find/Replace4:531 credit or ad
- Send Email5:091 credit or ad
- Tooltips4:341 credit or ad
- Tab Order3:461 credit or ad