Chapters in this book

1. Frontmatter i
2. Dedication v
3. CONTENTS vii
4. Acknowledgments. xxxvii
5. Introduction xxxix
6. PART I ACCESS VBA PRIMER
7. Introduction 1
8. Chapter 1 Getting Started with Access VBA 3
9. Chapter 2 Getting to Know Visual Basic Editor (VBE) 27
10. Chapter 3 Access VBA Fundamentals 51
11. Chapter 4 Access VBA Built-In and Custom Functions 85
12. Chapter 5 Adding Decisions to Your Access VBA Programs 109
13. Chapter 6 Adding Repeating Actions to Your Access VBA Programs 131
14. Chapter 7 Keeping Track of Multiple Values Using Arrays 145
15. Chapter 8 Keeping Track of Multiple Values Using Object Collections 173
16. Chapter 9 Getting to Know Built-In Tools for Testing and Debugging 203
17. PART II ACCESS VBA PROGRAMMING WITH DAO AND ADO
18. Introduction 237
19. Chapter 10 Data Access Technologies in Microsoft Access 239
20. Chapter 11 Creating and Accessing Database Tables and Fields 299
21. Chapter 12 Setting Up Primary Keys, Indexes, and Table Relationships 345
22. Chapter 13 Finding and Reading Records 361
23. Chapter 14 Working with Records 409
24. Chapter 15 Creating and Running Queries with DAO/ADO 447
25. Chapter 16 Using Advanced ADO/DAO Features 493
26. Chapter 17 Implementing Database Security 551
27. PART III PROGRAMMING WITH THE JET DATA DEFINITION LANGUAGE
28. Introduction 595
29. Chapter 18 Creating, Modifying, and Deleting Tables and Fields 597
30. Chapter 19 Enforcing Data Integrity and Relationships between Tables 621
31. Chapter 20 Defining Indexes and Primary Keys 635
32. Chapter 21 Database Security 647
33. Chapter 22 Views and Stored Procedures 663
34. PART IV ENHANCING THE USER EXPERIENCE
35. Introduction 679
36. Chapter 23 Enhancing Access Forms 681
37. Chapter 24 Using Form Events 695
38. Chapter 25 Events Recognized by Controls 731
39. Chapter 26 Enhancing Access Reports and Using Report Events 747
40. Chapter 27 Advanced Event Programming 771
41. Chapter 28 Programming the User Interface 793
42. PART V VBA AND MACROS
43. Introduction 863
44. Chapter 29 Macros and Templates 865
45. PART VI TAKING YOUR VBA PROGRAMMING SKILLS TO THE WEB
46. Introduction 921
47. Chapter 30 Access and Active Server Pages 923
48. Chapter 31 XML Features in Access 2016 987
49. Index 1063