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

Book Description

The problem: Your boss has demanded a database, and you don't know how to create one. It doesn't matter that it's just a simple one (for tracking invoices, inventory, and contacts), or that flexible, powerful software (FileMaker Pro 7) has already been purchased. If you've never created a database before, the task can be daunting. The solution: This low-priced, compact guide! Recognizing that you don't necessarily want or need to know about every FileMaker Pro 7 feature, this focused, four-color volume demonstrates the quickest route to creating a functional, organized database-nothing more and certainly nothing less. Using large color illustrations and a minimum of verbiage, it provides the basics you need to get going without bogging you down with detailed explanations of all of FileMaker's intricacies. It also serves as the perfect jumping-off point for more extensive database exploration-for example, through FileMaker Pro 7: Visual QuickStart Guide.

Table of Contents

  1. Copyright
    1. Dedication
  2. Special Thanks To...
  3. Introduction
    1. What You’ll Create
    2. How This Book Works
    3. Go to the Web Site
    4. The Next Step
  4. 1. About Databases
    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
  5. 2. Defining Fields
    1. Make a New Database
    2. Create Text Fields
    3. Create the Date Field
    4. Create Number Fields
    5. About Calculations
    6. Create Calculation Fields
    7. About the Default Layout
    8. Review the Field List
    9. Extra Bits
      1. Make a New Database p. 10
      2. Create Text Fields p. 11
      3. Create Number Fields p. 13
      4. About Calculations p. 16
      5. Review the Field List p. 23
  6. 3. Creating the Data Entry Layout
    1. Use the Wizard
    2. About Layout Tools
    3. Remove Unneeded Parts
    4. Set Field Widths
    5. Color the Body Part
    6. Add Background Blocks
    7. Add Divider Bars
    8. Add a Descriptive Title
    9. Place Fields and Labels
    10. Add Section Labels
    11. Align and Format Fields
    12. Set the Tab Order
    13. Save Layout Changes
    14. Extra Bits
      1. Use the Wizard p. 26
      2. About Layout Tools p. 29
      3. Remove Unneeded Parts p. 31
      4. Set Field Widths p. 32
      5. Place Fields and Labels p. 39
  7. 4. Creating the Global Settings Layout
    1. Duplicate a Layout
    2. Edit the Background
    3. Replace the Fields
    4. Set Formatting
    5. Arrange the Fields
    6. Extra Bits
      1. Replace the Fields p. 51
      2. Set Formatting p. 53
      3. Arrange the Fields p. 55
  8. 5. Creating the Blank Forms Layout
    1. Create the Layout
    2. Add the Text
    3. Extra Bits
      1. Create the Layout p. 60
      2. Add the Text p. 64
  9. 6. Creating the Monthly Totals Report
    1. Create the Basic Layout
    2. Edit the Layout
    3. Change Part Colors
      1. Custom Colors on a Macintosh
      2. Custom Colors on a Windows PC
    4. Format Text and Fields
    5. Make Final Adjustments
    6. Extra Bits
      1. Create the Basic Layout p. 68
      2. Edit the Layout p. 72
      3. Change Part Colors p. 75
      4. Format Text and Fields p. 78
  10. 7. Creating the Destination Report
    1. Duplicate the Layout
    2. Group by Destination
    3. Refine the Layout
    4. Create a Trip Count Field
    5. Extra Bits
      1. Group by Destination p. 85
      2. Create a Trip Count Field p. 88
  11. 8. Adding Buttons, Scripts, and Value Lists
    1. Create a Button
    2. Add Data Entry Buttons
    3. Label the Buttons
    4. Create One-Step Scripts
    5. Create the Sort Script
    6. Create the Trip Log Script
    7. Create New Record Script
    8. Define Value Lists
    9. Create Report Scripts
    10. Make a Startup Script
    11. Set the Script Order
    12. Delete the Initial Layout
    13. Extra Bits
      1. Create a Button p. 92
      2. Add Data Entry Buttons p. 94
      3. Create One-Step Scripts p. 96
      4. Create the Sort Script p. 97
      5. Define Value Lists p. 105
      6. Make a Startup Script p. 113
  12. 9. Using the Database
    1. Enter the Global Data
    2. Delete the Test Records
    3. Create the First Record
    4. Create More Records
    5. Use Data Entry Buttons
    6. Find Records
    7. Start a New Year
    8. Customization Tips
    9. Extra Bits
      1. Enter the Global Data p. 122
      2. Create More Records p. 125
      3. Find Records p. 127
      4. Customization Tips p. 129