|
 |
|
 |
 |
Microsoft Excel and Access Integration: With Microsoft Office 2007
|
by Michael Alexander and Geoffrey Clark
Sales Rank: 50612
|
Discount: 40 %
List Price: $39.99
$26.39
At Amazon
|
|
Paperback: 408 pages
Publisher: Wiley April 30, 2007
Language: English
ISBN-10: 0470104880
ISBN-13: 978-0470104880
Product Dimensions:
9.1 x 7.3 x 1.1 inches
Shipping Weight: 1.2 pounds
Book Description
Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually 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 two work together, you’ll find that your team’s productivity is the real winner.
Back Cover Copy
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.
Customer Reviews & Comments
I'm an intermediate user with some experience using both Excel and Access. I've always hacked my way into integration, and have always had the sense that there are better ways to make Excel and Access work together. It turns out I was right. Within 30 minutes of receiving this book, I've found three techniques that have exponentially improved my processes. I particularly appreciate the fact that the authors start simple and build gradually to more complicated techniques. Five stars for this extremely valuable addition to my library!
Comment | Permalink |
(Report this)
|
Microsoft Excel and Access Integration: With Microsoft Office 2007
List Price: $39.99
Discount: 40 %
Available from Amazon
Price: $26.39
| |
|
|
|
|
