Dotnetcat » .NET Books » Office books

Microsoft Office Communications Server (OCS) 2007 is Microsoft's latest version of Live Communications Server 2005. The product provides management for all synchronous communications that takes place in real time. This includes instant messaging (IM), Voice over IP (VoIP), and audio conferencing and videoconferencing. It will work with your company's existing telecommunications systems without major hardware upgrades. This means your business can deploy advanced VoIP and conferencing without tearing out its preexisting legacy telephone network.
How to Cheat at Administering Microsoft Office Communicator 2007 provides the busy system administrator with any easy-to-access reference that provides step-by-step instructions on how to install, configure, manage and troubleshoot Communicator across the network. It is the perfect tool for those who simply need to complete a task without reading through lots of theory and principles.
. Get Inside Microsoft Office Communications Server 2007
Learn what's new in OCS 2007, compare the previous editions, understand OCS 2007 server roles, plan an OCS 2007 installation.
. Install the First OCS 2007 Front-End Server
Address the prerequisites, prepare active directory, install and configure OCS 2007 Enterprise Edition, and verify the installation summary.
. Configure the Edge Server
Install the Edge Server, work with certificates, deal with security issues, and test the Edge Server.
. Configure the Mediation Server
Install the Configuration Server, configure dialing rules, configure users for voice functionality, and test voice functionality.
. Configure Archiving
Address compliance requirements, understand archiving topology, and install the Archiving Server.
. Configure Conference Servers
Understand on-premises conferencing, use on-premises conferencing, understand Microsoft RoundTable, and install conferencing.
. Integrate OCS with PBX and IP-PBX Systems
Use a gateway, configure Cisco CallManager as a Gateway, and understand CSTA/SIP gateways.
. Integrate OCS with Exchange 2007 Unified Messaging
Master Exchange 2007 Unified Messaging and architecture, Configure Exchange 2007 UM, and Combine OCS with Exchange 2007 UM.
. Upgrade to Office Communications Server 2007
Plan your migration from LCS 2005 to OCS 2007, upgrade perimeter servers, upgrade director servers, upgrade front-end servers, perform user migration, and remove LCS 2005 from the network environment.

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.

The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).

This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.

With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

Get the fast facts that make learning Office XP plain and simple!Here’s WHAT you’ll learn: Find the simplest ways to get stuff done in Microsoft® Office Create professional-quality documents and publications * Manage your e-mail, address book, and calendar Build spreadsheets and databases that do the math! Produce and deliver great presentations Build a Web site—for you, your company, your teamHere’s HOW you’ll learn it: NUMBERED STEPS show exactly what to do Color SCREEN SHOTS keep you on track Handy TIPS teach easy techniques and shortcuts* Quick TRY THIS! exercises put your learning to work * CAUTION notes help keep you out of trouble

At the heart of Apple's hugely popular iLife software suite-iMovie, iPhoto, iDVD, GarageBand, and iTunes-is QuickTime, the powerful media engine that drives elegant applications for managing movies, images, and audio files. The enduring success of QuickTime is in no small part attributable to its component architecture. This key feature has allowed it to embrace emerging digital media technologies and standards one by one as they have appeared over the 12 or so years since its launch. None of the competing technologies even comes close, let alone on both Mac OS X and Windows.
QuickTime for .NET and COM Developers is the first guide to QuickTime for developers using popular RAD tools such a Visual Basic .NET, C#, and Visual Basic 6. A general introduction to QuickTime is followed by a detailed explanation of the QuickTime architecture from a.NET and COM perspective, liberally accompanied by code snippets. A number of implementation examples illustrate key QuickTime features, ranging from a simple movie player to a sophisticated interactive application. Also covered is QuickTime scripting in both QuickTime Player (using Windows Scripting) and in Microsoft Office applications (using VBA). Brief guides to developing with QuickTime in Delphi and ATL/WTL are also included.
Part of the official Quicktime Developer Series, publishing the finest books on QuickTime in cooperation with Apple.
* The first book on QuickTime for .NET and COM application and scripting developers
* Written by one of the architects of Apple's QuickTime ActiveX/COM control
* Offers numerous sample applications and code examples

Microsoft SharePoint: Building Office 2007 Solutions in VB 2005 is the third edition of Scot Hillier's market-leading SharePoint book. The new version includes extensive updates from the previous editions, with a complete focus on SharePoint 2007 and its integration with the 2007 Microsoft Office System. This edition also features new approaches for using SharePoint to improve business efficiency, plus new workflow solutions for SharePoint and BizTalk, as well as a brand new chapter on building a SharePoint solution from start to finish.

With this book, you'll gain intermediate-level guidance to design and deploy business solutions based on Microsoft SharePoint 2007 technologies. And Hillier carefully defines the business cases and scenarios for these new technologies. He reviews the installation, configuration, and administration of business solutions based on Microsoft SharePoint technologies, and provides programming instruction, guidance, and examples for custom web parts and solutions.

• Offering authoritative, field-proven advice from a Microsoft insider, this book teaches the underlying commonalities that developers can use regardless of their language choice or development tools
• Extensive use of examples and working code provides developers with practical and authoritative coverage of the CLR (common language runtime) and APIs, the building blocks that make it possible to write in any choice of language
• Primary topics discussed include generics, MSIL (Microsoft Intermediate Language)-based framework libraries, advanced framework libraries, distributed development foundations, and more
• Version 2.0 is the version that provides the foundation for Visual Studio 2005

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003¿s new XML export/import features.

The book¿s organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

An authoritative introduction to implementing DotNetNuke Web sites, by experienced DotNetNuke implementers and trainers

An impressive author team shows you how to easily build Web sites with a variety of content features - no programming experience required.

If your goal is to build the site without worrying about the programming behind it, DotNetNuke 5 User's Guide gives you exactly what you need. After developing a groundwork in the DotNetNuke framework and DotNetNuke as a content management system, it provides installation and administration information. Then it takes you step by step through a variety of use cases, implementation strategies, and configuration decisions for various sites.

• Introduces the benefits of content management systems, open source, how DotNetNuke functions as a content management system, and DotNetNuke modules, pages, and skins
• Explains the installation process, options for installing DotNetNuke, and requirements, as well as administration functionality and content management fundamentals for DNN sites
• Examines different use cases, implementation strategies, and configuration decisions
• Shows how to develop and implement a personal Web site, a team or club community, a small business site, and an enterprise solution
• Looks at various advanced topics relevant to all use cases, ranging from advanced installation options to detailed administrative features
• Includes a foreword by Shaun Walker, creator of DotNetNuke and Wrox DotnetNuke series editor

DotNetNuke 5 User's Guide provides the tools you need to put this valuable technology to work.

VSTO is the only way to properly unlock the potential of Microsoft Office 2007 in the enterprise. Written specifically for professional Microsoft Office developers, Pro Office 2007 Development with VSTO covers the full range of what’s possible with the toolset, taking the reader to expert status by the end of the text. Readers become fully grounded in the language, in the key features VSTO offers, and are introduced to practices that will help ensure their success as professionals.

A step-by-step guide for brand-new Office developers who want to explore programming with VSTO. This book contains complete step-by-step instructions and simple explanations about VSTO programming of entire Office applications. It covers the concepts of VSTO, VSTO architecture, its features, and versions using practical examples, to help beginners and intermediate developers develop real-world Office applications. Separate chapters cover programming InfoPath, Word, Excel, Outlook, and PowerPoint. This book is aimed at .NET developers, familiar with C#, who want to get to grips with programming Office 2007. The book will also be useful for those of you who already have experience with VBA and programming Office, but are ready to take the next step into the more powerful world of Office programming with VSTO.