Brilliant Microsoft Access 2007 VBA

Access is a very powerful development platform for database applications. This book will enable users to take full advantage of the software by automating routine Access tasks.

---

Access is a very powerful development platform for database applications. This book will allow users to take advantage of that power by learning how to process data in large batches, speed up and validate data entry, reduce keystrokes and errors, and control the flow of an application. This book teaches corporate Access users how to navigate the Visual Basic Editor, how to use variables, constants, data types, and procedures, how to choose the right VBA function, how to work with arrays, objects, forms, reports, XML files, data files, and Access SQL.

It covers new topics specific to Access 2007 like Ribbon creation. Specifically, automating navigation, i.e. using the Ribbon, the Navigation pane and the new tabbed interface. The other issues are using the new attachment and multivalue data types.

The book is designed for people who have built some Access applications, but want to take them to the next level of making them easier for end users. The book also demonstrates how to process data for more meaningful analysis.

Even if the reader has never programmed before, they can learn how to use VBA to make work with Access more productive than ever before.

It teaches real-life techniques to help the reader navigate applications more easily.

It builds on the Access skills needed in a business setting and helps the reader do their job more quickly and efficiently.