skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

FileMaker Pro 7.0: 8 volumes (Mac/PC) (CD-ROMs)
Loan

Self-taught course

Description

A set of 8 tutorials on FileMaker 7.0 from Studio eWorks for both Macintosh & PC. It is not necessary to have FileMaker installed.

System requirements
  • Mac: PowerPC processor, min. monitor display area of 800x600, QuickTime 4.0 (provided on CD).
  • Win: Pentium processor, min. monitor display area of 800x600, QuickTime 4.0 (provided on CD).
Volume 1 - Using FileMaker Pro

Database Concepts, Working Environment, Browsing Records, Working With Data, Finding Records, Symbol Find Requests, Finding In A Portal, Sorting Records, Printing, Editing Tools, Saving Your Work, Replacing Data.

Volume 2 - Building A Database

Define Database, About Fields, Define Fields Intro, Auto-Enter Options, Field Validation, Storage & Indexing, Housekeeping Fields, Calculation Fields, Summary Fields, Auto-Enter Calcs, Calculated Validation, Preferences.

Volume 3 - Layout Design

Layout Tools, Creating Layouts, Modifying Layouts, Custom Value Lists, Field Frames, Field Behavior, Field Formatting, Tab Order, List Layouts, Merge Fields, Displaying Graphics, Dynamic Value Lists.

Volume 4 - Relational Design Part 1

Planning A Database, Entities & Attributes, Types Of Relationships, Key Fields, E-R Diagrams, New Relational Database, Relationships Graph, Define Fields & Keys, Display Related Records, Edit Relationships, Add Records Through Portal, Lookups.

Volume 5 - Relational Design Part 2

Aggregate Functions, Portal Setup Options, Deleting Portal Rows, Go To Related Record, Self-Join Relationships, Using Multiple-Predicates, Non-Equijoin Relationships, Data Tunneling, Multiple Table Occurrences, More Complex Joins, Separate Data & Interface, Deleting A Table Or TO.

Volume 6 - Import/Export & Reporting

Exporting Data, Exporting Data Summary, Importing Text & Excel, Importing >From FileMaker, Importing A Folder, Importing Graphics, Context For Reports, Creating Reports, Aggregate vs Summary, Layout Assistant, Formatting a Report, Multiple Sub-Summary Parts

Volume 7 - Security

Security Basics, Accounts & Passwords, Privilege Sets Intro, Creating New Accounts, New Privilege Sets, Custom Privileges, Other Privileges, Extended Privileges, Custom Extended Privileges, Scripts/Full Access, External Authentication, Restricted Sharing & Access.

Volume 8 - Introduction To Scripting

ScriptMaker Overview, Editing Scripts, Creating Scripts, Scripted Sorts, Scripted Finds, User-Defined Script, Error Checking Script, Modular Scripting, Buttons & Parameters, Controlling Context, Scripted Security, Window Management.

Themes

Booking / availability

Override user: