Cover Image
Read Now

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
Main Author: Schmalz, Michael
Format: eBook
Language:English
Published: Sebastopol, Calif. O'Reilly 2005
Subjects:
Microsoft Access / Http://id.loc.gov/authorities/names/n92084807
Microsoft Access / Blmlsh
Microsoft Access / Gtt
Bases De Données / Gestion
Microsoft Excel (computer File) / Blmlsh
Database Management / Http://id.loc.gov/authorities/subjects/sh85035848
Database Management / Blmlsh
Microsoft Access / Fast
Microsoft Excel / Gtt
Microsoft Excel (computer File) / Http://id.loc.gov/authorities/names/n86025775
Computers / Programming Languages / Sql. / Bisacsh
Database Management / Fast
Microsoft Excel (computer File) / Fast
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
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

Similar Items