找回密码
 注册
搜索
热搜: java php web
查看: 741|回复: 4

Microsoft Excel and Access Integration: With Microsoft Office 2007

[复制链接]
发表于 2009-12-17 18:06:01 | 显示全部楼层 |阅读模式


作者: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 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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?注册

×
发表于 2010-1-7 18:04:16 | 显示全部楼层
等了好久的好书了!
回复

使用道具 举报

发表于 2010-6-4 01:02:26 | 显示全部楼层
楼主加油!!!!!11
回复

使用道具 举报

发表于 2010-6-5 19:35:09 | 显示全部楼层
very nice book...have been looking forward a long time
回复

使用道具 举报

发表于 2010-9-15 05:32:05 | 显示全部楼层
还在为找实力团队与不乱平台发愁吗?全市场最高的赔率1900!比一般平台高
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archiver|手机版|小黑屋|软晨网(RuanChen.com)

GMT+8, 2024-11-22 18:28

Powered by Discuz! X3.5

Copyright © 2001-2023 Tencent Cloud.

快速回复 返回顶部 返回列表