FileMaker Pro X Bible

( 1 )

Overview

  • Updated to cover the latest program version, this comprehensive guide helps users make the most of FileMaker Pro, the sophisticated workgroup database application with nine million registered users
  • Offers complete step-by-step guidance on FileMaker Pro features and tasks, covering both the Mac and Windows versions
  • Features expanded coverage of ODBC, JDBC, and XML connectivity and includes a new chapter on the...
See more details below
Paperback (BK&CD-ROM)
$40.18
BN.com price
(Save 10%)$44.99 List Price
Other sellers (Paperback)
  • All (19) from $1.99   
  • New (5) from $13.27   
  • Used (14) from $1.99   
Sending request ...

Overview

  • Updated to cover the latest program version, this comprehensive guide helps users make the most of FileMaker Pro, the sophisticated workgroup database application with nine million registered users
  • Offers complete step-by-step guidance on FileMaker Pro features and tasks, covering both the Mac and Windows versions
  • Features expanded coverage of ODBC, JDBC, and XML connectivity and includes a new chapter on the developer tools used to create more complex databases
  • Other topics covered include calculations and computations, data exchange, creating and using templates, linking databases, using FileMaker in workgroups, Web publishing, plug-ins, and advanced database connectivity
Read More Show Less

Product Details

  • ISBN-13: 9780764543470
  • Publisher: Wiley
  • Publication date: 12/22/2003
  • Series: Bible Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 932
  • Product dimensions: 7.40 (w) x 9.24 (h) x 2.00 (d)

Meet the Author

Dennis R. Cohen has been developing software and writing about it since the late 1970s. Starting in the Jet Propulsion Laboratory’s Deep Space Network (DSN), through stints at Ashton-Tate, Claris, and Aladdin Systems, he was involved in creating and maintaining such packages as the DSN Station Scheduling System, dBASE III, dBASE Mac, FileMaker, ClarisWorks, Claris Resolve, and many others.
During this time, Dennis wrote numerous articles appearing in a variety of different publications, including Personal Computing, Macintosh Today, Macworld, and MacTutor. The author (or co-author) of over a dozen books, including AppleWorks 6 Bible, AppleWorks 6 For Dummies, Mac OS X Bible, iLife Bible, Teach Yourself Visually iLife ’04 (all Wiley), and Mac Digital Photography (Sybex), Dennis has also been the technical editor for over 100 titles, including all previous editions of FileMaker Pro Bible.
Dennis resides in Sunnyvale, California, with his best friend — a Boston terrier named Spenser. You can find out more about him at his Web site at http://homepage.mac.com/drcohen.

In 1978, Dr. Steven Schwartz bought his first microcomputer, a new Apple II+. Determined to find a way to make money with it, he began writing software reviews, BASIC programs, and user tips for Nibble magazine. Shortly thereafter, he was made a contributing editor.
Over the past 20 years, Steve has written hundreds of articles for more than a dozen computer magazines. He currently writes for Macworld magazine. He was also a founding editor of Software Digest as well as a business editor for MACazine. From 1985 to 1990, he was the director of technical services for Funk Software.
Steve is the author of more than 40 books, including all editions of Macworld ClarisWorks/AppleWorks Bible and the FileMaker Pro Bible (Wiley); Running Microsoft Office 2001 (Microsoft Press); Visual QuickStart Guide for Internet Explorer 5 for Windows, Internet Explorer 5 for Macintosh, Entourage 2001 for Macintosh, CorelDraw 10 for Windows, and Office v.X for Macintosh (Peachpit Press); and dozens of popular game strategy guides.
Steve has a Ph.D. in psychology and presently lives in the fictional town of Lizard Spit, Arizona, where he writes books and complains about the heat. His official Web site is www.siliconwasteland.com.

Read More Show Less

Table of Contents

Preface.

Acknowledgments.

Part I: The Fundamentals.

Chapter 1: What Is a Database?

Chapter 2: FileMaker Pro Basic Operations.

Chapter 3: What’s New in FileMaker Pro 7?

Part II: Database Design Basics.

Chapter 4: Creating Your First Database.

Chapter 5: Defining Fields.

Chapter 6: Layouts.

Chapter 7: Setting Preferences.

Part III: Working with Databases.

Chapter 8: Working with Records.

Chapter 9: Searching for and Selecting Records.

Chapter 10: Sorting Records.

Chapter 11: Reports.

Chapter 12: Using the Spelling Checker.

Chapter 13: Printing.

Part IV: Putting FileMaker Pro to Work.

Chapter 14: Calculations and Computations.

Chapter 15: Automating FileMaker Pro.

Chapter 16: Exchanging Data.

Chapter 17: Creating and Using Templates.

Part V: Mastering FileMaker Pro.

Chapter 18: Linking Tables: Relationships and Lookups.

Chapter 19: Using FileMaker Pro in Workgroups.

Chapter 20: Web Publishing with FileMaker Pro.

Chapter 21: Advanced Database Connectivity with XML and ODBC/JDBC.

Chapter 22: Expanding FileMaker’s Capabilities Using Plug-Ins.

Part VI: Developing Databases for Others to Use.

Chapter 23: Designing Databases for Others.

Chapter 24: Debugging Scripts.

Chapter 25: Generating Database Reports.

Chapter 26: Creating Custom Database Solutions.

Part VII: Appendixes.

Appendix A: Macintosh Keyboard Shortcuts.

Appendix B: Windows Keyboard Shortcuts.

Appendix C: FileMaker Pro Function Reference.

Appendix D: Glossary.

Appendix E: Resources.

Appendix F: About the CD.

Index.

End-User License Agreement.

Read More Show Less

First Chapter

FileMaker Pro 7 Bible


By Steven A. Schwartz Dennis R. Cohen

John Wiley & Sons

ISBN: 0-7645-4347-4


Chapter One

What Is a Database?

Before exploring FileMaker Pro 7, you must understand what a database is. A database is an organized collection of information, usually with one central topic. In a computer database (as opposed to a paper database), the program that you use to enter and manipulate the data is a database program or a database management system (DBMS).

The word organized is a key part of this definition. Otherwise, a shoebox stuffed with business receipts might be considered a database. In general, if you must look at every scrap of data until you find the one for which you're searching, you don't have a database. You just have a shoebox full of stuff.

Even if you've never used a computer database management system, you're already familiar with many examples of paper (and probably computer) databases:

* Address books and business card files

* Employee records

* Recipe card files

* Telephone books

* Holiday greeting card lists

Every database-whether on paper, in a hand-held electronic organizer, or in a computer-is composed of records in tables. A record contains information that has been collected on one individual or entity in the database. A table holds the records that you create, and the database encompasses the tables. For example, in the Employee Records database example listed in thepreceding list, you might have one table containing the employees' ID numbers, names, addresses, dates of birth, and dates of hire. Another table might include salary information, and another might include personnel actions (such as review dates and performance history).

In the previously listed examples, a record would hold all the address data on one friend or business associate (the address book or business card file example); the employment information on one employee (the employee records example); the ingredients and cooking instructions for one recipe (the recipe card file example); the name, street address, and phone number for one person or business in the area (the telephone book example); and the name of one person or family from whom you previously received a card or want to send a card to (the holiday greeting card list example).

Note

A database containing more than one table of related information is a relational database. Each related table contains a field in common with the table(s) to which it is related, such as the Employee ID number. FileMaker Pro is a relational database management system (RDBMS).

Records are divided into fields. A field contains a single piece of information about the subject of the record. In an address database, for example, the fields might include first name, last name, street address, city, state, ZIP code, and phone number. Figure 1-1 shows the relationship among the components of a database.

What distinguishes a database from any old hodgepodge of information is that the data within each record is organized. Fields are responsible for this organization. The fields appear in the same place on every record and are reserved for a particular type of information. In the example in Figure 1-1, the field for the last name is always in the upper-left corner of the address card, and it always contains a person's last name. No matter which address card you pull, you will find a last name at that spot on the card.

Of course, in some paper databases, maintaining this level of organization can be difficult. When you are writing or typing an address card, for example, you might occasionally reverse the order of the last and first names or enter a company name in that spot. Organization in informal paper databases comes exclusively from your own consistency-or lack of it.

When consistency is critical, such as when you're recording information on employees or filling out a customer invoice, records are often designed as forms. Spaces on the form have labels so that you always know which piece of information belongs where. You can still type a phone number in the space labeled Social Security number, but at least the labels make catching and correcting mistakes easier. Forms help organize the data in much the same way that a computer-based database does. In fact, this type of paper database is frequently the basis for a computer database.

Paper Databases versus Computer Databases

What's wrong with paper databases? After all, many homes and businesses rely on them. In the following sections, we discuss some shortcomings of paper databases and explain how computer databases can help avoid these limitations.

Limitations of paper databases

First, consider some of the shortcomings of paper databases:

* Making data-entry errors is easy to do. Even when you're using a typeset form, nothing prevents you from entering the wrong data in a field or forgetting to fill in a critical field, such as the hire date or medical history. * Maintenance can be difficult. For records to be easy to locate, they must be in some rational order. Whenever you return or add a record to a folder or the filing cabinet, you must place it in the correct spot. If you put the vendor file for Alpha Corporation in the Q folder, you might never find it again!

* Updating records can be time-consuming. Because of changes in information (such as addresses, phone numbers, and salaries), few databases are static. Updating a paper record could require several steps, including finding the record, erasing the old information, writing in the new information (or typing a whole new record), and returning the form to the filing cabinet. Making an across-the-board change-such as granting an incremental salary increase to all employees-can take a long time.

* Sorting records, selecting subgroups of records, and creating reports are cumbersome tasks. Suppose the boss walks into your office and says, "We're thinking about putting in a day-care center. How many of our 149 employees have kids under the age of five?" Or you might be thinking of sending a direct mail piece to your local customers. To determine printing and postage costs, you must know how many customers are in the target ZIP code or are within a particular range of ZIP codes.

In either case, you'll probably have to examine every record in the paper database. Whenever a task requires sorting, organizing, or summarizing the data in a different way, you can look forward to a nightmare of paper shuffling-hoping that you didn't overlook something important. And when you're through, you'll have to restore all the records to their original order.

* Sharing records is difficult. When a supervisor borrows some employee records, for example, the office manager no longer has easy access to those records unless you decide to kill some trees by photocopying the paperwork. (They're no longer in the file drawer.)

* Information is hard to reuse. If you want to use the information in a paper database for any purpose other than just reading it (addressing envelopes, for example), someone has to drag out the typewriter. Photocopying an address and then taping it onto a letter is considered bad form (unless you're creating a ransom note).

Advantages of computer databases

Computer databases, on the other hand, offer the following benefits:

* Entering error-free information is easier. Most database programs have features that speed data entry. Setting default values for some fields can save an incredible amount of typing time and ensure that information is entered consistently. (Using CA as the default entry for a State field, for example, ensures that you don't end up with records that variously contain CA, Calif., and California in the same field.) Other useful data-entry features include

Auto-incrementing fields (which automatically assign invoice or record numbers to new records)

Field types (which, for example, can prevent you from entering alphabetic information in a field that was designed to record salary data)

Range checking (which accepts only numbers within a particular range)

Required fields (which warn you if you don't fill in a critical field)

* You can easily add, delete, or change data. Making a change to a record merely involves bringing the record up onscreen, editing it, and then closing the file or moving to another record. Because you make all changes on a computer, you don't need to search through file drawers or hunt for an eraser. And if you need additional copies of records, you can quickly print them. The ease with which you can manage data is one of the key reasons for buying and using a database program such as FileMaker Pro.

* Finding records is simple. A Find feature enables you to quickly locate the record or records of interest.

* You can specify criteria for sorting data. Arranging records in a different order is as simple as issuing a Sort command. You can rearrange records in order of salary, record creation date, or any other field that's in the database. Most database programs also enable you to sort by multiple fields simultaneously. For example, you can sort a client database by state and by city within each state.

* You can work with discrete groups of records. Using the database program's record selection tools, you can select a subgroup of records that's based on any criteria you want. You might, for example, want to see only recipes that have chicken as the main ingredient or perhaps group employee records according to salary ranges or by department.

* Database programs can perform calculations, frequently offering many of the same calculation capabilities that spreadsheet programs offer. Instead of using a hand calculator to compute the sales tax and total for an invoice, you can have your database program automatically make the computations. In addition to performing computations within individual records, database programs can also generate summary statistics across all records or for selected groups of records. For example, you can easily summarize the efforts of different sales teams by calculating sales totals and averages by region.

* Many people can simultaneously access the database. If several people in a company need to view or modify the information in a database, you can use a database program on a network. Some database programs-including FileMaker Pro-also enable you to publish and share your data over the Web or a company intranet.

* You can readily use information for multiple purposes. For example, you can use the address information in records to print mailing labels, envelopes, a pocketsized address book, or personalized form letters.

* You can create custom reports. Only you are in a position to decide which reports are essential to running your business, department, class, bowling league, or home. In most database programs, you can create your own reports and lay them out in any format that meets your information needs. Because you can save report formats on disk, you can reuse a format whenever you want to generate a current report.

* You can use data from one program in another program. Most database programs can import and export data.

Importing enables you to bring information into the database from other programs. For example, you might already have an address book program in which you've recorded the addresses of friends and business associates. Rather than retyping those addresses in your database program, you can export them from the original program (creating a file that your database program can read) and then import them into a database.

Exporting, on the other hand, enables you to use fields and records in a database to create a file that other programs can understand. For example, you can easily export numeric data so that you can graph it with a spreadsheet program, such as Microsoft Excel.

When should you use a database program?

Not every database is a good candidate for computerization. Specifically, when deciding between using a paper database and using a computer database, you must ask yourself the following questions. (The more Yes answers you give, the more reasons you have for using a database program.)

* Will the contents of individual records change frequently? If the information for each record isn't static and editing is often necessary, choose a computer database.

* Is much of the information repetitive? A database program can have default entries for fields. If much of the information that you'll enter is repetitive, using a database program can help you avoid unnecessary typing.

* Must the records be grouped or sorted in different ways? Database programs can quickly re-sort and select records for even very large collections of data.

* Are calculations necessary? The more complex the calculations, the more you need a database program.

* Is printed output required? Unless photocopies are satisfactory, use a database program.

* Are reports necessary? Database programs excel at summarizing information. If your reports go beyond simple record counts, a database program might be the best choice.

Flat-File and Relational Databases

You can roughly classify every database program as either flat-file or relational, according to the program's relational capabilities: that is, its capability to simultaneously draw information from more than one table on the basis of shared fields.

That explanation is quite a mouthful, isn't it? A couple of definitions and an example might make it easier to swallow:

* A flat-file database always consists of a single table. All required fields must be contained within that table.

* A relational database consists of at least two interrelated tables that have at least one key field in common.

Instead of designing a single customer table that contains all your customer information (as you would in a flat-file database program), you might create several smaller tables. For example, you could create one table called Addresses to contain just customer addresses, and another called Orders to hold information about the customers' previous orders.

Continues...


Excerpted from FileMaker Pro 7 Bible by Steven A. Schwartz Dennis R. Cohen Excerpted by permission.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 6, 2010

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)