Follow us


MERCURY LEARNING and INFORMATION provides print and digital content in the areas of science and medicine, technology and computing, engineering, and mathematics (STEM disciplines) designed for the professional/reference, trade, library, higher education, career school, and online training markets. We embrace both traditional and innovative publishing models designed to accommodate the needs of the intended audience by using the appropriate delivery methods.

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

Julitta Korol

ISBN: 978-1-942270-84-3
Pub Date:  June 2016
Specs: 7 x 9   Paperback
Pages: 900
Price: $54.95

Microsoft Access 2016 Programming by Example with VBA, XML, and ASP takes nonprogrammers through detailed steps of creating Access databases from scratch and shows them how to retrieve and manage their data programmatically using various programming languages and techniques. With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with Structured Query Language (SQL); enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports; and program Microsoft Access databases for Internet access with Active Server Pages (ASP)  and Extensible Markup Language (XML). The book, which covers the latest release of Access 2016 and earlier versions, is divided into nine parts (32 chapters) that progressively introduce you to programming Access .mdb and .accdb databases.



1. Getting Started. 2. Getting to Know Visual Basic Editor (VBE). 3. Access VBA Fundamentals. 4. Access VBA Built-in and Custom Functions 5. Adding Decisions to your Access VBA Programs. 6. Adding Repeating Actions to Access VBA Programs. 7. Keeping Track of Multiple Values Using Arrays. 8. Keeping Track of Multiple Values Using Object Collections. 9. Getting to Know Built-in Tools for Testing and Debugging Built-in and Custom Functions.        


Julitta Korol is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written over 20 computer books including Microsoft Excel 2013 Programming with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.


Issue while running some of the Chapter 11 VBA procedures on the Windows 64-bit machine.
As you might have already discovered, you will need to use the Microsoft.ACE.OLEDB.12.0 Provider instead of Microsoft.Jet.OLEDB.4.0 when executing the code in a mixed Windows environments. The Jet database engine is only 32-bit and does not run natively under 64-bit versions of Windows. The ACE database engine basically provides the 64-bit version of Jet so you can read and write .mdb files from earlier versions of Access and also work with the default .accdb file format. When the book was written, the 32-bit was commonplace for processors and suited 99% of people, hence the code focused on using the Jet Provider. This will be corrected in future editions.