|
Overview
You will use FileMaker® Pro 10 to create and use databases to store and organize information.
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.
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.
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 duration
1 Day
Course outline
- 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
|
