LifeInBook-Programming

Integrating Excel and Access
Posted: September 9th, 2009, 6:32am CEST by blackice

Tags:    [edit]



ISBN: 0596009739 Publisher: O'Reilly Media, Inc. Author: Michael Schmalz

Description:
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing "Integrating Excel and Access," the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to: Utilize the built in features of Access and Excel to access data Use VBA within Access or Excel to access data Build connection strings using ADO and DAO Automate Excel reports including formatting, functions, and page setup Write complex functions and queries with VBA Write simple and advanced queries with the Access GUI Produce pivot tables and charts with your data With "Integrating Excel and Access," you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.

Tags:    [edit]

ISBN: 0596005261 Publisher: O'Reilly Media, Inc. Author: Peter Drayton, Ben Albahari, Ted Neward

Description:
The heart of C# in a Nutshell is a succinct but detailed reference to the C# language and the .NET types most essential to C# programmers. Each chapter in the API reference begins with an overview of a .NET namespace and a diagram of its types, including a quick-reference entry for each type, with name, assembly, category, description, member availability, class hierarchy, and other relevant information, such as whether the type is part o the ECMA CLI specification. Newly updated for .NET Framework version 1.1, the second edition also adds a CD that allows you to integrate the book's API Quick Reference directly into the help files of Visual Studio .NET 2002 & 2003, giving you direct access to this valuable information via your computer.

Tags:    [edit]

ISBN: 0596514247 Publisher: O'Reilly Media, Inc. Author: Christian Wenz

Description:
Delivering rich, Web 2.0-style experiences has never been easier. This book gives you a complete hands-on introduction to Microsoft ASP.NET AJAX 1.0, the new framework that offers many of the same benefits for Ajax development that ASP.NET provides for server-side development. With Programming ASP.NET AJAX , you'll learn how to create professional, dynamic web pages with Ajax in no time. Loaded with code and examples that demonstrate key aspects of the framework, this book is ideal not only for ASP.NET developers who want to take their applications a step further with Ajax, but for any web developers interested in ASP.NET AJAX, no matter what technology they use currently. That includes JavaScript programmers who would like to avoid the headaches of writing cross-browser code.

Tags:    [edit]

ISBN: 047017661X Publisher: Wrox Author: Wei-Meng Lee

Description:
As an easy-to-use application that provides information at a glance, a gadget allows users to quickly and easily obtain weather information, RSS news feeds, and much more. In Windows Vista, there are two types of gadgetsSidebar and SideShow gadgets and Microsoft MVP author Wei-Meng Lee covers both. You begin by walking through the development of a simple gadget, and then each successive chapter breaks down the specific APIs that are relevant to enhancing a gadget so that you can clearly learn how a gadget is built.

Tags:    [edit]

ISBN: 0596004885 Publisher: O'Reilly Media, Inc. Author: Paul Lomax, Ron Petrusha

Description:
Lightweight yet powerful, VBScript from Microsoft® is used in four main areas: server-side web applications using Active Server Pages (ASP), client-side web scripts using Internet Explorer, code behind Outlook forms, and automating repetitive tasks using Windows Script Host (WSH). VBScript in a Nutshell , Second Edition delivers current and complete documentation for programmers and system administrators who want to develop effective scripts. Completely updated for VBScript 5.6, WSH 5.6 and ASP 3.0, VBScript In a Nutshell , Second Edition includes updated introductory chapters that will help you keep current with the significant changes since the first edition was published. New chapters introduce the Windows Script Component for creating binary COM components, and the Script Encoder. Regardless of your level of experience programming with VBScript, VBScript in a Nutshell , Second Edition is the book you'll want by your side--the most complete, up-to-date, and easy-to-use language reference available.

Tags:    [edit]

ISBN: 0596005903 Publisher: O'Reilly Media, Inc. Author: Jonathan Corbet, Alessandro Rubini, Greg Kroah-Hartman

Description:
Device drivers literally drive everything you're interested in--disks, monitors, keyboards, modems--everything outside the computer chip and memory. And writing device drivers is one of the few areas of programming for the Linux operating system that calls for unique, Linux-specific knowledge. For years now, programmers have relied on the classic "Linux Device Drivers" from O'Reilly to master this critical subject. Now in its third edition, this bestselling guide provides all the information you'll need to write drivers for a wide range of devices.