This book is a fairly comprehensive resource on writing VBA code to exchange data among the main Office applications (Access, Word, Excel, and Outlook), using Access as the central application for storing data, and using the other applications for producing attractively formatted documents of various types.

By the time you have completed the Access 2007 VBA Bible, you will be well-prepared to write VBA Automation code that uses your Access data to produce Word letters, mailing labels and other documents (without the overhead of mail merge), to create Excel worksheets and PivotCharts, and to create Outlook appointments, mail messages, contacts, and journal items, with or without attachments. Additionally, you will be able to synchronize contact data (both ways) between Access and Outlook.

 This book was written to assist you in preparing for and passing the Analyzing and Defining Microsoft .NET Solution Architecture exam (Exam 70-300). The text and exercises were created to help familiarize you with the topics you will be tested on during the actual exam.

While this book is designed to be a focused exam preparation tool, in it you will also find discussion of the theory and methodologies behind working with the .NET Framework. The hands-on exercises were designed to give you additional experience with the .NET Framework while reinforcing your understanding of the concepts.

Based on 300,000+ hours of IT training experience, this Study Guide provides 100% coverage of all objectives for exam 70-310. Coverage includes the .NET Framework, Visual Studio .NET, creating physical designs, developing solution concepts, and more.

Popular among both novice and experienced AutoCAD users, this comprehensive book begins with an overview of the basics of AutoCAD, such as creating drawings, using commands, and specifying coordinates. Coverage becomes more in-depth as each chapter builds off the previous one, with discussions of 2D and 3D drawing techniques, using layers, creating dimensions, 3D coordinates, and rendering. You ll learn to customize commands and toolbars; program AutoCAD using AutoLISP and VBA; and review AutoCAD LT. A "Quick Start" will have beginners creating a CAD drawing on their first day. The accompanying CD-ROM provides before-and-after real-world drawings, bonus appendices, freeware and shareware programs, the book in searchable PDF format, and a 30-day trial version of AutoCAD software.

This book covers every significant AutoCAD and AutoCAD LT feature. If you’re a beginning user, you’ll find everything you need to start out; if you’re already using AutoCAD or AutoCAD LT regularly, the book covers advanced material as well. Although you can use this book as a tutorial if you’re just starting out or learning a new set of features, it also provides a solid reference base to come back to again and again. The short tutorials on almost every topic will quickly have you drawing professionally. The CD-ROM is chock-full of drawings, a trial version of AutoCAD 2007, and add-in programs (which are mostly for AutoCAD only). This book should be all that you need to make full use of either program.

My goal in writing this book is to share with you some of what I know about Excel, and in the process, make you more efficient on the job. The book contains everything that you need to know to learn the basics of Excel and then move on to more advanced topics at your own pace. You’ll find many useful examples and lots of tips and tricks that I’ve accumulated over the years.

In this book, I’ve tried to maintain a good balance between the basics that every Excel user needs to know and the more complex topics that will appeal to power users. I’ve used Excel for nearly 20 years, and I realize that almost everyone still has something to learn (including myself). My goal is to make that learning an enjoyable process.

This book was written for Excel 2007 for Windows. No exceptions. If you’re using an older version of Excel, I suggest that you put down this book immediately and find a book that’s appropriate for your version of Excel. The changes in Excel 2007 are so extensive that you’ll probably be hopelessly confused if you use an earlier version.

This book can teach you how to debug more effectively. It is a complete and pragmatic overview of debugging, written by a talented researcher who has developed many clever ways to isolate bugs. It explains best practices for finding and fixing errors in programs, ranging from systematically tracking error reports, reproducing failures, observing symptoms, isolating the cause, and correcting defects. Along with basic techniques and commonly used tools, the book also explores the author’s innovative techniques for isolating minimal input to reproduce an error and for tracking cause and effect through a program.

Studying this book will make you a better programmer. You will be able to find and fix errors in your code (and your colleague’s code) faster and more effectively, a valuable skill that will enable you to finish projects earlier and produce programs with fewer defects. Also, if you read between the lines you will learn how to write code that is more easily tested and debugged, which further increases your ability to find and correct defects. And thinking hard about what can go wrong with your program can help you avoid mistakes in the first place, so you have less to debug.