Brilliant Microsoft Access 2007 VBA by Scott Diamond

Brilliant Microsoft Access 2007 VBA by Scott Diamond

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.

Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20 plus years, he has designed databases on a wide range of platforms, including dBASE, FoxPro, SQL/DS, Lotus Approach, Lotus Notes and, for the past 10 years, Microsoft Access. Scott has worked as an in-house and freelance consultant and support professional to firms who are among the leaders of their industries. Scott spends some of his free time answering questions at the premier site for Access support: http://www.utteraccess.com.

SKU	Unavailable
ISBN 13	9780273717041
ISBN 10	0273717049
Title	Brilliant Microsoft Access 2007 VBA
Author	Scott Diamond
Condition	Unavailable
Binding Type	Paperback
Publisher	Pearson Education Limited
Year published	2008-05-29
Number of pages	408
Cover note	Book picture is for illustrative purposes only, actual binding, cover or edition may vary.