Microsoft Excel and Access Integration: With Microsoft Office 2007

4.11 avg rating
( 9 ratings by Goodreads )
 
9780470104880: Microsoft Excel and Access Integration: With Microsoft Office 2007
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Alexander, Michael, Clark, Geoffrey
Published by Wiley (2007)
ISBN 10: 0470104880 ISBN 13: 9780470104880
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Wiley, 2007. Paperback. Condition: New. Never used!. Seller Inventory # P110470104880

More Information About This Seller | Contact this Seller

Buy New
US$ 41.66
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

2.

Alexander, Michael, Clark, Geoffrey
Published by Wiley (2007)
ISBN 10: 0470104880 ISBN 13: 9780470104880
New Paperback Quantity Available: 2
Seller:
Save With Sam
(North Miami, FL, U.S.A.)
Rating
[?]

Book Description Wiley, 2007. Paperback. Condition: New. Brand New!. Seller Inventory # VIB0470104880

More Information About This Seller | Contact this Seller

Buy New
US$ 41.66
Convert Currency

Add to Basket

Shipping: US$ 3.00
Within U.S.A.
Destination, Rates & Speeds