Presenting innovative Microsoft Excel techniques for top management professionals, this reference for company leaders who do not have the time to attend courses or read bulky books on the program provides basics, special shortcuts, and tips that cover the special features of Excel. Useful facts, trivia, and insider secrets about Excel are interspersed throughout the text, and readers have the choice of jumping directly to the section of real-life case studies to learn by the innovative Do & Learn (D&L) approach. This reference is fully updated to reflect Excel 12.

Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases–even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications.

Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the book's sample databases on the CD-ROM.

• Customize the user interface to suit your preferences
• Use the built-in database templates or design your own
• Create, modify, and relate tables
• Enter and edit data
• Write advanced queries to extract and manipulate information
• Create customized forms and reports
• Improve performance and back up your database
• Develop macros to carry out automated responses to user actions
• Import, link, and export data
• Enable a multiple-user environment
• Secure your database

Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a void in the market for a professional-level Outlook programming book.
Explains how to use the many new features of Outlook 2007's object model and offers honest advice from the author on how to deal with common shortcomings and pitfalls of Outlook.
Addresses common workarounds for Outlook programming bugs and how to interface with Word, Excel, SharePoint, and Access.
Discusses the new Object Model, Outlook forms, COM add-ins, security, and more

We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need.

If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material.

This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version.

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me.

Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization.

The landscape of doing SharePoint development has changed considerably in the last year, with the release of SharePoint Server 2007 and its related technologies. You need a contemporary reference to stay on top of the latest ways to combine .NET development techniques with your SharePoint development techniques, and SharePoint 2007 Development Techniques is your guide.

What makes this book unique are the topics that have never before been discussed in a SharePoint 2007 context. Learn how to incorporate the latest trends, capabilities, and enhancements in your daily SharePoint development activities.

What you’ll learn

• Using Windows Workflow Foundation to create workflows in SharePoint Designer
• Integrating business messaging with BizTalk Server 2006 into your SharePoint sites
• Developing list item relationships via a feature
• Creating and sharing database data by combining SharePoint with SQL Server 2005 Reporting Services
• Constructing queries using SQL full-text extensions

Essential Skills for Database Users and Professionals
* Create shapes and link them to data
* Summarize and analyze information using PivotDiagrams
* Use Data Graphics, Smart Tags, and SmartShapes to reinforce information
* Generate robust Excel, HTML, and XML reports
* Create custom, reusable templates, stencils, and masters
* Update and enhance diagrams with Reviewer's comments and markups
* Integrate Visio diagrams with other Windows applications
* Publish and securely distribute Visio documents and summaries
* Extend functionality using VBA macros, add-ins, and wrapper application

Microsoft Office Project Server 2007 Unleashed provides a comprehensive and in-depth overview of Microsoft Office Project Server 2007 and Enterprise Project Management (EPM). This book should be used as a reference to guide you through system capabilities and the use of more advanced product features in the context of your business processes. In this book you will find cutting-edge information, including the necessary framework and approach to implement a complex project management software product. Find practical, real-world guidance on how to plan, install, configure, deploy, use, manage, and customize your EPM Implementation. This book is your only in-depth source for Microsoft Office Project Server 2007!

Access Data Analysis Cookbook is about solutions to real-world problems. This is not a book about designing forms, learning about primary keys, or discussing the use of built-in wizards to make easy queries or reports. This book is about applying Access to the business grindstone.

Within the dozens of recipes contained in this book, you will learn new ways to query data, how to move data in and out of Access in several different ways, how to calculate answers to financial and investment questions, and much, much more.

I would not suggest this book for brand-new Access users, but anyone with some Access experience should do well with it. As long as you understand how to get around the Access user interface, basic table structures and relations among them, and  how  to  construct  simple  queries,  you  should  be  able  to  follow  along. Even seasoned developers will pick up new tips and techniques. Considering that many recipes center around business issues rather than technical issues, everyone should be  able  to  gain  some  smarts  about  analysis  and  reporting—the  world  that  users inhabit.

Access Data Analysis Cookbook focuses on data. The recipes provide example queries, programming tips, and a smattering of math, all with a view to getting answers from your data.

See How To

• Create databases more efficiently using a new results-oriented interface
• Use tools for building a database that makes information easier to find and use
• Import data from other programs, HTML, XML files, and other databases
• Use forms, filters, queries, and reports to capture and analyze data
• Discover ways to prevent data corruption and unauthorized access
• Share your data with others through interactive web pages
• Put your newly acquired skills to work using the online workshops
• Organize information and add impact with clip art, SmartArt diagrams, tables, and charts
• Use Groove and SharePoint Team Services to collaborate and share documents and information
• Prepare for the Microsoft Certified Application Specialist (MCAS) exam

On the Web

This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com