Tech Integration Project
Lesson Accelerator: Project Launcher

My Book Tracker

Application:	FileMaker Pro 7
Platform:	Mac

Description

The process for creating the example Book Tracker database using FileMaker^® Pro 7 is described below. The Completed Project Movie shows you what the example project might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the database. This project can be easily modified for collecting data for any subject, or extended to track books students read over the year. For a complete project description, including goals, objectives, and materials needed, see the Project Overview.

The Example Project

The Completed Project movie will show you what the completed example project looks like.

Completed Project Movie

			Key #	Length
1.		What the example project looks like	18292	1:19

Go to: Project Overview (Information for Teachers)

Subscribers have access to download the resource materials for this project, which includes all example files, an assessment rubric, and information about adapting and extending the example project.

Creating Your Own Project

We'll begin by creating a new document in FileMaker Pro. The first task will be setting up the database, which involves defining the different data fields and setting some options for those fields. Then, we'll move into adding and editing records within the database. We'll be creating a custom layout and script that will allow us to easily print the book list. The last section will discuss how to export the records and import them into a master file.

A. Setting Up the Database

		Key #	Length
1.	Creating a new file	18270	0:45
2.	Adding Text fields	18271	0:58
3.	Adding other data types	18272	1:29
4.	Defining genre value lists	18273	1:08
5.	Defining rating value list	18274	0:43

B. Working with the Data Entry Layout

		Key #	Length
1.	Editing the field layout	18287	1:21
2.	Positioning the field layout	18275	1:20
3.	Adding a scroll bar	18288	0:35
4.	Adding background colors and text	18276	2:12
5.	Adding Value Lists	18277	1:07

C. Records in the Data Entry Forum

		Key #	Length
1.	Adding a new record	18279	0:52
2.	Adding data to the date field	18280	0:56
3.	Adding a graphic to a container field	18281	1:26
4.	Moving between different view modes	18278	0:47
5.	Describing the Table View options	18289	0:56