part I. Access VBA primer: Getting started with Access VBA ; Getting to know Visual Basic Editor (VBE) ; Access VBA fundamentals ; Access VBA built-in and custom functions ; Adding decisions to your Access VBA program ; Adding repeating actions to your Access VBA programs ; Keeping track of multiple values using arrays ; Keeping track of multiple values using object collections ; Getting to know built-in tools for testing and debugging -- part II. Access VBA programming with DAO and ADO: Data access technologies in Microsoft Access ; Creating and accessing database tables and fields ; Setting up primary keys, indexes, and table relationships ; Finding and reading records ; Working with records ; Creating and running queries with DAO/ADO ; Using advanced ADO/DAO features ; Implementing database security -- part III. Programming with the Jet data definition language: Creating, modifying, and deleting tables and fields ; Enforcing data integrity and relationships between tables ; Defining indexes and primary keys ; Database security ; Views and stored procedures -- part IV. Enhancing the user experience: Enhancing Access forms ; Using form events ; Events recognized by controls ; Enhancing Access reports and using report events ; Advanced event programming ; Programming the user interface -- part V. VBA and macros: Macros and templates -- part VI. Taking your VBA programming skills to the web: Access and active server pages ; XML features in Access 2019.