Book123

    Free register and download UseNet downloader, then you can FREE Download from UseNet.

    Download without Limit " Technical Microsoft Excel and Access Integration: With Microsoft Office 2007 " from UseNet for FREE!

Microsoft Excel and Access Integration: With Microsoft Office 2007 By Michael Alexander, Geoffrey Clark, Publisher: Wiley

Number Of Pages: 408

Publication Date: 2007-04-30

Sales Rank: 97373

ISBN / ASIN: 0470104880

EAN: 9780470104880

Binding: Paperback

Manufacturer: Wiley

Studio: Wiley

Average Rating: 5

Offering step-by-step instruction, this invaluable book shows readers how to save time and enhance data analysis and reporting capabilities by combining the abilities of Excel and Access

While both Excel and Access are powerful tools on their own, combining the functionality of these two applications opens up a whole new world of possibilities

In addition to demonstrating a wide range of integration techniques, the book also provides practical, real-world scenarios that illustrate ways to avoid common pitfalls when moving and analyzing data across applications

Shows readers how integration allows Access to get the benefit of Excel's flexible presentation layer and versatile analysis capabilities, while Excel gets the benefit of Access's relational database structure and robust querying tools

Review: Good introduction to using the two packages together. The back cover of this book starts out saying: 'Excel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two.' That's a pretty good description of me. I have used Access for many years. I speak Access SQL, I know about Access input forms and output reports. I have seen Excel users who do much better looking presentations, have powerful tools to summarize and analyze data (such as charts), but I had no idea how to take information from an Access table and feed it into Excel. I started in this book with Chapter 5 - Getting Access Data into Excel. There are several different ways to get the data from simple drag and drop to using SQL for more powerful approaches. The examples use the new 'Ribbon' from Excel 2007, but many of the same features were in previous versions. The short section on SQL is elementary, if you really want to use SQL, you'll want a specialized book on Access SQL (note Access SQL - it's different than other SQLs). If you want to go the other direction, Chapter 1 is 'Getting Excel Data into Access.' The first half of the book is on using Excel and Access in their traditional ways, the second half gets more advanced with chapters on VBA, Automation, XML and with integrating Excel with other Office applications including Word, PowerPoint and Outlook. I'd rate this an intermediate level book. It's really intended for the Excel or Access user to teach them about the other package. Buy Book at Lowest Price on Amazon

Rating:
2.5 out of 5 by Book123