Loading…

Integrating Excel and Access /

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. Unti...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Schmalz, Michael
Format: Electronic eBook
Language:Inglés
Published: Sebastopol, Calif. : O'Reilly, 2005.
Subjects:
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • Introduction to Access/Excel integration
  • Using the Excel user interface
  • Data access from Excel VBA
  • Integration from the access interface
  • Using access VBA to automate Excel
  • Using Excel charts and pivot tables with access data
  • Leveraging SQL server data with Microsoft Office
  • Advanced Excel reporting techniques
  • Using Access and Excel data in other applications
  • Creating form functionality in Excel
  • Building graphical user interfaces
  • Tackling an integration project.