Wiley 978-0-470-08277-5 Arkusz Danych

What Is aDatabase?Before exploring FileMaker Pro 8, you must understandwhat a database is. A database is an organized collectionof information, usuall

12Part I ✦ The FundamentalsFigure 1-3: A standarddatabase layout.On the other hand, you can customize a database layout by doing any of the following:

13Chapter 1 ✦ What Is a Database?Figure 1-4: A custom layout.Figure 1-5: Layouts for a phone book (a) and mailing labels (b).No practical restrictions

14Part I ✦ The Fundamentalsan address label layout. Conversely, you do not have to place every field that youdefine on a layout. You might want to cre

15Chapter 1 ✦ What Is a Database?✦ Sub-summaries: You use sub-summary parts to summarize groups of relatedrecords after you have sorted the database b

16Part I ✦ The FundamentalsThe four modes are indicated by small, iconic buttons in the Tool area at the topleft of a FileMaker window. Browse is the

17Chapter 1 ✦ What Is a Database?Thus, when you want to enter a new record, you must switch to Browse mode. Tomodify any portion of a layout (to add o

18Part I ✦ The Fundamentalsentry form. Features such as date-stamping and assigning serial numbers canbe automatically applied to each new voucher. An

19Chapter 1 ✦ What Is a Database?✦ Maintain a home inventory. If you know anyone who has had a large casualtyloss due to a burglary, fire, or natural

20Part I ✦ The Fundamentalsto be able to print the information. A database program is also a better choicewhen you want to perform calculations on the

4Part I ✦ The FundamentalsEvery database — whether on paper, in a hand-held electronic organizer, or in acomputer — is composed of records in tables.

5Chapter 1 ✦ What Is a Database?Figure 1-1: Every database comprises records that contain fields.When consistency is critical, such as when you’re rec

6Part I ✦ The FundamentalsLimitations of paper databasesFirst, consider some of the shortcomings of paper databases:✦ Making data-entry errors is easy

7Chapter 1 ✦ What Is a Database?✦ Entering error-free information is easier. Most database programs have featuresthat speed data entry. Setting defaul

8Part I ✦ The Fundamentals✦ Many people can simultaneously access the database. If several people in acompany need to view or modify the information i

9Chapter 1 ✦ What Is a Database?✦ Are calculations necessary? The more complex the calculations, the more youneed a database program.✦ Is printed outp

10Part I ✦ The Fundamentalsor projects that have complex requirements. Another significant advantage of rela-tional databases is their ability to reus

11Chapter 1 ✦ What Is a Database?Until FileMaker Pro 7, each FileMaker Pro database file contained a single table,which resulted in solutions that cou