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

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Schmalz, Michael
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Sebastopol, Calif. : O'Reilly, 2005.
Temas:
Microsoft Excel (Computer file)
Microsoft Access.
Microsoft Access
Database management.
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
Database management
Microsoft Excel.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares