You are previewing Creating a Database in FileMaker Pro 8.5: Visual QuickProject Guide.
O'Reilly logo
Creating a Database in FileMaker Pro 8.5: Visual QuickProject Guide

Book Description

If you want to make a great-looking, practical database fast but don't want to get bogged down with the details, then you need a Visual QuickProject Guide!

If you've never created a database before, the task can be daunting. Recognizing that you don't necessarily want or need to know about every FileMaker Pro 8.5 feature, this low-priced, compact guide is the quickest route to creating a functional, organized database. Whether you're a small business owner looking for a better way to track inventory and invoices, someone just looking for a streamlined way to keep track of your contacts, or your boss simply needs a project database, this book covers the FileMaker Pro 8.5 basics, including the new Web Viewer, with full-color illustrations and step-by-step instructions to help you get your project done quickly.

Table of Contents

  1. Copyright
  2. Introduction
    1. What You’ll Create
    2. How this Book Works
    3. Visit the Web Site
    4. The Next Step
  3. 1. About Databases and FileMaker Pro
    1. Database Features
    2. Flat File Vs. Relational
    3. About FileMaker Pro
    4. Extra Bits
      1. Database Features p. 2
      2. Flat File Vs. Relational p. 5
      3. About FileMaker Pro p. 6
  4. 2. Defining the Primary Fields
    1. Make a New Database
    2. About Creating Fields
    3. Create Text Fields
    4. Create Number Fields
    5. Create Date Fields
    6. About Calculations
    7. Create Calculation Fields
    8. About Field Options
    9. Set Auto-Enter Options
    10. Set Validation Options
    11. Set Storage Options
    12. About the Default Layout
    13. Extra Bits
      1. Make a New Database p. 10
      2. Create Text fields p. 12
      3. Create Number fields p. 13
      4. Set Validation Options p. 19
  5. 3. Creating the Data Entry Layout
    1. About Layout Tools
    2. Color the Layout Parts
    3. Format Fields and Labels
    4. Clear Some Space
    5. Add a Tab Control
    6. Add a Background Block
    7. Place Fields in the Block
    8. Place the Footer Field
    9. Place the Savings Fields
    10. Place the Stock Fields
    11. Place the CD Fields
    12. Place the Bond Fields
    13. Set Field Formatting
    14. Set Auto-complete Fields
    15. Name and Save the Layout
    16. Extra Bits
      1. About Layout Tools p. 24
      2. Format Fields and Labels p. 27
      3. Add a Tab Control p. 29
      4. Place Fields in the Block p. 32
      5. Place the Savings Fields p. 35
  6. 4. Creating the Related Tables
    1. Create the Savings Table
    2. Create the Stocks Table
    3. Create the CD Table
    4. Create the Relationships
    5. Define More Fields
    6. Place the New Fields
    7. Create the Portals
    8. Extra Bits
      1. Create Savings Table p. 48
      2. Create Relationships p. 56
      3. Place the New Fields p. 61
      4. Create the Portals p. 63
  7. 5. Making the List Layout
    1. Create a Blank Layout
    2. Format the Layout Parts
    3. Insert the Fields
    4. Add Labels and a Title
    5. Create the View Button
    6. Extra Bits
      1. Create a Blank Layout p. 70
      2. Format Layout Parts p. 71
      3. Create the View Button p. 74
  8. 6. Creating Summary Reports
    1. Create More Fields
    2. The Savings Report
    3. The CD Report
    4. The Savings Bond Report
    5. The Stock Report
    6. Extra Bits
      1. The Savings Report p. 80
      2. The CD Report p. 86
      3. Savings Bond Report p. 90
      4. The Stock Report p. 92
  9. 7. Creating an Account Summary Report
    1. Create the Value Fields
    2. Visit the Wizard
    3. Edit the Layout
  10. 8. Buttons, Scripts, and Value Lists
    1. Define Value Lists
    2. Transaction Buttons
    3. Main Header Buttons
    4. Tab Panel Buttons
    5. Prev/Next Buttons
    6. Go to Tab Script
    7. Create More Scripts
    8. Organize the Scripts
    9. Assign Scripts to Buttons
    10. Set Calendars and Tabs
    11. Extra Bits
      1. Define Value Lists p. 102
      2. Transaction Buttons p. 105
      3. Main Header Buttons p. 108
      4. Tab Panel Buttons p. 110
      5. Prev/Next Buttons p. 111
      6. Go to Tab Script p. 112
      7. Create More Scripts p. 116
  11. 9. Using the Database
    1. Create New Records
    2. Delete Records
    3. Common Procedures
    4. Extra Bits
      1. Create New Records p. 132
      2. Delete Records p. 134
      3. Common Procedures p. 135
  12. 10. Updating to FileMaker Pro 8.5
    1. Add a Ticker Symbol Field
    2. Create the Quotes Tab
    3. Add the Web Viewer
    4. Name the Layout Objects
    5. Add Browser Buttons
    6. Fix the Go to Tab Script
    7. Use the Web Viewer
    8. Extra Bits
      1. The Ticker Symbol Field p. 140
      2. Add the Web Viewer p. 143
      3. Add Browser Buttons p. 147
      4. Use the Web Viewer p. 151