| Excel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. In this book, you'll discover how Access benefits from Excel's flexible presentation layer and versatile analysis capabilities, while Access's relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you'll find that your team's productivity is the real winner.
- Move data easily between Excel and Access
-
Store Excel data in a structured relational database
-
Create Excel PivotTables with Access data
-
Report Access data using Excel's presentation layer
-
Use VBA, ADO, and SQL to move data from one application to the other
-
Save time and increase productivity by automating redundant processes with VBA
-
Simplify integration tasks using XML
-
Integrate Excel data into other Office applications
Companion Web site
Find all the examples from the book in the database located at www.wiley.com/go/exceland accessintegration.
About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD). He has more than thirteen years of experience as a consultant and developer of office solutions for various companies, and is the author of several books. Geoffrey Clark as fourteen years of real-world experience building and implementing custom solutions for clients worldwide. Currently, he develops office applications to enable enterprise-wide metrics and change initiatives. |
|
|
 Maya 6 Revealed (Naked)Maya is a program, created by Alias, used to model, animate, and render 3D scenes. 3D
scenes created with Maya have appeared in movies, television, advertisements, games,
product visualizations, and on the Web. With Maya, you can create and animate
your own 3D scenes and render them as still images or as animation sequences.... | | .NET Patterns: Architecture, Design, and ProcessUntil now, we have been inundated with a melee of material in the areas of software architecture, design, and "professional" principles. The need for design material seems to be always at its peak when either a new language or technology appears in the market. When Java first entered the market, you could hear the... | | Special Edition Using Microsoft Office Project 2003This book provides readers with everything they need to make the most of Project 2003. Project 2003 helps users manage projects indepently or as part of a large organization. Business professionals can gain access into their portfolio of projects, and collaborate on the documents, issues and risks associated with those... |
|
