Microsoft Access 2019 Programming by Example with Vba, XML, and ASP

Korol, Julitta

  • 出版商: Mercury Learning & Information
  • 出版日期: 2019-07-23
  • 售價: $2,490
  • 貴賓價: 9.5$2,366
  • 語言: 英文
  • 頁數: 950
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1683924037
  • ISBN-13: 9781683924036
  • 相關分類: AccessExcelXML
  • 無法訂購

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

相關主題

商品描述

Updated for Access 2019 and based on the bestselling editions from previous versions, Microsoft Access 2019 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. 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 companion disc with source code, supplemental files, and color screen captures (also available from the publisher for download)
  • 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

(Files are also available by emailing proof of purchase to the publisher at 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 2019 Programming by Example with VBA, XML and ASP》是一本基於Access 2019並根據之前版本的暢銷書籍的更新版。這本實用的Access程式設計指南適合已經熟悉Access使用者介面(UI)的讀者。如果您想要自動化Access的例行任務,本書將通過多個實例化的實作練習逐步介紹程式設計概念。更高級的主題則通過自定義專案進行演示。本書以簡潔明瞭的解釋方式,教您如何使用內建的Visual Basic Editor編寫和測試程式碼;了解並使用常見的VBA程式設計結構,如條件、迴圈、陣列和集合;編寫「訊息方塊」;重新編程資料庫的特性;以及使用各種技術查詢和操作Access的.mdb和.accdb資料庫。本書還展示了如何使用資料存取物件(DAO)和ActiveX資料物件(ADO)構建資料庫解決方案;使用SQL定義資料庫物件並管理資料庫安全性;通過自定義功能表和事件程式設計增強和修改用戶與表單和報表的互動方式。您還將學習如何使用Active Server Pages(Classic ASP)、HTML和XML為Microsoft Access資料庫進行網路存取的程式設計。

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

光碟內容:
- 所有「實作練習」和自定義專案的源代碼和補充文件。
- 來自書中的所有圖片(包括彩色螢幕截圖)。

光碟內容可通過向出版商(info@merclearning.com)發送購買證明郵件獲取。