作者：Michael Alexander, Geoffrey Clark
出版日期：April 30, 2007
出版社：Wiley Publishing
页数：408
ISBN：ISBN-10: 0470104880 ISBN-13: 978-0470104880
文件格式：PDF

Product Description
Although many people rarely go from Excel into Access or vice versa,you should know that Microsoft actually designed these applications towork together. In this book, you’ll discover how Access benefits fromExcel’s flexible presentation layer and versatile analysiscapabilities, while Access’s relational database structure and robustquerying tools enhance Excel. Once you learn to make the two worktogether, you’ll find that your team’s productivity is the real winner.
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 thisbook, you’ll discover how Access benefits from Excel’s flexiblepresentation layer and versatile analysis capabilities, while Access’srelational database structure and robust querying tools enhance Excel.Once you learn to make the team work, you’ll find that your team’sproductivity is the real winner.
Move data easily between Excel and AccessStore Excel data in a structured relational databaseCreate Excel PivotTables with Access dataReport Access data using Excel’s presentation layerUse VBA, ADO, and SQL to move data from one application to the otherSave time and increase productivity by automating redundant processes with VBASimplify integration tasks using XMLIntegrate Excel data into other Office applications