|
Overview
You have probably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information such as contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker database cannot manage data that needs to be accessed from multiple tables spread in different database files.
In addition, you are required to share your database with other users on a network. In this course, you will set up an integrated database system dealing with data found in multiple database files. You will also make the database accessible to someone in the same office, or anyone who is searching for information using a web browser without compromising on the security by taking the necessary precautions.
Course Objectives
You will create a database model based on relationships between tables that hold data. You will automate tasks based on scripts, work with functions and data found in external data sources. In addition, you will publish your database on the web and provide utilitarian features to users.
Prerequisites
Before taking this course, students should have completed the FileMaker Pro 9: Level 1 course. In addition, they 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, and formatting text, and so on.
Target Student:
This course is for the students who have some experience using FileMaker Pro and are aware that their need for managing data exceeds their current capabilities. In addition, this course is for the FileMaker Pro 9 user that needs to share databases with other users on a network or over the Internet.
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:
- create relationships between tables in a database file.
- create buttons to perform tasks.
- access data from external FileMaker sources or files found
in an external database.
- enhance the layout of your database.
- prepare and publish your database on the web.
- follow some of the best practices to keep data safe and
prevent information loss.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Platform Requirements
- Microsoft® Windows® XP SP2 or Vista.
Hardware Requirements
- Intel® Pentium® II or higher (Pentium® III/IV-class
recommended)
- 256 MB RAM (512 MB RAM recommended)
- 5 GB hard disk or higher if you use Windows XP Professional
as your operating system. You should have at least 600 MB free hard-disk space
for Microsoft Office installation
- Access to one of the following: a local CD-ROM drive, a local
DVD drive, or access to a networked CD-ROM drive
- Mouse or other pointing device
- Network cards and cabling for local network access
- Internet access (see your local network administrator)
- Printer (optional)
- Projection system to display the instructor's computer screen
Software Requirements
- Microsoft® Windows® XP SP2 or Vista
- Default Installation of FileMaker Pro 9
- Default installation of Microsoft® Office® 2007
- Printer driver (Printers are not required; however, each PC
must have an installed printer driver to use Print Preview.)
- MySQL Server Community Edition 5.0 or above
- MySQL-Connector-ODBC version 3.51 or above
- Adobe® Reader® 8.0 and above
Course duration
1 Day
Course outline
- Lesson 1: Creating Relationships Between Databases
- Topic 1A: Create Relationships
- Topic 1B: Access Data Using a Portal
- Topic 1C: Create a Lookup
- Topic 1D: Create a Relationship Using an Intermediate Table
- Topic 1E: Access Data from Related Tables
- Topic 1F: Summarize Related Data
- Topic 1G: Create a Value List
- Lesson 2: Creating Buttons
- Topic 2A: Create Buttons to Execute Simple Tasks
- Topic 2B: Create Buttons to Execute Complex Tasks
- Topic 2C: Create Buttons to Execute Scripts
- Lesson 3: Sharing and Exchanging Data
- Topic 3A: Share a Database with All Users on a Network
- Topic 3B: Share a Database Based on a Predefined Privilege Set
- Topic 3C: Share
a Database Based on a Customized Privilege Set
- Topic 3D: Access Remote Data
- Topic 3E: Access Data from External Data Sources
- Lesson 4: Enhancing the Database Layout
- Topic 4A: Add Tab Control
- Topic 4B: Create a Layout Using Fields from Related Tables
- Topic 4C: Enhance the Layout
- Lesson 5: Publishing a Database on the Web
- Topic 5A: Prepare a Database for Publishing
- Topic 5B: Publish a Database for the Web
- Topic 5C: Work with the Web Viewer Tool
- Lesson 6: Protecting Data
- Topic 6A: Create Backup of Database files
- Topic 6B: Maintain Data Security
|
