Sams Teach Yourself FileMaker 7 in 24 Hours
暫譯: Sams 24小時自學FileMaker 7

Jesse Feiler

Sams Teach Yourself FileMaker 7 in 24 Hours
  • 出版商: SAMS
  • 出版日期: 2004-05-04
  • 售價: $1,180
  • 貴賓價: 9.5 折 $1,121
  • 語言: 英文
  • 頁數: 504
  • 裝訂: Paperback
  • ISBN: 0672325780
  • ISBN-13: 9780672325786
  • 相關分類: Maker

    • 已絕版

買這商品的人也買了...

相關主題

商品描述

A step-by-step introduction to the latest version of the popular FileMaker database system for desktops, LANs, and the Internet.

  • The only entry-level tutorial that teaches FileMaker from the ground up and offers complete coverage of the latest version of the software.
  • Covers how to customize the out-of-the-box databases as well as create databases and FileMaker solutions from scratch.
  • Discusses how to network databases on LANs and the Internet, develop Web-based interfaces to databases, and manage database security.
  • Previously announced in 9/2003 catalog.
Sams Teach Yourself FileMaker in 24 Hours provides a step-by-step introduction to using FileMaker from its out-of-the-box templates to totally customized database solutions on the desktop, LANs, and the Internet. The book proceeds to help beginners understand how they can tweak and modify templates to make them fit their needs more precisely, and it provides them with the steps they need to create a working database. It also provides examples calculations and scripts, and it can aid Web designers in moving to the next level of Web development, from building Web pages to designing sites that are dynamic and database-driven.

Jesse Feiler is the author of a number of Mac OS X books. He has worked as a developer and manager for companies such as the Federal Reserve Bank of New York, Prodigy, and Apple. His interests in new forms of te3chnical training have led him to MediaSchool, for which he has authored several Mac OS X courses available over the Internet in conjunction with Apple Developer Connection. He appears regularly on WAMC, Northeast Public Radio, on their Roundtable and Vox Pop shows.

Table of Contents:

Introduction.
I: GETTING STARTED WITH FILEMAKER—USING THE TEMPLATES.

Hour 1: Introducing FileMaker.

A Brief History of FileMaker. The FileMaker Market. How FileMaker Works: Overview. Talking About FileMaker: A Guide to Terminology. Talking About FileMaker: The Product Line. Introducing the FileMaker Templates. Summary. Q&A. Workshop.

Hour 2: Using FileMaker and Its Basic Templates.
Exploring the FileMaker Interface. Using the Status Area and FileMaker Modes. Using Basic FileMaker Menus. Working with FileMaker Windows. Working with FileMaker Views. FileMaker Preferences. FileMaker Toolbars. Entering Data. Summary. Q&A. Workshop.

Hour 3: Finding and Sorting Data.

Overview of Finding Data. Creating Find Requests. Omitting Data. Sorting Data. Summary. Q&A. Workshop.

Hour 4: Introducing Layouts.

About Layouts. Using the Layout Status Area. How to Add and Format Fields. Summary. Q&A. Workshop.

Hour 5: Printing Data.

About Printing. Print a Layout. Print Wide and Tall Layouts. Prepare Layouts for Printing: Margins and Sliding. Printing Information About the Database. Printing Envelopes and Labels. Summary. Q&A. Workshop.

II: MODIFYING TEMPLATES AND DATABASES.

Hour 6: Validating and Auto-Entering Data.

About Validation. Setting Auto-Entry Options. Setting Validation Options. Replacing Field Values. Summary. Q&A. Workshop.

Hour 7: Working with Calculations, Formulas, Functions, and Repeating Fields.

About Calculations, Formulas, and Functions. Calculations in Use: The Expense Report Template. Setting Calculation Storage. Working with Repeating Fields. Creating a Calculation. Summary. Q&A. Workshop.

Hour 8: More on Calculations and Functions.

Overview of Functions. Logical Functions. Calculations in the Time Cards Template. Summary. Q&A. Workshop.

Hour 9: Working with Scripts.

About Scripts. Using ScriptMaker. Open ScriptMaker. Create a New Script. Look at a Simple Script. Script Step Categories. Script Steps and the Web. Use Comments in a Complex Script. Attaching Scripts to Layout Elements. Handling Errors in Scripts. Running Scripts Automatically When Files Are Opened or Closed. Summary. Q&A. Workshop.

Hour 10: More on Working with Scripts.

Writing a Find Script. Implementing the Cancel Button with an If Script Step. Specifying Find Requests. Debugging Scripts. Sharing Scripts. Summary. Q&A. Workshop.

Hour 11: Importing and Exporting Data.

About Data Sharing. File Formats. Importing Data into FileMaker. Replacing and Updating Data with Match Fields. Converting Excel Spreadsheets to FileMaker Databases. Exporting Data from FileMaker. Importing from a Folder. Summary. Q&A. Workshop.

Hour 12: Working with ODBC and JDBC.

What Is ODBC? Very Basic SQL. The FileMaker ODBC Example. Setting Up a Data Source on Windows. Setting Up a Data Source on Mac OS X. Importing Data from a Data Source with FileMaker. Summary. Q&A. Workshop.

III: CREATING FILEMAKER SOLUTIONS.

Hour 13: Creating a FileMaker Database.

Database Programming. Creating a Database. Working with Field Types and Repeating Fields. Exploring the Define Database Dialog. Value Lists. File Options. Summary. Q&A. Workshop.

Hour 14: Working with Relationships.

Introducing the Relational Model. Normalizing a Database. Add Tables to a Database. Create Relationships. Relationships to Aliased Tables. Using File References. Using Self-Joins. Working with Contexts. Using Lookup and LookupNext Functions. Summary. Q&A. Workshop.

Hour 15: More About Layouts.

Using Default FileMaker Layouts. Using FileMaker to Create Customized Layouts. Other Layout Settings. Using Related Fields in Layouts. Using Portals for Relationships. Summary. Q&A. Workshop.

Hour 16: Advanced FileMaker Scripting: Design Issues, Script Parameters, and Working with Related Records.

Designing Scripts for FileMaker Solutions and Vice Versa. Using Scripts to Manage Related Records. Using Script Parameters to Add Related Records. Importing Scripts. Summary. Q&A. Workshop.

Hour 17: Working with Summaries and Layout Parts.

Preparing the Parties Database for Reporting. Creating a Report with the FileMaker Assistant. Looking at the Report Parts. Examining the Script. Modifying the Layout. Summary. Q&A. Workshop.

Hour 18: Securing Your Solutions and Databases.

About Security. Overview of FileMaker Security. Defining Accounts. Defining Privileges. Defining Extended Privileges. Turning Security On. Summary. Q&A. Workshop.

Hour 19: Finishing Up: Help, Testing, and Keeping Things Running.

Providing Help and Assistance. Testing FileMaker Solutions. Keeping Things Running. Summary. Q&A. Workshop.

Hour 20: Creating Solutions with @AHEADS = FileMaker Developer. Database Design Report. Using Developer Utilities to Create Standalone Solutions. File Maintenance. Custom Functions. Summary. Q&A. Workshop.

IV: SHARING FILEMAKER SOLUTIONS.

Hour 21: Sharing Databases with @AHEADS = FileMaker Pro. About FileMaker Networking. Adjust Your Firewall. Set Up Sharing with FileMaker Pro. Connecting to a Shared FileMaker Database. Locking Databases (Shared Database Etiquette). Summary. Q&A. Workshop.

Hour 22: Using FileMaker on the Web or an Intranet: Instant Web Publishing.

About Instant Web Publishing. Using the Instant Web Publishing Interface. Publishing a Database Using Instant Web Publishing. Designing for Instant Web Publishing. Summary. Q&A. Workshop.

Hour 23: Using FileMaker and XML with @AHEADS = Other Applications. The XML Difference. Setting Up the Example. Exporting XML. Inside an XML Document. The XML Export File from the Example. What Next? Summary. Q&A. Workshop.

Hour 24: Using FileMaker, XML, and @AHEADS = XSLT. Transforming XML Exports into HTML. A Look at XSLT. Modifying the Simple Table Transformation. Using XPath Expressions to Select and Manipulate Text. Summary. Q&A. Workshop.

V: APPENDICES.

Appendix A: Converting from Previous Versions of FileMaker.

Getting Started with Conversion. Remove Calculations for Relationships. Replace Finds with Nonequal Relationships and Self-Joins. Use Row Numbers in Portals. Sort Portals. Use Timestamp Fields. Use XML. Explore the Instant Web Publishing Script Steps. Use Field Comments.

Appendix B: FileMaker Functions.

Aggregate Functions. Date Functions. Design Functions. Financial Functions. Get Functions. Logical Functions. Number Functions. Repeating Functions. Summary Functions. Text Functions. Text Formatting Functions. Time Functions. Timestamp Functions. Trigonometric Functions.

Appendix C: FileMaker Script Steps.

Control Script Steps. Navigation Script Steps. Editing Script Steps. Fields Script Steps. Records. Found Sets. Windows. Files. Accounts. Spelling. Open Menu Items. Miscellaneous.

Appendix D: Using FileMaker Server.

FileMaker Server. FileMaker Server Advanced.

Index

商品描述(中文翻譯)

一個逐步介紹最新版本的流行 FileMaker 資料庫系統，適用於桌面、區域網路 (LAN) 和互聯網。
- 唯一的入門教程，從基礎開始教學 FileMaker，並提供最新版本軟體的完整覆蓋。
- 涵蓋如何自訂現成的資料庫，以及從零開始創建資料庫和 FileMaker 解決方案。
- 討論如何在區域網路和互聯網上網路化資料庫，開發基於網頁的資料庫介面，並管理資料庫安全性。
- **先前在 2003 年 9 月的目錄中公告。**

《Sams Teach Yourself FileMaker in 24 Hours》提供了使用 FileMaker 的逐步介紹，從其現成的模板到完全自訂的桌面、區域網路和互聯網資料庫解決方案。本書幫助初學者了解如何調整和修改模板，以更精確地滿足他們的需求，並提供創建可運作資料庫所需的步驟。它還提供範例計算和腳本，並能幫助網頁設計師提升到網頁開發的下一個層次，從建立網頁到設計動態和資料庫驅動的網站。

**Jesse Feiler** 是多本 Mac OS X 書籍的作者。他曾在紐約聯邦儲備銀行、Prodigy 和 Apple 等公司擔任開發人員和經理。他對新型技術訓練的興趣使他來到 MediaSchool，並為其撰寫了幾個與 Apple Developer Connection 共同提供的 Mac OS X 課程。他定期在 WAMC、Northeast Public Radio 的 Roundtable 和 Vox Pop 節目中出現。

**目錄：**

**介紹。**
**I: 開始使用 FileMaker—使用模板。**

**第 1 小時：介紹 FileMaker。**
FileMaker 的簡史。FileMaker 市場。FileMaker 的運作方式：概述。談論 FileMaker：術語指南。談論 FileMaker：產品線。介紹 FileMaker 模板。總結。問答。工作坊。

**第 2 小時：使用 FileMaker 及其基本模板。**
探索 FileMaker 介面。使用狀態區域和 FileMaker 模式。使用基本 FileMaker 菜單。處理 FileMaker 視窗。處理 FileMaker 檢視。FileMaker 偏好設定。FileMaker 工具列。輸入資料。總結。問答。工作坊。

**第 3 小時：查找和排序資料。**
查找資料概述。創建查找請求。省略資料。排序資料。總結。問答。工作坊。

**第 4 小時：介紹佈局。**
關於佈局。使用佈局狀態區域。如何添加和格式化欄位。總結。問答。工作坊。

**第 5 小時：列印資料。**
關於列印。列印佈局。列印寬和高的佈局。準備佈局以便列印：邊距和滑動。列印有關資料庫的資訊。列印信封和標籤。總結。問答。工作坊。

**II: 修改模板和資料庫。**

**第 6 小時：驗證和自動輸入資料。**
關於驗證。設定自動輸入選項。設定驗證選項。替換欄位值。總結。問答。工作坊。

**第 7 小時：處理計算、公式、函數和重複欄位。**
關於計算、公式和函數。計算的應用：費用報告模板。設定計算儲存。處理重複欄位。創建計算。總結。問答。工作坊。

**第 8 小時：更多計算和函數。**
函數概述。邏輯函數。時間卡模板中的計算。總結。問答。工作坊。

**第 9 小時：處理腳本。**
關於腳本。使用 ScriptMaker。打開 ScriptMaker。創建新腳本。查看簡單腳本。腳本步驟類別。腳本步驟與網頁。使用註解在複雜腳本中。將腳本附加到佈局元素。處理腳本中的錯誤。當檔案被打開或關閉時自動運行腳本。總結。問答。工作坊。

**第 10 小時：更多處理腳本。**
編寫查找腳本。使用 If 腳本步驟實現取消按鈕。指定查找請求。除錯腳本。共享腳本。總結。問答。工作坊。

**第 11 小時：導入和導出資料。**
關於資料共享。檔案格式。將資料導入 FileMaker。使用匹配欄位替換和更新資料。將 Excel 試算表轉換為 FileMaker 資料庫。從 FileMaker 導出資料。從資料夾導入。總結。問答。工作坊。

**第 12 小時：處理 ODBC 和 JDBC。**
什麼是 ODBC？非常基本的 SQL。FileMaker ODBC 範例。在 Windows 上設置資料來源。在 Mac OS X 上設置資料來源。使用 FileMaker 從資料來源導入資料。總結。問答。工作坊。

**III: 創建 FileMaker 解決方案。**

**第 13 小時：創建 FileMaker 資料庫。**
資料庫編程。創建資料庫。處理欄位類型和重複欄位。探索定義資料庫對話框。值列表。檔案選項。總結。問答。工作坊。

**第 14 小時：處理關係。**
介紹關聯模型。正規化資料庫。向資料庫添加表格。創建關係。對別名表的關係。使用檔案參考。使用自我連接。處理上下文。使用查找和查找下一個函數。總結。問答。工作坊。

**第 15 小時：更多關於佈局。**
使用預設 FileMaker 佈局。使用 FileMaker 創建自訂佈局。其他佈局設定。使用相關欄位在佈局中。使用門戶處理關係。總結。問答。工作坊。

**第 16 小時：進階 FileMaker 腳本：設計問題、腳本參數和處理相關記錄。**
為 FileMaker 解決方案設計腳本，反之亦然。使用腳本管理相關記錄。使用腳本參數添加相關記錄。導入腳本。總結。問答。工作坊。

**第 17 小時：處理摘要和佈局部分。**
準備派對資料庫以便報告。使用 FileMaker 助手創建報告。查看報告部分。檢查腳本。修改佈局。總結。問答。工作坊。

**第 18 小時：保護您的解決方案和資料庫。**
關於安全性。FileMaker 安全性概述。定義帳戶。定義權限。定義擴展權限。啟用安全性。總結。問答。工作坊。

**第 19 小時：完成：幫助、測試和保持運行。**
提供幫助和支援。測試 FileMaker 解決方案。保持運行。總結。問答。工作坊。

**第 20 小時：使用 @AHEADS = FileMaker Developer 創建解決方案。**
資料庫設計報告。使用開發者工具創建獨立解決方案。檔案維護。自訂函數。總結。問答。工作坊。

**IV: 共享 FileMaker 解決方案。**

**第 21 小時：使用 @AHEADS = FileMaker Pro 共享資料庫。**
關於 FileMaker 網路。調整您的防火牆。設置 FileMaker Pro 的共享。連接到共享的 FileMaker 資料庫。鎖定資料庫（共享資料庫禮儀）。總結。問答。工作坊。

**第 22 小時：在網路或內部網路上使用 FileMaker：即時網頁發佈。**
關於即時網頁發佈。使用即時網頁發佈介面。使用即時網頁發佈發佈資料庫。為即時網頁發佈設計。總結。問答。工作坊。

**第 23 小時：使用 FileMaker 和 XML 與 @AHEADS = 其他應用程式。**
XML 的差異。設置範例。導出 XML。XML 文件內部。範例的 XML 導出檔案。接下來怎麼辦？總結。問答。工作坊。

**第 24 小時：使用 FileMaker、XML 和 @AHEADS = XSLT。**
將 XML 導出轉換為 HTML。XSLT 概述。修改簡單的表格轉換。使用 XPath 表達式選擇和操作文本。總結。問答。工作坊。

**V: 附錄。**

**附錄 A: 從舊版本的 FileMaker 轉換。**
開始轉換。刪除關係的計算。用不等關係和自我連接替換查找。使用門戶中的行號。排序門戶。使用時間戳欄位。使用 XML。探索即時網頁發佈腳本步驟。使用欄位註解。

**附錄 B: FileMaker 函數。**
聚合函數。日期函數。設計函數。財務函數。獲取函數。邏輯函數。數字函數。重複函數。摘要函數。文本函數。文本格式函數。時間函數。時間戳函數。三角函數。

**附錄 C: FileMaker 腳本步驟。**
控制腳本步驟。導航腳本步驟。編輯腳本步驟。欄位腳本步驟。記錄。找到的集合。視窗。檔案。帳戶。拼寫。打開菜單項目。其他。

**附錄 D: 使用 FileMaker Server。**
FileMaker Server。FileMaker Server Advanced。

**索引**

類似商品