Microsoft® Access® 2016 Programming By Example with VBA, XML, and ASP
Pub Date: June 2016
Specs: 7 x 9 Paperback
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.
- Updated for MS Access 2016 and previous versions
- Includes more than 275 applied examples and 10 projects
- Covers Office Web Apps
- CD with color screen captures, source code, and supplemental files for projects in the text
BRIEF TABLE OF CONTENTS
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.
ABOUT THE AUTHOR
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.