Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks — even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

In this book, you'll learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick and easy data entry. You'll even delve into the black art of Access programming, where you'll pick up valuable tricks and techniques that you can use to automate common tasks, even if you've never touched a line of code before.

Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

This book teaches you not only how the program works, it also shows you how to use Excel's tools to answer real-world questions like "How many workdays are there between today and my vacation?", "How much money do I need in the bank right now to retire a millionaire?", and "Statistically speaking, who's smarterDemocrats or Republicans?" Best of all, you'll steer clear of obscure options that aren't worth the trouble to learn, while homing in on the hidden gems that'll win you the undying adoration of your coworkers, your family, and your friendsor at least your accountant.

Word 2007: The Missing Manual, written specifically for this version of the software, explains basics like how to create documents, enter and edit text, format, print, and fax. You will will also learn how to create sophisticated page layouts, insert forms and tables, use graphics, and create book-length documents with outlines and Master Documents. Coverage also includes how to share documents with other people and programs, create web pages, automate documents with fields, and automate tasks with macros and the Visual Basic scripting language. This book shows you how to do it all.

Word. Micro$oft Word has been the world's most popular word processor for so long, it needs only one namelike Oprah or Madonna. Unlike certain celebrities, though, Word has undergone a makeover that goes well beyond cosmetic. Micro$oft has redesigned the way you interact with the program and has redefined the underlying document format (don't worry; your old Word documents will still work).

Activities in data warehousing and mining are constantly emerging. Data mining methods, algorithms, online analytical processes, data mart and practical issues consistently evolve, providing a challenge for professionals in the field. Research and Trends in Data Mining Technologies and Applications focuses on the integration between the fields of data warehousing and data mining, with emphasis on the applicability to real-world problems. This book provides an international perspective, highlighting solutions to some of researchers’ toughest challenges. Developments in the knowledge discovery process, data models, structures, and design serve as answers and solutions to these emerging challenges.

 Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.

Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

The  chapters  are  written  to  follow  one  another  logically  by  introducing topics in the earlier chapters and building on the technology. Thus, it is advised that you read the chapters in order. Even if you have worked with clustered  databases,  you  will  certainly  find  a  nugget  or  two  that  may  be new to you. For the experienced reader, the book also highlights wherever applicable the new features introduced in Oracle 10g.

PivotTables enable you to extract meaning from large amounts of data. This description is deceptively simple because in fact PivotTables are powerful and sophisticated tools that enable you to do things that would be impossible or difficult to do any other way.

A PivotTable enables you to take what seems to be an indecipherable mass of facts and extract any trends and patterns buried in the data. You can organize and summarize your data, perform comparisons, and extract meaningful information that can be invaluable to you and your organization.

These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.

Like all books in the Bible series, you can expect to find both hands-on tutorials and real-world practical applications, as well as reference and background information that provides a context for what you are learning. However, to cover every minute detail of every command of this very complex product would consume thousands of pages, so it is the second goal of this book to provide a concise yet comprehensive guide to SQL Server 2005 based on the information I have found most useful in my experience as a database developer, consultant, and instructor. By the time you have completed the SQL Server 2005 Bible, you will be well prepared to develop and manage your SQL Server 2005 database.

Whether you are a database developer or a database administrator, whether you are just starting out, have one year of experience or five, this book contains material that will be useful to you. This book is written so that you can learn from my experience and the experience of the co-authors. Each chapter begins with the assumption that you’ve never seen the topic before, and then progresses through the subject, presenting the information that makes a difference.

Written for experienced developers, this guide explains how to work with the .NET framework classes of controls and build custom controls for Windows forms and web form pages.

One of the reasons I wrote this book is to address the needs of .NET developers who require controls that don’t yet exist. Most businesses have specific needs that only a custom control can satisfy—from custom corporate e- mail plug-ins, to a custom control that manages user security in various applications, to a reusable intranet control that tracks customer calls and routes them to the appropriate location.

Another reason I wrote this book is that you might just have the next “big idea” for a commercial control that can be sold to developers around the globe but don’t know where to start. The booming market for controls shows there is always room for another tool that saves developers precious resources.

And finally, I wrote this book to satisfy the intellectual curiosity of advanced developers. If you’re like me, you thrive in finding and understanding the cornucopia of new classes and methodologies in .NET that can’t be found in other books. Understanding the .NET Framework classes for controls and designers not only makes you a more valued professional but also allows you to take an idea from one source and meld it with another in ways not done before—the so called ah-ha effect. If you fall into any or all of these three categories, this book is for you.

Replication is a way of copying and updating information in a database. This allows all users to see the same information and any changes made to it. Replication also duplicates the database across a number of computers so that, if one computer goes down, the information is not lost and can still be accessed. Pro SQL Server 2005 Replication, written by Sujoy Paul, a Microsoft Certified Professional for SQL Server, focuses on this most critical and complex of data management tasks.

This book is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2005. The book will also delve into advanced topics like replication of SQL Server with heterogeneous databases, replication of different database objects like stored procedures, backup and recovery of replicated databases, plus performance and tuning. This book is an ideal read whether youre a novice or advanced replication user.

This book shows you just how powerful, and yet easy to use, the new Web development environment from Microsoft really is. Visual Web Developer 2005 Express Edition, along with the relational database SQL Server 2005 Express Edition, allows you to build great Web sites using drag-and-drop techniques, wizards, and a huge range of developer-friendly tools and controls. The book demonstrates this by leading you through the creation of a fully featured and highly interactive e-commerce Web application, like those you are used to seeing on the Internet today.

This is not a reference book. You will not find listings of the objects, classes, properties, and methods of each feature in ASP.NET. Instead, this book is task-focused to provide you with the experience of working in Visual Web Developer, quickly getting to grips with the environment and ASP.NET, and learning how to achieve the kinds of requirements you will meet every day as you build your  applications. For example, after a brief section on installing Visual Web Developer and an introduction to the development environment, Chapter 1 gets you building pages that display and allow you to edit the data in a database.

As you progress through the book, you will learn about the following:
- Designing the structure of your Web site
- Implementing the database
- Displaying and editing data
- Building a shopping cart
- Publishing your finished site