Access Hacks (Paperback)

Ken Bluttman

  • 出版商: O'Reilly
  • 出版日期: 2005-05-24
  • 定價: $825
  • 售價: 5.0$413
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Paperback
  • ISBN: 0596009240
  • ISBN-13: 9780596009243
  • 相關分類: Access
  • 立即出貨(限量) (庫存=1)




As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly.

This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features.

A smart collection of insider tips and tricks, Access Hacks covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to:

  • work with Access in multi-user environments
  • utilize SQL queries
  • work with external data and programs
  • integrate Access with third-party products

Just imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else.

Part of O'Reilly's best-selling Hacks series, Access Hacks is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.


Table of Contents:



Chapter 1. Core Access 

      1. Help Users Find the Objects They Need  

      2. Personalize Your Access Application  

      3. Work Fast and Avoid Typos  

      4. Optimize Data Changes  

      5. Transfer Data Between Versions of Access  

      6. Organize and Enhance Your Macros  

      7. Rid Your Database of Clutter  

      8. Protect Valuable Information  

      9. Work with Any Amount of Data  

      10. Find Database Objects in a Snap  

      11. Use a Junction Table  

      12. Stop the Database from Growing  

Chapter 2. Tables 

      13. Create an AutoNumber Field with a Custom Value  

      14. Copy Data Between Tables Without an Append Query  

      15. Steer Clear of System Tables  

      16. Hide Sensitive Information  

      17. Simulate Table Triggers  

      18. Create Tables Faster  

Chapter 3. Entry and Navigation 

      19. Help Users Navigate Through Long Forms  

      20. Help Users Enter Additional Text  

      21. Let Users Add Custom Items to Predesigned Lists  

      22. Populate and Sort Lists with Flair  

      23. Use Custom Controls on Your Forms  

      24. Confirm Record Updates Before Saving  

      25. Put a Clock on a Form  

      26. Be Tab-Smart  

      27. Highlight the Active Control  

Chapter 4. Presentation 

      28. Separate Alphabetically Sorted Records into Letter Groups  

      29. Create Conditional Subtotals  

      30. Use Conditional Formatting to Point Out Important Results  

      31. Provide a Direct Link to a Report  

      32. Protect Intellectual Property  

      33. Create a Slideshow in Access  

      34. Play Videos in Access Forms  

      35. View Reports Embedded in Forms  

      36. Put Line Numbers on a Report  

      37. Shade Alternating Lines on a Report  

      38. Save Paper by Reducing Whitespace  

      39. Include the Date, Time, and Page Count  

Chapter 5. Queries and SQL 

      40. Return a Sample of Records  

      41. Create Bulletproof Insert Operations  

      42. Find Unmatched Records on Multiple Field Keys  

      43. Place a Grand Total in a Query  

      44. Sort Any Arbitrary String of Characters  

      45. Summarize Complex Data  

      46. Get All Combinations of Data  

      47. Don't Let Nulls Ruin Data Summaries  

      48. Use a Custom Function in a Query  

      49. Create Access Tables with SQL Server Scripts  

      50. Use Wildcards in Queries  

      51. Get Cleaner Or-Based Criteria  

      52. Get Cleaner And-Based Criteria  

      53. Create an Outer Join  

      54. Use Regular Expressions in Access Queries  

Chapter 6. Multiuser Issues 

      55. Test for Duplication  

      56. Distribute a Split Database with Predefined Table Links  

      57. Build a Time-Out Feature  

      58. Implement Unique Usernames  

Chapter 7. External Programs and Data 

      59. Import Noncontiguous Ranges of Data from Excel  

      60. Use Excel to Reorient Access Data  

      61. Use Excel Functions Inside Access  

      62. Use Word to Compare Data in Two Access Tables  

      63. Import Varied XML Data into Access  

      64. Export XML Data Sanely  

      65. Break Through VBA's Transformation Barrier  

      66. Leverage SQL Server Power by Calling Stored Procedures  

      67. Manage Word Documents from Access  

      68. Use Access as a Front End to MySQL  

      69. Send Access Data Through Outlook Automatically  

      70. Create Access Tables from Outside Access  

      71. Write VBA with the Macro Recorder in Word and Excel  

Chapter 8. Programming 

      72. Store Initial Control Selections for Later Recall  

      73. Write Code Faster by Turning Off Syntax-Checking  

      74. Substitute Domain Aggregate Functions for SQL Aggregate Functions  

      75. Shrink Your Code with Subroutines  

      76. Shrink Your Code with Optional Arguments  

      77. Protect Programming Code from Curious Users  

      78. Build a Secret Developer Backdoor into Your Applications  

      79. Help Users Drill Down to a Record  

      80. Prevent Users from Disabling Your Startup Options  

      81. Inform Users of a Long Process  

      82. Allow Users to Choose a Back-End Database  

      83. Override the Timeout Interval  

      84. Save Values from Unbound Controls for Later Recall  

      85. Sort Records Randomly  

      86. Bulk-Update Controls on a Form  

      87. Provide Complete XML Control to Any Version of Access  

      88. Use Custom Enumerations  

      89. Convert Text to the Desired Case  

      90. Create a Code Library  

      91. Automatically Check for Database Table Updates  

Chapter 9. Third-Party Applications 

      92. Document Your Database with Total Access Analyzer  

      93. Build an Application Shell with EZ Application Generator  

      94. Load Your Database with Test Data  

      95. Use Access as an XML Database  

Chapter 10. The Internet 

      96. Export a Report as HTML  

      97. Use a Browser Inside Access  

      98. Pull the HTML Source Code from a Web Site  

      99. Download Files Using the Web Browser Control  

      100. Use a Smart Tag to Open a Web Page  



作為Microsoft Office套件的一部分,Access已成為行業領先的桌面數據庫管理程序,用於組織、訪問和共享信息。但要利用這個產品來構建越來越複雜的Access應用程序,需要的不僅僅是一本典型的入門書。需要的是O'Reilly出版的《Access Hacks》。這本寶貴的指南提供了直接、實用的解決方案,可以幫助使用者解決掌握該程序的各種複雜性所帶來的挫折感。對於有經驗的用戶,《Access Hacks》提供了一系列經過驗證的技巧和工具,使他們能夠將其數據庫技能和生產力提升到更高的水平。對於Access初學者,它幫助他們獲得對該程序最有效功能的牢固掌握。《Access Hacks》是一本內幕技巧和訣竅的智慧集,涵蓋了該程序的所有細節。在眾多討論的主題中,它向用戶展示了如何在多用戶環境中使用Access、利用SQL查詢、處理外部數據和程序、將Access與第三方產品集成等。想象一下:一個沒有煩惱的學習過程。《Access Hacks》輕鬆實現了這一點,感謝這些不同於其他地方的實用技巧。作為O'Reilly最暢銷的Hacks系列的一部分,《Access Hacks》基於作者Ken Bluttman在數據庫編程和業務應用構建方面的二十年實踐經驗。正是由於他的豐富經驗,這本書能夠提供對該程序不斷擴展的可能性如此深入的理解。

1. 核心Access
1. 幫助用戶找到所需的對象
2. 個性化您的Access應用程序
3. 快速工作,避免錯誤
4. 優化數據更改
5. 在不同版本的Access之間傳輸數據
6. 組織和增強您的宏
7. 清除數據庫中的雜物
8. 保護有價值的信息
9. 處理任意數量的數據
10. 快速查找數據庫對象
11. 使用聯接表
12. 阻止數據庫的增長

2. 表
13. 創建具有自定義值的自動編號字段
14. 在不使用附加查詢的情況下複製表之間的數據
15. 避免系統表
16. 隱藏敏感信息
17. 模擬表觸發器
18. 更快地創建表

3. 輸入和導航
19. He