|
Overview
You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totalled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the information in various ways, and locate specific pieces of information efficiently. In this course, you will use FileMaker Pro 9 to create and use databases for storing and organizing information so that it is available for efficient retrieval.
Course Objectives
You will use FileMaker Pro 9 to create and use databases to store and organize information.
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. Previous experience with an earlier version of FileMaker Pro or other database software is recommended, but not required.
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.
Certification
This course is one of a series of courseware titles that addresses Microsoft Certified Applications Specialist (MCAS) skill sets. The MCAS program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Applications Specialist certification.
Performance-Based 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.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Platform Requirements
- Microsoft Windows XP with Service Pack (SP) 2, Windows Server 2003
with SP1, or later operating system.
Hardware Requirements
- An Intel-compatible computer Pentium 90 or higher
- At least 32 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
- FileMaker Pro 9
- Microsoft Office 2007
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 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
|
