Increase your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible. Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL Demonstrates how to interact with other Office Applications from Excel, including Word, Access®, PowerPoint®, and Outlook® Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Unique book-and-DVD package for novice Visual Basic programmers Start from scratch, and even if you don?t know a thing about Visual Basic, you soon will with this thorough introduction to Visual Basic programming. Using easy-to-follow lessons and step-by-step instruction, this practical book teaches you concepts and hands-on techniques, then reinforces your learning with video screencasts and supplemental materials. Follow the exercises, then access the Try It section on the DVD, and watch as well-known VB authority and author Rod Stephens works through programming problems. Introduces Visual Basic programming to beginning programmers; no prior experience is necessary Covers Visual Basic programming concepts and techniques, as well as the Visual Studio development environment Provides a series of easy-to-follow lessons, supplemented by instructional video on DVD Offers expert instruction from well-known VB authority and author Rod Stephens, who also provides supplemental instruction on the DVD, where he works through a series of Try It problems and demonstrates effective solutions Stephens' Visual Basic Programming 24-Hour Trainer is an exceptional book-and-DVD package that will have you programming in Visual Basic in no time. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

This book-and-video package is the perfect introduction to Access 2010 Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples showing you exactly how each feature can be implemented in a real world Access database application. The accompanying DVD provides clear, easy-to-follow videos of the authors demonstrating each of the examples discussed in the book, as well as extra commentary, so that no reader is left behind! Provides examples of building Access database applications from scratch or from existing database templates. Discusses how to use Access 2010 and the major components it provides, such as the Navigation Pane, Ribbon, and the many database object designers. Teaches the basics of building and working with each of the major Access database object types: tables, queries, forms, reports, macros, and VBA code modules. Introduces exciting new Access 2010 features, such as the new macro designer, the new Ribbon designer, and even how to customize the Access Backstage. Teaches the basics of writing VBA code and provides specific examples about how and when to use it. Each lesson includes a step-by-step written example and DVD video showing exactly how to accomplish the tasks discussed in the lesson. Even if you have no experience with Access 2010, this guide will have you building robust Access applications with the best of them! If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Market_Desc: Novice programmers; no previous programming experience required. Special Features: · Rod Stephens is a well-known authority on Visual Basic programming--his Visual Basic Programmer's Reference has sold more than 30,000 copies in three editions.· Unique Book/Video Package: Each lesson in the print product is supplemented by an instructional video, included on the accompanying DVD.· Perfect for beginners: no previous programming experience is required.· The author will promote his book via his online VB community, VBHelper, which receives more than 7 million hits monthly. · The author will provide ancillary support materials for instructors, facilitating training/higher ed sales. About The Book: Start from scratch, and even if you don t know a thing about Visual Basic, you soon will with this thorough introduction to Visual Basic programming. Using easy-to-follow lessons and step-by-step instruction, this practical book teaches you concepts and hands-on techniques, then reinforces your learning with video screencasts and supplemental materials. Follow the exercises, then access the Try It section on the DVD, and watch as well-known VB authority and author Rod Stephens works through programming problems.

Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.

"Start from scratch, and even if you don't know a thing about Visual Basic, you soon will with this thorough introduction to Visual Basic programming ... Introduces Visual Basic programming to beginning programmers; no prior experience is necessary; covers Visual Basic programming concepts and techniques, as well as the Visual Studio development environment."--Resource description page.

Quickly learn to program in C# programming with this unique book and video package C# 24-Hour Trainer, 2nd Edition is your quick and easy guide to programming in C#, even if you have no programming experience at all. Updated to align with the latest C# standard, this book is your comprehensive beginner's guide, with each lesson supplemented by a video, for over ten hours of video training. Each chapter focuses on a specific concept or technique, with detailed, easy-to-follow explanation followed by a hands-on exercise. The goals of each exercise are outlined in advance to help you understand what you're working toward, and step-by-step instructions walk you through the operation from start to finish. Complex areas are clarified with specifically highlighted pointers that head off confusion, and additional exercises are provided so you can practice your new skills. Full instructor ancillaries are included to make this guide classroom ready, and the author's own website offers ongoing support. C# has become one of the most popular programming languages in the world, with millions of lines of code used in businesses and applications of all types and sizes. This book helps you dive right in so you can start programming right away. Start right in with the latest C# standard Learn at your own pace, with hands-on practice Clear up confusion and work around common obstacles Build your own Windows, .NET, and mobile applications C# has become a increasingly popular and in-demand programming skillsets. If you've decided to learn C#, this 24-Hour Trainer is your ultimate guide.