Access Cookbook (Paperback)

Ken Getz, Andy Baron, Paul Litwin

  • 出版商: O'Reilly
  • 定價: $1,650
  • 售價: 6.0$990
  • 語言: 英文
  • 頁數: 720
  • 裝訂: Paperback
  • ISBN: 0596000847
  • ISBN-13: 9780596000844
  • 相關分類: Access
  • 立即出貨(限量) (庫存=7)

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

商品描述

Access Cookbook contains a comprehensive collection of problems, solutions,and practical examples for the Access power user or programmer who is running up against some of the apparent limits of the Access user interface
or of Access application development. The diverse problems and solutions presented here are of interest to Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated.

Each of the book?s 14 chapters focuses on a particular topic area related to the Access environment or Access programming. Within each chapter, individual items follow a standardized format. The authors first pose the problem, and then present its solution. Finally, a discussion follows, which consists of extended analysis of the solution, an insightful examination of how Access works, or interesting programming techniques that are used in the
solution but that you can also apply elsewhere.

The kinds of problems posed and solved in the book include the following:

  • Specifying query criteria at runtime, rather than at design time
  • Restricting the user to a single row of a form
  • Preventing a report from printing if it has no records
  • Making slow forms run faster
  • Insuring that user interface objects present a uniform, consistent appearance
  • Controlling a printer's paper source programmatically
  • Referencing data from multiple SQL Server databases in a single Access Data Project page
  • Using contact information from an Access database when sending email using Outlook



The accompanying CD-ROM includes Access databases that contain the solutions for all problems presented in the text.

Table of Contents

Preface

1. Queries

2. Forms

3. Reports

4. Developing and Distributing Applications

5. Taming Your Printer

6. Managing Data

7. Exploring VBA in Microsoft Access

8. Optimizing Your Application

9. Making the Most of Your User Interface

10. Multiuser Applications

11. The Windows API

12. Automation

13. Using Data Access Pages

14. Working with SQL Server Data

Index

商品描述(中文翻譯)

《Access Cookbook》包含了一系列針對Access高級使用者或程式設計師所遇到的問題、解決方案和實際範例。這些問題和解決方案對於Access高級使用者和程式設計師都具有吸引力,無論是相對不熟練的使用者還是最熟練的使用者都能從中受益。

書中的14個章節分別聚焦於與Access環境或Access程式設計相關的特定主題。在每個章節中,個別項目都遵循標準化的格式。作者首先提出問題,然後提出解決方案。最後,進行討論,包括對解決方案的深入分析、對Access工作原理的深入探討,或者是在解決方案中使用的有趣的程式設計技巧,這些技巧也可以應用在其他地方。

書中提出和解決的問題包括以下內容:
- 在運行時指定查詢條件,而不是在設計時
- 限制使用者只能在表單中編輯一行
- 如果報表沒有記錄,防止其列印
- 提高運行緩慢的表單的運行速度
- 確保使用者介面物件呈現統一、一致的外觀
- 以程式方式控制打印機的紙張來源
- 在單個Access資料專案頁面中引用來自多個SQL Server資料庫的資料
- 在使用Outlook發送電子郵件時使用Access資料庫中的聯絡資訊

附帶的CD-ROM包含了包含文本中所有問題解決方案的Access資料庫。

目錄:
- 前言
- 1. 查詢
- 2. 表單
- 3. 報表
- 4. 應用程式開發和分發
- 5. 控制打印機
- 6. 數據管理
- 7. 探索Microsoft Access中的VBA
- 8. 優化應用程式
- 9. 充分利用使用者介面
- 10. 多用戶應用程式
- 11. Windows API
- 12. 自動化
- 13. 使用資料存取頁面
- 14. 使用SQL Server資料
- 索引