This book goes beyond just the technical explanation of Project and really focuses on how to apply methodology, best practices and tool knowledge as a project manager or anyone wanting to create a schedule.

This book on generic SQL can be used by new users to learn the foundations of SQL or act as a reference for more experienced users. This new edition brings the content up-to-date with the latest versions of the major proprietary database systems, including Access, Oracle and MySQL.

VSTO for Mere MortalsTM is for VBA developers who are interested in migrating their skills to the next generation of Office development. Readers will benefit from a straightforward, practical introduction to writing managed code applications for Word 2003, Excel 2003, and Outlook 2003. Readers will also learn how to create add-ins for the most popular applications for Office 2003 and the 2007 Microsoft Office system using VSTO 2005 SE. The expert authors provide a wealth of code samples that show off popular features of VSTO, such as smart tags and the actions pane. Sample code also shows you how to customize the new UI features of the 2007 Microsoft Office system, including the ribbon, custom task pane, and Outlook forms region. VBA developers will walk away with A greater understanding of managed code and the Visual Studio integrated development environment (IDE) Multiple demonstrations on how to create document-level customizations for Word 2003 and Excel 2003, using view controls, data binding, and the actions pane A comprehensive overview of add-in development for Outlook 2003 Useful information on securing and deploying solutions created with VSTO and VSTO 2005 SE A thorough explanation on how to migrate VBA solutions to Visual Basic 2005 and VSTO Numerous details on customizing the ribbon, custom task pane, and Outlook form regions by developing VSTO 2005 SE add-ins for the 2007 Microsoft Office system

The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think “outside the box.” In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. Coverage includes: Getting started: understanding what relational databases are, and ensuring that your database structures are sound SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE Summarizing and grouping data with GROUP BY and HAVING clauses Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data Software-Independent Approach! If you work with database software such as Access, MS SQL Server, Oracle, DB2, MySQL, Ingres, or any other SQL-based program, this book could save you hours of time and aggravation—before you write a single query!

Explore the features, the installation, and the configuration of these seven new servers and gain a conceptual understanding of how your users will be working with them. Forms Server 2007 Groove Server 2007 Communications Server 2007 PerformancePoint Server 2007 Project Portfolio Server 2007 Project Server 2007 SharePoint® Server 2007 for Search Along with the release of Windows Vista and the revamped suite of Office 2007 products, Microsoft has released a line-up of new servers. Exchange Server 2007 and SharePoint® Server 2007 are two of the major players, but there are also seven additional Office 2007 Servers of which you may not be aware that can add productivity to your environment in a variety of ways. Each of the seven servers is unique and requires distinct assessment to determine if your company can benefit from any given server. This book provides you with the knowledge you need to determine the use of each server, the prerequisites and procedures of server installation, the post-installation configuration options so you can set it and forget it, and finally, a look at the client-side applications that interact with the new servers. Detailed information on how to… Install each of the seven Office 2007 Servers, including both standalone and server farm installation. Handle post-installation configuration options for each of the seven Office 2007 Servers. Create InfoPath forms to post to your InfoPath Forms Server. Work with the Groove client once your Groove Servers are in place. Communicate more efficiently within your company using a Communications Server and the new Communicator 2007 client. Handle larger projects through Project Professional 2007 with your new Project Server and Project Portfolio Server. Understand Business Intelligence (BI) in order to manage your company’s future through PerformancePoint Server. Improve your ability to search for content through your SharePoint Server for Search. J. Peter Bruzzese is an independent consultant and trainer for a variety of clients including CBT Nuggets, New Horizons, and ONLC.com. Over the past ten years Peter has worked for/with Goldman Sachs, CommVault Systems, and Microsoft, to name a few. He focuses on corporate training and has had the privilege of working with some of the best trainers in the business of computer education. In the past he specialized in Active Directory and Exchange instruction, as well as certification training. Peter is a contributor to Redmond Magazine, WindowsITPro magazine, and several tech sites, and a speaker for the MCP TechMentor Conferences. Ronald Barrett is the director of information technology for an accounting and financial services firm, while also serving as chairman for the Technology Executive Committee for CPAmerica, a national CPA network, consisting of 15,000+ professionals.

The best of the best from our Excel, Word, Access, and PowerPoint Bibles! Learn the sought-after features of the core applications from the Office 2013 suite. This Office 2013 Bible features the best-of-the-best content from the Excel 2013 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2013 Bible, by Office expert Lisa A. Bucki; the PowerPoint 2013 Bible, by MOS Master Instructor and PowerPoint expert Faithe Wempen; and the Access 2013 Bible from Microsoft Certified Application Developer Michael Alexander and Office and Access expert Dick Kusleika. This major resource also covers Outlook, Publisher, OneNote, SkyDrive, and other important features in the Office 2013 suite. If you want to quickly and effectively use Office 2013, start in the experts' corner with this must-have book. Gives you the best-of-the-best content on Office 2013 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access Bibles Includes content from John Walkenbach, aka "Mr. Spreadsheet"; Word and Office expert Lisa A. Bucki; MOS Master Instructor and PowerPoint expert Faithe Wempen; Microsoft Certified Application Developer Michael Alexander; and Office and Access expert Dick Kusleika Takes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to accomplish critical business tasks Also covers Publisher, OneNote, SkyDrive, the Cloud, and other key features and topics for Office 2013 Get the best of four Office 2013 books in one with this power-packed reference!