FileMaker® Pro 10: Level 1
Course Specifications
Course number: 084237
Course length: 1.0 day(s)
Course Description
Course Objective: You will use FileMaker® Pro 10 to create and use databases to store and organize information.

Target Student: The target student for this course is office personnel in an academic or a corporate environment with little or no experience using FileMaker® Pro, but who 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: Before taking this course, students should be familiar with the basic functions of their computer’s operating system. Students should also have the basic word processing and office productivity skills. 
Hardware Requirements
•	Intel® Pentium® IV 90 or higher
•	Minimum 32 MB of RAM
•	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 10
•	Microsoft® Office 2007
Course Objectives
Upon successful completion of this course, students will be able to: 
•	explore the various elements of the FileMaker Pro 10 environment.
•	set up a database.
•	modify a database.
•	format layouts in 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 in a Database

Topic 4A: Position and Resize Fields 
Topic 4B: Modify Field Controls 
Topic 4C: Add Objects 
Topic 4D: Apply Conditional Formatting 
Topic 4E: Create Repeating Fields 
Topic 4F: Set Tab Order 
Lesson 5: Creating Columnar Reports

Topic 5A: Create a Columnar Report Layout 
Topic 5B: Create Summary Data 
Topic 5C: Create Subsummary Data 
Lesson 6: Finalizing a Database

Topic 6A: Spell Check a Database 
Topic 6B: Create Personalized Form Letters 
Topic 6C: Export a Database 
Topic 6D: Print Database Records