Microsoft Excel and Access Integration With Office 2007

Name: Microsoft Excel and Access Integration With Office 2007
Price: 3.53 USD
Availability: InStock
ISBN: 9780470104880

ISBN-10: 0470104880

ISBN-13: 9780470104880

Edition: 2007

Authors: Michael Alexander, Geoffrey Clark

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $3.53

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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.

Book details

List price: $39.99
Copyright year: 2007
Publisher: John Wiley & Sons, Incorporated
Publication date: 4/30/2007
Binding: Paperback
Pages: 388
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.232
Language: English

MICHAEL ALEXANDER is the pseudonym of a nurse who has previously worked in the UK and New Zealand.



Acknowledgements


Introduction



Getting Excel Data into Access



Analyzing Excel Data with Access Queries



Sprucing Up Excel Data with Access Reports



Using Pivot Tables and Pivot Charts in Access



Getting Access Data into Excel



Leveraging Macros in Excel and Access



VBA Fundamentals



Using VBA to Move Data Between Excel and Access



Exploring Excel and Access Automation



Integrating Excel and Access with XML



Integrating with Office Applications


Index