Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP

Julitta Korol

  • 出版商: Mercury Learning
  • 出版日期: 2016-08-11
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 900
  • 裝訂: Paperback
  • ISBN: 1942270844
  • ISBN-13: 9781942270843
  • 相關分類: AccessExcelXML
  • 無法訂購

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

商品描述

Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to info@merclearning.com). With concise and straightforward explanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a "message box"; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to program Microsoft Access databases for Internet access with Active Server Pages (Classic ASP), HTML, and XML.

Features:

+ Contains over thirty chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code and how to test it and then run it.

+ Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to info@merclearning.com).

+ Explains how to store data for further manipulation in variables, arrays, and collections while teaching you to write both simple and complex VBA programming routines and functions.

+ Teaches you how to programmatically create and access database tables and fields.

+ Shows you how to insert, update, and delete data via programming code using various data access techniques.

+ Gets you proficient creating and running simple and parameterized queries against your Access databases.

+ Gets you comfortable using external data sources with Access (Excel, Word, flat files, XML, and SQL Server).

+ Teaches you how to take control of your forms and reports by writing programming code known as event procedures.

+ Shows you how to use various types of macros and templates.

+ Takes your programming skills to the Web by introducing you to dynamic XML and Classic ASP pages.

On the disc:
(Also available from the publisher for download by writing to info@merclearning.com).

+ All source code and supplemental files for the Hands-On exercises and custom projects

+ All images from the text (including 4-color screenshots)

商品描述(中文翻譯)

《Microsoft Access 2016 Programming by Example with VBA, XML and ASP》是一本基於Access 2016並根據之前版本的暢銷書籍進行更新的實用指南,適合已熟悉Access使用者介面(UI)的讀者。如果您希望自動化Access的例行任務,本書將通過多個實例化的實作練習逐步介紹您程式設計的概念。更高級的主題則通過自定義專案進行演示。附帶一個包含原始碼、補充文件和彩色螢幕截圖的全面光碟(也可通過向info@merclearning.com寫信向出版商索取下載)。本書以簡明直接的解釋方式,教您如何使用內建的Visual Basic Editor編寫和測試程式碼;了解並使用常見的VBA程式設計結構,如條件、迴圈、陣列和集合;編寫「訊息方塊」;重新設定資料庫的特性;以及使用各種技術查詢和操作Access的.mdb和.accdb資料庫。本書還向您展示如何使用資料存取物件(DAO)和ActiveX資料物件(ADO)建立資料庫解決方案;使用SQL定義資料庫物件並管理資料庫安全性;通過自訂功能表和事件程式設計改進和修改使用者與資料庫應用程式的互動方式。您還將學習如何使用Active Server Pages(Classic ASP)、HTML和XML為Microsoft Access資料庫進行網路存取。

特點:
+ 包含超過30個章節,充滿了實例化的「實作練習」和專案,引導您學習VBA程式設計語言。每個範例都告訴您在哪裡輸入程式碼,如何測試並運行它。
+ 附帶一個包含原始碼、補充文件和彩色螢幕截圖的全面光碟(也可通過向info@merclearning.com寫信向出版商索取下載)。
+ 解釋如何將資料存儲在變數、陣列和集合中以進行進一步操作,同時教您編寫簡單和複雜的VBA程式設計例程和函數。
+ 教您如何以程式設計方式創建和存取資料庫表格和欄位。
+ 向您展示如何使用各種資料存取技術通過程式碼插入、更新和刪除資料。
+ 幫助您熟練地使用Access對資料庫進行簡單和參數化查詢。
+ 幫助您使用外部資料來源與Access(Excel、Word、平面檔案、XML和SQL Server)進行互動。
+ 教您如何通過編寫事件程序的程式碼來控制表單和報表。
+ 向您展示如何使用各種類型的巨集和範本。
+ 通過介紹動態XML和Classic ASP頁面,將您的程式設計技能擴展到網路。

光碟內容:
(也可通過向info@merclearning.com寫信向出版商索取下載)
+ 所有實作練習和自定義專案的原始碼和補充文件。
+ 所有來自本書的圖片(包括彩色螢幕截圖)。