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

Updatedfor Access 2019 and based on the bestselling editions from previous versions, MicrosoftAccess 2019 Programming by Example with VBA, XML and ASP is a practical,how-to book on Access programming, suitable for readers already proficient withthe Access user interface (UI). If you are looking to automate Access routinetasks, this book will progressively introduce you to programming concepts vianumerous illustrated hands-on exercises. More advanced topics are demonstratedvia custom projects. With concise and straightforward explanations, you learnhow to write and test your programming code with the built-in Visual BasicEditor; understand and use common VBA programming structures such asconditions, loops, arrays, and collections; code a “message box”;reprogram characteristics of a database; and use various techniques to queryand manipulate your Access .mdb and .accdb databases. The book shows you howyou can build database solutions with Data Access Objects (DAO) and ActiveXData Objects (ADO); define database objects and manage database security withSQL; enhance and alter the way users interact with database applications withRibbon customizations and event programming in forms and reports. You alsolearn how to program Microsoft Access databases for Internet access with ActiveServer Pages (Classic ASP), HTML, and XML.

Features:

• Contains over thirty chapters loaded withillustrated “Hands-On” exercises and projects that guide you throughthe VBA programming language. Each example tells you exactly where to entercode 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 furthermanipulation in variables, arrays, and collections while teaching you to writeboth simple and complex VBA programming routines and functions.
• Teaches you how to programmatically createand access database tables and fields.
• Shows you how to insert, update, and deletedata via programming code using various data access techniques.
• Gets you proficient creating and runningsimple and parameterized queries against your Access databases.
• Gets you comfortable using external datasources with Access (Excel, Word, flat files, XML, and SQL Server).
• Teaches you how to take control of yourforms and reports by writing programming code known as event procedures.
• Shows you how to use various types of macrosand templates.
• Takes your programming skills to the Web byintroducing you to dynamic XML and Classic ASP pages.

ONTHE DISC!

(Files are also available by emailing proof of purchase to the publisher at [email protected])

• All source code and supplemental files for the Hands-On exercises and custom projects
• Allimages from the text (including 4-color screenshots)