This set combines two proven programming products: "Microsoft Office 2000 Visual Basic for Applications Fundamentals" and "Mastering Microsoft Office 2000 Solution Development." The reader has two ways to learn: print or interactive CD-based. Users can deploy these products in tandem or individually to learn how to program in the most popular programming language in the world.

This Microsoft Mastering learning system provides practical, hands-on instruction for creating custom solutions with the integrated programming tools and services in Microsoft Office 2000, including the Visual Basic for Applications (VBA) development system. Students get the training they need -- how and when they need it -- through a combination of text-based and interactive lessons, narrated demonstrations, and hands-on labs. The instructional modules step learners through essential topics, such as using the Visual Basic Editor, forms and controls, object models for individual applications, shared object models, data access, and web components. Lab exercises reinforce the concepts presented in each learning unit and provide hands-on experience with development tasks. By the end of the course, students have developed a custom solution that integrates components of the Office 2000 suite.

The Professional's Guide to Developing Custom Solutions with Office 2000! Develop custom applications with Office 2000 Exploit the power of the VBA language Leverage the power of intranets and the Internet Create custom business solutions with Office 2000 and watch your productivity soar. Built right into the Microsoft Office applications on your desktop are more than 600 powerful software components and a full featured programming language, Visual Basic for Applications. You can use these tools to create custom applications to streamline your workflow and boost efficiency. The six main Office applications-Word, Excel, Access, PowerPoint, FrontPage, and Outlook--all work on the object model. With this step-by-step guide, you'll quickly master the paradigm and get down to building the exact software that suits your needs. Working hands-on from the very start, you'll be building real applications and mastering real skills, such as: Creating custom documents, charts, and reports Designing customized visual interfaces Controlling data access and managing security Creating and publishing Web content Automating e-mail tasks You will work easily within the familiar Office framework to develop sophisticated business solutions with these simple, widely available tools.

With detailed technical information delivered straight from the Microsoft Office 2000 documentation team, this practical and precise guide offers hands-on detail for everything from planning and developing Office 2000 solutions, working with data, designing multiuser solutions, and distribution.

The latest version of Microsoft's world-leading office suite is loaded with enhancements designed to improve your productivity at home and in the office. Written by two Office experts, Mastering Microsoft Office 2000 Professional Edition teaches you everything you need to know to get the most out of this powerful collection of programs. Inside, you'll find unparalleled coverage of Word, Excel, PowerPoint, Outlook, Access, and Publisher. Learn to use each product-begin with the basics if you're just getting started, or jump to new or advanced features if you're an experienced user. Either way, you'll quickly reap all the benefits offered by the new Office, including enhanced integration, more powerful macros, easier HTML conversion, and much more. Become a Master: Word 2000 Create, edit, format, and print impressive documents Simplify your work by using styles and templates Create dynamic Web pages in Word Excel 2000 Create worksheets that use functions and references Analyze data effectively Create complex charts, graphs, and Pivot Tables PowerPoint 2000 Create stunning presentations Prepare eye-catching handouts Broadcast presentations using NetShow Access 2000 Create effective databases Design forms Drill down into a table Outlook 2000 Schedule meetings easily Manage email efficiently Use Outlook with Exchange Server Publisher 2000 Create a publication -- for print or online Work with graphics and other objects Office-Wide Enhancements Work directly with online documents using Web Components Save documents directly to a Web server Use Install on Demand Collect and paste multiple items with the extended Clipboard Head off problems with Detect and Repair Personalize menus and toolbars Work in different languages using the Microsoft Language Path Make the most of integration with Visual Basic, Windows NT, and other BackOffice products Collect and paste multiple items Use macros and VBA

A case-based, problem solving approach to learning basic through intermediate VBA skills and how they can be used to write data for Office applications.