Microsoft Excel and Access Integration: With Microsoft Office 2007 Paperback – 4 May 2007
Customers who bought this item also bought
What other items do customers buy after viewing this item?
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
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.
Most helpful customer reviews on Amazon.com
For instance, he says, create a query as shown in Figure XXX. But the problem is, the screen shot is very small, and hard if not impossible to decipher, even with a magnifier, especially on Kindle version. Often have to guess at what he means.
Such is a lazy writer, he saves work on his part, and makes the readers work so much harder to compensate; this is not a good approach because the screen shots are not that readable. If the screen shots were readable, it would be more acceptable. The labels of the diagrams are much wider than the actual diagrams--why not make the disgrams just was wide, and thus bigger?
In addition, the placement of the figures/screen shots do not immediately follow (or precede) the text, so have to flip back and forth.
It is unfortunate, otherwise a good book. As mentioned, the content is good.
Also contains some errors.
There are many good computer instruction book writers, he is not one of them--he is lazy and inconsiderate of the reader. Look for same subject from another author.
I am so annoyed everytime I use the book I need to re-emphasize.
The screen shots are so small and difficult to view, and unreadable even with a magnifier, and the author just lets the screen shots present the steps and selections necessary to work the examples, rather than specify the details in the accompanying text.
This is why I say he is a very lazy author. Extremely frustrating, especially when the page occupied by the screen shot could accommodate a larger graphic to be more readable. No consideration for the reader, only author's own convenience. If all his books are like this, stay away!
I was disappointed, this book presented me with nothing new and I quickly discovered some of the stuff that I was already doing was more advanced than this book covers.
If you were approaching the topic from a platform of not knowing how to integrate Excel and Access, then this book will help you, but advanced users will be frustrated with it.
Integration within 2007 is a bit of a nightmare as Microsoft have made some subtle back end changes that are not easily found on the net.
The explantions and examples given are clear and concise and I found it helpful and worth the money
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Access
- Books > Computing & Internet > Microsoft Windows > Applications > Excel
- Books > Computing & Internet > Microsoft Windows > Applications > Office
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Home Office Databases > Microsoft Access
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets