FileMaker Pro 11: Beginner
by John Mark Osborne
Start the free chapterFileMaker 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 and 11 including field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting, interface design and new FIleMaker Pro 11 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.
Course content
Introduction12 lessons
- About John Mark Osborne3:35Free
- System Requirements3:41Free
- FileMaker 11 Family of Products pt. 16:02Free
- FileMaker 11 Family of Products pt. 25:07Free
- About the Tutorial Series pt. 16:23Free
- About the Tutorial Series pt. 25:51Free
- Why an Invoicing Solution? pt. 14:54Free
- Why an Invoicing Solution? pt. 25:39Free
- What is a Database? pt. 15:04Free
- What is a Database? pt. 23:31Free
- Planning Your Solution7:03Free
- New FileMaker 11 Features7:38Free
Creating a Database10 lessons
- Quick Start3:391 credit or ad
- New Empty File7:121 credit or ad
- Creating Fields pt. 14:261 credit or ad
- Creating Fields pt. 24:431 credit or ad
- Housekeeping Fields pt. 15:141 credit or ad
- Housekeeping Fields pt. 23:511 credit or ad
- Housekeeping Fields pt. 34:541 credit or ad
- Adding Fields to a Layout6:331 credit or ad
- Modifying & Organizing Fields5:521 credit or ad
- Other Tabs6:501 credit or ad
Working with the Database16 lessons
- Data Entry4:461 credit or ad
- Importing Data pt. 15:421 credit or ad
- Importing Data pt. 23:191 credit or ad
- Importing Data pt. 34:301 credit or ad
- Recurring Import4:471 credit or ad
- Status Toolbar8:061 credit or ad
- Customizing the Status Toolbar1:421 credit or ad
- The Four Modes7:391 credit or ad
- Records Menu pt. 16:251 credit or ad
- Records Menu pt. 25:241 credit or ad
- Records Menu pt. 32:361 credit or ad
- Preview Mode5:221 credit or ad
- New Layout pt. 16:011 credit or ad
- New Layout pt. 23:201 credit or ad
- Table View6:171 credit or ad
- Schema from Table View2:171 credit or ad
Finding & Sorting14 lessons
- Basic Find6:541 credit or ad
- How the Index Works6:441 credit or ad
- New Requests6:451 credit or ad
- Range Finds7:291 credit or ad
- Wildcards5:401 credit or ad
- The Rest of the Operators8:061 credit or ad
- Found Sets without Find Mode4:501 credit or ad
- Constrain & Extend2:521 credit or ad
- Sorting Records pt. 14:251 credit or ad
- Sorting Records pt. 23:401 credit or ad
- New Window3:511 credit or ad
- Quick Find1:571 credit or ad
- Save Find Requests5:021 credit or ad
- Snapshot Links3:061 credit or ad
Modifying Layouts10 lessons
- Status Toolbar pt. 14:061 credit or ad
- Status Toolbar pt. 24:061 credit or ad
- Arrow Tool5:361 credit or ad
- Field Tool5:041 credit or ad
- Text Tool pt. 16:131 credit or ad
- Text Tool pt. 24:041 credit or ad
- Text Tool pt. 33:371 credit or ad
- Line Tool3:091 credit or ad
- Rectangles & Ovals6:441 credit or ad
- More with Text Blocks5:441 credit or ad
Modifying Layouts Advanced16 lessons
- Tab Control pt. 15:441 credit or ad
- Tab Control pt. 25:141 credit or ad
- Field Control7:041 credit or ad
- Value Lists8:451 credit or ad
- Parts Overview5:441 credit or ad
- Adding & Modifying Parts5:221 credit or ad
- Layouts Menu pt. 17:301 credit or ad
- Layouts Menu pt. 27:551 credit or ad
- Format Menu5:301 credit or ad
- Inspector pt. 16:401 credit or ad
- Inspector pt. 27:231 credit or ad
- Arrange Menu6:161 credit or ad
- View Menu4:121 credit or ad
- Layout Badges7:091 credit or ad
- Positioning Objects Precisely6:551 credit or ad
- Other Tools7:111 credit or ad
Working with Container Fields5 lessons
Auto-Entry8 lessons
- Serial Numbers pt. 17:301 credit or ad
- Serial Numbers pt. 25:401 credit or ad
- Value from Last Visited2:591 credit or ad
- Calculated Auto-Enter pt. 14:481 credit or ad
- Calculated Auto-Enter pt. 26:491 credit or ad
- Lookups pt. 14:311 credit or ad
- Lookups pt. 24:021 credit or ad
- Lookups pt. 35:131 credit or ad
Validation6 lessons
Printing19 lessons
- Enhanced Report Assistant3:551 credit or ad
- Printing Philosophy3:491 credit or ad
- Creating a Print Layout pt. 14:141 credit or ad
- Creating a Print Layout pt. 24:241 credit or ad
- Contact List6:001 credit or ad
- Print Options3:211 credit or ad
- Labels4:491 credit or ad
- Adjusting Labels4:591 credit or ad
- Merge Letters7:001 credit or ad
- More Merge Letters6:071 credit or ad
- Sliding Objects6:531 credit or ad
- Envelopes2:551 credit or ad
- Building a Report5:251 credit or ad
- Viewing a Report5:511 credit or ad
- Summarizing a Report4:381 credit or ad
- Varying a Report3:301 credit or ad
- Improved Contact List pt. 16:411 credit or ad
- Improved Contact List pt. 24:121 credit or ad
- Charting in Reports7:161 credit or ad
Scripting & Calculations23 lessons
- Definition of a Script4:321 credit or ad
- Basic Script5:281 credit or ad
- Script Steps with Depth6:051 credit or ad
- Evil Script Steps5:391 credit or ad
- Activating Scripts5:171 credit or ad
- Definition of a Calculation4:281 credit or ad
- Basic Calculation6:181 credit or ad
- Layout Navigation3:281 credit or ad
- Record Navigation3:001 credit or ad
- Perfect Highlights3:361 credit or ad
- More Scripts4:581 credit or ad
- Manage Scripts6:061 credit or ad
- Deleting a Record6:231 credit or ad
- Printing a Layout6:301 credit or ad
- Open Script4:151 credit or ad
- Open Script Considerations6:361 credit or ad
- Close Script4:341 credit or ad
- Recreate the Status Toolbar4:281 credit or ad
- Case vs. If5:001 credit or ad
- Billing or Shipping Labels4:321 credit or ad
- Fixing the Label Calculation4:491 credit or ad
- Age Display5:321 credit or ad
- Birthdays Find5:481 credit or ad
Importing & Exporting9 lessons
- Import & Export Defined6:521 credit or ad
- Importing FileMaker Files4:251 credit or ad
- Updating FileMaker Files3:201 credit or ad
- Importing a Folder5:381 credit or ad
- Data Sources7:051 credit or ad
- Exporting Files4:341 credit or ad
- Group By6:461 credit or ad
- Export to HTML3:001 credit or ad
- Importing Schema5:361 credit or ad
Miscellaneous Features11 lessons
- Global Fields Defined5:311 credit or ad
- Custom Report Title5:571 credit or ad
- Multi-User Global Fields3:191 credit or ad
- Repeating Fields5:391 credit or ad
- Furigana4:011 credit or ad
- Spell Checking5:101 credit or ad
- Find/Replace5:181 credit or ad
- Engraving & Embossing7:161 credit or ad
- Send Email5:171 credit or ad
- Tooltips4:401 credit or ad
- Tab Order3:061 credit or ad