
FileMaker Pro 7
Virtual Training Company 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 below.
Course content
Introducing FileMaker 74 lessons
Entering Data in Browse Mode13 lessons
- Getting Started with FileMaker5:281 credit or ad
- The Browse Mode Menus3:561 credit or ad
- Working with a Data Layout5:221 credit or ad
- Using the Status Area in Browse Mode3:131 credit or ad
- Entering Text2:281 credit or ad
- Using Container Fields5:051 credit or ad
- Inserting Other Data with the Insert Menu2:571 credit or ad
- Using the Records Menu and Auto-Entering Data3:081 credit or ad
- Validation3:181 credit or ad
- Replacing Data1:301 credit or ad
- Using the Browse Mode View Menu3:231 credit or ad
- Using the Toolbars2:471 credit or ad
- Sorting Data3:541 credit or ad
Printing and Presenting Data in Preview Mode5 lessons
Designing the Interface in Layout Mode10 lessons
- Using Layout Mode2:471 credit or ad
- Showing Objects on a Layout pt. 14:161 credit or ad
- Showing Objects on a Layout pt. 23:381 credit or ad
- Working With Rulers2:051 credit or ad
- Using the Status Area2:471 credit or ad
- Using the Status Area Fill and Pen Controls4:131 credit or ad
- Positioning Objects on a Layout by Alignment2:381 credit or ad
- Positioning Objects on a Layout with Tools4:181 credit or ad
- Adding and Formatting Fields3:041 credit or ad
- Other Basic Layout Mode Features3:271 credit or ad
Finding Data in Find Mode8 lessons
- Finding Data the Simple Way2:061 credit or ad
- Constraining and Extending Found Sets4:551 credit or ad
- Using Multiple Find Criteria2:401 credit or ad
- Using Find Requests (OR)2:081 credit or ad
- Using the Status Area and Omitting Records3:221 credit or ad
- Finding Text pt. 13:091 credit or ad
- Finding Text pt. 22:311 credit or ad
- Finding Numbers/Dates/Times4:091 credit or ad
Using the Design Database Dialog12 lessons
- Database Terminology1:451 credit or ad
- Design Database Dialog Basics4:081 credit or ad
- Creating Fields2:321 credit or ad
- Working with Field Types3:341 credit or ad
- Creating Relationships4:011 credit or ad
- Making Databases Robust5:311 credit or ad
- Creating One-to-One Relationships3:041 credit or ad
- Displaying Data in Related Fields2:121 credit or ad
- Displaying Data in Portals4:471 credit or ad
- Using Auto-Enter Field Options3:591 credit or ad
- Using Validation Field Options3:491 credit or ad
- Using Storage Field Options5:281 credit or ad
Putting It Together: Database Design and Layout5 lessons
Advanced Relationships6 lessons
Working with Value Lists5 lessons
More on Layouts10 lessons
- Formatting Numbers pt. 15:551 credit or ad
- Formatting Numbers pt. 22:581 credit or ad
- Formatting Dates4:301 credit or ad
- Formatting Times2:161 credit or ad
- Formatting Graphics2:181 credit or ad
- Formatting Buttons5:191 credit or ad
- Formatting Portals4:281 credit or ad
- Field Formats and Behaviors2:081 credit or ad
- Formatting Borders1:411 credit or ad
- Format Painter3:031 credit or ad
Putting It Together: Improving Data Entry3 lessons
Working with Functions and Calculations18 lessons
- Using the Specify Calculation Dialog pt. 11:401 credit or ad
- Using the Specify Calculation Dialog pt. 22:081 credit or ad
- Using Functions3:301 credit or ad
- Specifying Calculation Storage1:591 credit or ad
- Aggregate Functions4:541 credit or ad
- Date Functions3:591 credit or ad
- Design Functions2:271 credit or ad
- Get Functions3:081 credit or ad
- Logical Functions: If/Case/Choose4:041 credit or ad
- Logical Functions: Let5:061 credit or ad
- Number Functions3:321 credit or ad
- Repeating Functions4:291 credit or ad
- Summary Functions3:571 credit or ad
- Text Functions pt. 13:121 credit or ad
- Text Functions pt. 21:081 credit or ad
- Text Formatting Functions1:411 credit or ad
- Time and Timestamp Functions2:261 credit or ad
- Trigonometric/Custom/External Functions1:191 credit or ad
Introducing Scripts14 lessons
- Introducing ScriptMaker3:001 credit or ad
- Using the ScriptMaker Edit Window4:151 credit or ad
- Using Script Parameters2:281 credit or ad
- Running Scripts Automatically2:261 credit or ad
- Control6:351 credit or ad
- Navigation pt. 15:041 credit or ad
- Navigation pt. 22:101 credit or ad
- Editing1:261 credit or ad
- Fields1:071 credit or ad
- Records4:261 credit or ad
- Found Sets4:261 credit or ad
- Windows5:031 credit or ad
- Files2:311 credit or ad
- Accounts/Spelling/Open Menu Item/Misc.4:391 credit or ad
Summaries and Design8 lessons
- Fleshing Out the Database4:161 credit or ad
- Implementing the Relationships4:311 credit or ad
- Using Summary Fields on Layouts3:561 credit or ad
- Creating a Summary Layout pt. 12:341 credit or ad
- Creating a Summary Layout pt. 25:201 credit or ad
- Creating a Summary Layout pt. 36:541 credit or ad
- Creating a Summary Layout pt. 42:171 credit or ad
- Improving the Database: Joins for Searching4:011 credit or ad