{"title":"Scott Diamond","description":null,"products":[{"product_id":"brilliant-microsoft-access-2007-vba-book-scott-diamond-9780273717041","title":"Brilliant Microsoft Access 2007 VBA","description":"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.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49528153538833,"sku":"GOR003448198","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53056366575889,"sku":"GOR004863798","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0273717049.jpg?v=1751164761"},{"product_id":"microsoft-office-access-2007-vba-book-scott-diamond-9780789737311","title":"Microsoft Office Access 2007 VBA","description":"Business Solutions       Microsoft® Office Access 2007 VBA       Develop your Access 2007 VBA expertise instantly with proven techniques       Microsoft Office Access 2007 VBA builds on the skills you’ve already developed in creating database applications and helps you take them to the next level—using Visual Basic for Applications (VBA) to accomplish things you once performed manually. To facilitate this lofty goal, Access includes the VBA programming language. Even if you’ve never programmed, this book will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before. Microsoft Office Access 2007 VBA is for professionals who use Microsoft Access frequently in their daily work. You have serious work to get done and you can’t spend all day reading a computer book. This book teaches you the essential skills you need to automate your databases as quickly as possible.   Although written for Access 2007, the techniques and concepts covered will work in most versions of Microsoft Access.       Highlights of This Book Include             •        Navigating within the Visual Basic Editor             •        Using variables, constants, and data types             •        Employing built-in functions             •        Creating procedures             •        Understanding object-and event-driven coding             •        Working with arrays             •        Understanding scope             •        Working with forms             •        Using selection controls             •        Creating reports             •        Exploring menus, navigation, and ribbons             •        Using object models             •        Working with data             •        Defining database schema             •        Using the Windows API             •        Working with XML files             •        Exploring Access SQL       On the Website   Download database files used in the book at www.quepublishing.com.       Category     Office Applications   Covers         Visual Basic for Applications     User Level    Intermediate - Advanced       Scott B. Diamond is a seasoned database designer and Microsoft Access 2007 MVP. During the last 20+ 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 a consultant, both in-house and freelance, and as a support professional at firms that are among the leaders in their industries. Scott spends some of his free time answering questions at the premier site for Access support: http:\/\/www.utteraccess.com.       Brent Spaulding started writing applications about 20 years ago and has utilized Microsoft Access since version 2.0. He looks forward to using Access well into the future. In July 2007, he received the Microsoft MVP award for Access, which recognizes his talent and contributions to the Access community.       Front cover bullets:   Edit and debug your code   Use looping and conditional statements   Understand the Access object- and event-driven architecture   Automate data entry   Learn how to use variables for dynamic automation   Create user-friendly applications for others   Create custom functions and objects   Customize the user interface   Manipulate data and objects with code","brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":49530785104145,"sku":"CIN0789737310G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49556746141969,"sku":"GOR005797026","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/0789737310.jpg?v=1751075998"}],"url":"https:\/\/www.worldofbooks.com\/collections\/author-books-by-scott-diamond.oembed","provider":"World of Books ","version":"1.0","type":"link"}