Home | About MACC | Clients | DADI | FMP Tutorial | MacFantastique

FMPRO Session 1
A Databases for the Rest of Us

Introduction to Databases-FileMaker Pro

In introductory Macintosh classes, creating or even modifying a database is a daunting, even terrifying idea to the most people. A "database" is a technical, high-tech sounding word. But it is possible for ordinary people who often start out intimidated by computers and databases might actually find the whole process much easier than they thought, even fun. This is especially true of Filemaker Pro. Everyone can make their life easier with a database. Anyone can readily create a useful, functional database and have fun doing it.

Some usual beginner questions:

  • What the heck is a database? click here
  • Why would I want to use one?
  • How do I put together a database that is right for me?
  • What is a relational database? click here rdb

A very common use of a database is to keep track of personal and business contacts (e.g. a PIM = Personal Information Manager.) Because most people can easily grasp this database example, we will use this as a framework for this discussion.

Although FileMaker Pro is used to illustrate the above questions, the principles and ideas are common to most databases for personal computers. Why is FileMaker Pro the best-selling Mac & Windows database program? Because it is simple enough for mere mortals to use but offers much more power than the other programs designed for the masses. Although it does not do everything (some would beg to differ!), it does the most important things very well.

cabibetOverview of the Database Basics –Key Concepts & Main Topics

What is a Database?

  • Database Terminology
  • Database files
  • Database elements
  • Records
  • Fields

Zen and the Art of Database Management

  • A Continual process
  • Test drive databases
  • Samples
  • Templates

Why Use a Database? Reasons ( how helpful )

  • More efficient and flexible at:
    Storing Information
    Retrieving Information
    Manipulating data
    Printing Information
  • Manual vs Electronic

    Setting Up a Database
    Content vs. Structure
    The Design Process
    Mind Picture
    Creating Fields
    Creating Layouts
    Tool Palette

Design Insights

  • Just Do it!
  • Redo, redo, redo it!
  • Keep it simple!
  • Rapid Application Development (A RAD acronym)

Installation

  • Installing FileMaker Pro
  • Requirements
  • Before Installation

Overview of the Parts

  • fmpNew Features in FileMaker Pro 3/4/5/6/7 and beyond(whew)
  • Field Types

  next - Updated Tuesday, July 12, 2005

Jump Menu