1 / 7

Automating Microsoft Access (Data) Without Code

Discover how to automate Microsoft Access data using non-programmatic methods. This guide explores the fundamentals of OLE Automation and how Microsoft Access serves as an automation server. Learn about leveraging Microsoft Word to manipulate Access data without writing code. By understanding how to insert Access databases, utilize pre-existing queries, and perform mail merges, you can streamline your data operations effectively. Unlock the potential of Access data automation and enhance productivity without delving into complex coding.

Albert_Lan
Télécharger la présentation

Automating Microsoft Access (Data) Without Code

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Automating Microsoft Access (Data) Without Code Daniel Ogden Co-SIG Leader NTPCUG Application Developer Issues SIG http://appdevissues.tripod.com http://appdevissues.tripod.com/downloads.htm Automating Microsoft Access (Data) Without Code

  2. Automation • Began its life as OLE Automation (OLE 2.0) • OLE Automation Server • Application capable of exposing its object model for programmatic manipulation by automation controller • OLE Automation Controller • Application capable of programmatically accessing and manipulating an automation server’s objects • Became ActiveX Automation with introduction of ActiveX Controls (COM) • Now just called “Automation” Automating Microsoft Access (Data) Without Code

  3. Access as an Automation Server • Technically, it is not automation unless it is done programmatically with an automation controller controlling an automation server • However, the end result of automation can be achieved using non-programmatic means • This requires a application that can access Access data and internally manipulate that data • MS Word is a good example of an application that can achieve the results of Access automation by non-programmatic means Automating Microsoft Access (Data) Without Code

  4. Access Capabilities as a Data Automation Server for Word • In a non-programmatic setting, it is really Access data rather than Access itself that is automated in Word for manipulation • In a non-programmatic setting Word is essence becomes a data client rather than an automation controller • Access can exposes its tables and queries for manipulation • Access can not expose its forms and reports for manipulation Automating Microsoft Access (Data) Without Code

  5. Word as an Access Data Client • Insert Access Database • Using Pre-Existing Access Queries • Static Format • Dynamic Format • Using MS Query With No Pre-Existing Access Queries • Static Format • Dynamic Format Automating Microsoft Access (Data) Without Code

  6. Word as an Access Data Client • Mail Merge from Access Database • Using Pre-Existing Access Queries • Using MS Query With No Pre-Existing Access Queries Automating Microsoft Access (Data) Without Code

  7. Automating Access Data in Word With Macros • Word’s macro recorder generates VBA code • Word-created VBA code can be easily manipulated to quickly expand Access data automation Automating Microsoft Access (Data) Without Code

More Related