Want a NOOK? Explore Now
If you use Microsoft Access in your every day business life but haven't learned to fully exploit the program, now's your chance. Automating Microsoft Access with VBA is a thorough introduction to programming Microsoft Accessing using Visual Basic for Applications (VBA). With this book, you will gain a working knowledge of VBA and be able to customize your Microsoft Access databases. You will cover topics that include:
| 1 | Why access? : why VBA? | 9 |
| 2 | Getting around in the Visual Basic Editor | 17 |
| 3 | Using variables, constants, and data types | 33 |
| 4 | Using procedures | 45 |
| 5 | Choosing the right VBA function | 57 |
| 6 | Using flow-of-control statements | 91 |
| 7 | Working with arrays | 105 |
| 8 | Understanding objects | 113 |
| 9 | Understanding scope and lifetime | 131 |
| 10 | Working with forms | 145 |
| 11 | Analyzing the Access event model | 161 |
| 12 | Working with list and combo boxes | 175 |
| 13 | Working with other controls | 195 |
| 14 | Working with reports | 209 |
| 15 | Working with the application collections | 223 |
| 16 | Retrieving data with ADO | 237 |
| 17 | Manipulating data with ADO | 253 |
| 18 | Creating objects with ADOX | 273 |
| 19 | Performing advanced data operations | 287 |
| 20 | Working with data files | 301 |
| 21 | Automating other applications | 313 |
| 22 | Working with XML files | 325 |
| 23 | Using the Windows API | 337 |
| A | Review of Access SQL | 347 |
Overview
If you use Microsoft Access in your every day business life but haven't learned to fully exploit the program, now's your chance. Automating Microsoft Access with VBA is a thorough introduction to programming Microsoft Accessing using Visual Basic for Applications (VBA). With this book, you will gain a ...