Visual QuickProject Guide: Creating a Database In FileMaker Pro

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