FileMaker® Pro 9: Level 1 (Macintosh)
Course Specifications
Course number: 084284
Course length: 1.0 day(s)
Course Description
Course Objective: You will use FileMaker® Pro 9 to create and use databases to
store and organize information.
Target Student: The target students for this course are office personnel or business
owners with little or no experience using FileMaker Pro, with a need to build
a database for storing, organizing, and sharing resource information. Students
may have experience using office productivity applications, such as a word
processor or spreadsheet program, but may have little or no experience using
a robust database.
Prerequisites: Students should be familiar with the basic functions of
their computer’s operating system. Students should also have basic word
processing skills, such as copying, pasting, formatting text, and so on. Experience with an earlier version of FileMaker Pro or other database software
is recommended, but not required.
Hardware Requirements
- PowerPC G3, G4, G5 or Intel-based Mac
- 256 MB of RAM
- A CD-ROM drive
- VGA or higher video adapter and monitor
- Keyboard and mouse or other input device
- Network cards and cabling for local network access
- Printer
- Projection system to display the instructor's computer screen
Software Requirements
Each computer requires the following software:
- FileMaker® Pro 9
- Microsoft® Office® 2008
Course Objectives
Upon successful completion of this course, students will be able to:
- explore the various elements of the FileMaker Pro 9 environment.
- set up a database.
- modify a database.
- format layouts for a database.
- create columnar reports.
- finalize a database.
Course Content
- Lesson 1: Exploring the FileMaker Pro Environment
- Topic 1A: Explore the FileMaker Pro Interface
- Topic 1B: Customize the Interface
- Topic 1C: Access FileMaker Pro Help
- Lesson 2: Setting
Up a Database
- Topic 2A: Create a Database
- Topic 2B: Import Data into a Database
- Lesson 3: Modifying a Database
- Topic 3A: Find Records
- Topic 3B: Edit Records
- Topic 3C: Calculate Field Data Automatically
- Topic 3D: Create Automated Fields
- Topic 3E: Validate Fields
- Topic 3F: Sort Records
- Lesson 4: Formatting
Layouts for a Database
- Topic 4A: Position
and Resize Fields
- Topic 4B: Modify Field Control
- Topic 4C: Add Objects
- Topic 4D: Apply Conditional Formatting
- Topic 4E: Create Repeating Fields
- Topic 4F: Set the Tab Order
- Lesson 5: Creating Columnar Reports
- Topic 5A: Create a Columnar Report Layout
- Topic 5B: Create Summary Data
- Topic 5C: Create Sub-Summary Data
- Lesson 6: Finalizing a Database
- Topic 6A: Spell Check a Database
- Topic 6B: Create a Personalized Form Letter
- Topic 6C: Export a Database
- Topic 6D: Print Database Records