Sale!

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

Amazon.com Price:  $46.70 (as of 18/04/2019 23:01 PST- Details)

Categories: , , , , , , , , , , , ,

Description

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’re looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via a lot of 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 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 quite a lot of techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you’ll be able to build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; beef up and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn 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 whilst 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 the usage of quite a lot of data access techniques.

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

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

+ Teaches you how to take keep watch over of your forms and reports by writing programming code referred to as event procedures.

+ Shows you how to use quite a lot of 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)

Related products

Home » Shop » Books » Subjects » Computers and Technology » Programming » Microsoft Programming » VBA » Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP

Recent Products