Want a NOOK? Explore Now
Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually 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 two work together, you’ll find that your team’s productivity is the real winner.
Acknowledgements.
Introduction.
1. Getting Excel Data into Access.
2. Analyzing Excel Data with Access Queries.
3. Sprucing Up Excel Data with Access Reports.
4. Using Pivot Tables and Pivot Charts in Access.
5. Getting Access Data into Excel.
6. Leveraging Macros in Excel and Access.
7. VBA Fundamentals.
8. Using VBA to Move Data Between Excel and Access.
9. Exploring Excel and Access Automation.
10. Integrating Excel and Access with XML.
11. Integrating with Office Applications.
Index.
Anonymous
Posted Sun Mar 31 00:00:00 EDT 2013
Go to the next res
0 out of 1 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Tue Sep 25 00:00:00 EDT 2012
Well this is a note he (andrew) wrote about cali to god Dear god,I want to thank you for pastoing this angel upon me I smile everytime I see her posts but I kmow a guy like me does not deserve a girl like her,
Your son Andrew...
0 out of 3 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually 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 two work together, you’ll find that your team’s productivity is the real winner.
...