Access 2007 is vastly different in many ways from Access 2003, such as the revamped user interface that uses “ribbons,” among other differences. However, Access 2007 VBA has not changed a whole lot since the prior versions of Access. The VBA interface for Access 2007 still uses the same old user interface as before, not the ribbons that Access 2007 uses. The VBA language syntax has not changed very much either. Even if you are using a prior version of Access, you can still gain a lot from this book. However, there will be some examples that deal with features only supported in Access 2007.
After reading this book, you will learn:
Basic programming life-cycle and architecture concepts
How VBA can be used for professional application development
The basics of programming using VBA
Basic object-oriented programming techniques using VBA
How to use existing objects
How to create custom objects
How to use ActiveX Data Objects (ADO) to retrieve and update data
How to retrieve data from external data sources
How to create reports and web content from the database
How to integrate with Office applications
How to integrate with SharePoint Lists
How to build SQL Server solutions with Access projects
How to fine-tune and distribute the application