A little shameful self promotion: Mike Alexander and I are putting on an Excel and Access Integration Workshop in Dallas in a couple of weeks. Here’s the details.
Excel and Access Integration Workshop
Monday, May 18, 2009 – Tuesday, May 19, 2009
3240 Parkwood Boulevard
Frisco, Tx 75034
Map and Directions
Microsoft MVPs Dick Kusleika (Daily Dose of Excel) and Mike Alexander (DataPig Technologies) bring you the first ever Excel and Access Integration Workshop!
This 2-day workshop is designed to give you a comprehensive review of the wide range of integration techniques that can be performed using Excel and Access. Through step-by-step instruction, you will explore the benefits of integrating Excel and Access, the differences and similarities between Excel and Access, and some of the common pitfalls of moving and analyzing data across applications.
The goal of this workshop is to help you to explore all the functionality that exists when Excel and Access are brought together, liberating you from the daily grind of routine data practices. During this 2-day workshop, you will learn how to:
* Easily move data between Excel and Access
* Store Excel data in a structured relational database
* Use Excel pivot tables with Access Data
* Report Access Data using Excel’s presentation layer
* Move Data between Excel and Access using MSQuery and SQL
* Automate redundant processes using Macros and VBA
Note: This course involves the use of VBA and fundamental Access techniques which will not be covered during the 2 days of this event. In order to get the most out of this workshop, we highly recommended that you have some experience working with Access and a basic understanding of VBA.
Each registered student will receive free books and other prizes.
Excel and Access Integration 2-Day Workshop: 1 Seat – $600