Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
39 used & new from £5.40

Have one to sell? Sell yours here
 
   
Tell a Friend
Integrating Excel and Access
 
 
Integrating Excel and Access (Paperback)
by Michael Schmalz (Author)
No customer reviews yet. Be the first.
RRP: £28.50
Price: £18.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £9.51 (33%)
Availability: In stock. Dispatched from and sold by Amazon.co.uk.

Want guaranteed delivery by 1pm Friday, July 25? Choose Express delivery at checkout. See Details

39 used & new available from £5.40

Perfect Partner

Buy this book with Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA by Stephen Bullen today!

Integrating Excel and Access Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
Buy Together Today: £40.58

Customers Who Bought This Item Also Bought

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA by Stephen Bullen

4.9 out of 5 stars (16)  £21.59
Excel ADVANCED: Report Development

Excel ADVANCED: Report Development by Timothy Zapawa

£16.24
Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access by Michael Alexander

3.0 out of 5 stars (2)  £18.19
Access Hacks: Tips & Tools for Wrangling Your Data: Tips and Tools for Wrangling Your Data (Hacks)

Access Hacks: Tips & Tools for Wrangling Your Data: Tips and Tools for Wrangling Your Data (Hacks) by Ken Bluttman

£12.25
Excel Hacks: 100 Industrial Strength Tips and Tools (Hacks)

Excel Hacks: 100 Industrial Strength Tips and Tools (Hacks) by Raina Hawley

5.0 out of 5 stars (1) 
Explore similar items : Books (50)

Product details

Customers Viewing This Page May Be Interested in These Sponsored Links (What is this?)
B2B Integration Solutions
www.sterlingcommerce.com    World Leaders In B2B Integration Solutions - Sterling Commerce 
Integrate without coding
www.crossflo.com    Proven, open and repeatable technology for database integration 
Typing Services Glasgow
www.caledoniansuite.co.uk    Copy and audio typing, spreadsheets database, mailshots and binding 

Product Description
Book Description
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.
Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.
But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:

* Utilize the built in features of Access and Excel to access data

* Use VBA within Access or Excel to access data

* Build connection strings using ADO and DAO

* Automate Excel reports including formatting, functions, and page setup

* Write complex functions and queries with VBA

* Write simple and advanced queries with the Access GUI

* Produce pivot tables and charts with your data
With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.

Synopsis
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now. Introducing "Integrating Excel and Access", the unique reference, shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications.

In no time, you'll discover how to: utilize the built in features of Access and Excel to access data; use VBA within Access or Excel to access data; build connection strings using ADO and DAO; automate Excel reports including formatting, functions, and page setup; write complex functions and queries with VBA; write simple and advanced queries with the Access GUI; and produce pivot tables and charts with your data With "Integrating Excel and Access", you can crunch and visualize data like never before. It's the ideal guide for anyone, who uses Microsoft Office to handle data.

See all Product Description


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tag this product

 ( What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
Search Products Tagged with
 

Customers Who Viewed This Item Also Viewed

Microsoft Excel and Access Integration: With Microsoft Office 2007

Microsoft Excel and Access Integration: With Microsoft Office 2007 by Michael Alexander

£17.99
Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access by Michael Alexander