Microsoft Excel and Access Integration

With Microsoft Office 2007

Michael Alexander, Geoffrey Clark (Autoren)

Buch | Softcover

408 Seiten

2007
John Wiley & Sons Ltd (Verlag)
978-0-470-10488-0 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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.

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.

Erscheint lt. Verlag	4.5.2007
Verlagsort	Chichester
Sprache	englisch
Maße	187 x 230 mm
Gewicht	620 g
Themenwelt	Informatik ► Office Programme ► Access
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	0-470-10488-0 / 0470104880
ISBN-13	978-0-470-10488-0 / 9780470104880
Zustand	Neuware