Access 2021 / Microsoft 365 Programming by Example. Mastering VBA for Data Management and Automation Chorzów

Updated for Access 2021 and based on bestselling editions, this book is a practical guide on Access programming, perfect for users proficient with the Access UI. It introduces programming concepts through illustrated hands-on exercises and custom projects. You will learn to write and test code with the Visual Basic Editor, use VBA structures like conditions, loops, arrays, collections, and dictionaries, and reprogram database characteristics.The book covers building database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO), defining database objects, and managing database security with SQL. It explores enhancing user interaction with Ribbon customizations and event programming in forms and reports. Additionally, you'll learn to use Access with XML and REST API.From getting started with Access VBA to advanced event programming and macros, this book ensures a comprehensive understanding of Access programming. It transitions readers from basic to advanced topics, equipping them with the knowledge and tools to automate Access routine tasks effectively. Spis treści: 1. Getting Started with Access VBA2. Getting to Know Visual Basic Editor (VBE)3. Access VBA Fundamentals4. Access VBA Built-In and Custom Functions5. Adding Decisions to Your Access VBA Programs6. Adding Repeating Actions to Your Access VBA Programs7. Keeping Track of Multiple Values Using Arrays8. Keeping Track of Multiple Values Using Collections9. Getting to Know Built-In Tools for Testing and Debugging10. Data Access Technologies in Microsoft Access11. Creating and Manipulating Databases with DAO12. Creating and Manipulating Databases with ADO13. Creating, Modifying, and Deleting Tables and Fields14. Enforcing Data Integrity and Relationships between Tables15. Defining Indexes and Primary Keys16. Views and Stored Procedures17. Implementing Database Security with DDL18. Implementing User-Level and Share-Level Security19. Enhancing Access Forms20. Using Form Events21. Events Recognized by Form Controls22. Enhancing Access Reports and Using Report Events23. Customizing the Menu System in Access24. Creating Classes in VBA25. Advanced Event Programming26. Macros and Templates27. XML Features in Access 202128. Access and REST API