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

Microsoft Access 2019 Programming by Example with VBA, XML, and ASP takes non-programmers 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 2019 and earlier versions, is divided into nine parts (32 chapters) that progressively introduce you to programming Access .mdb and .accdb databases. The text will show you how to write and debug your programming code with the 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 database.

Features:

Updated for MS Access 2019 and previous versions

Includes more than 275 applied examples and 10 projects

Covers Office Web Apps

Companion files with color screen captures, source code, and supplemental files for projects in the text.

eBook Customers: Companion files are available for downloading with order number/proof of purchase by writing to the publisher at info@merclearning.com.

About the Author

Since 1993, Julitta Korol (Long Island, NY) has published over two dozen computer books on using and programming Microsoft Excel and Microsoft Access. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).