Excel and Access Power User Workshop Chicago

Oak Brook, Illinois
Wednesday, May 18, 2011


Day 1:   Day 2:
Integrating Excel and External Databases Leveraging SQL Backend Solutions
7:30 - 8:00  7:30 - 8:00 
Breakfast served on location  Breakfast served on location 
8:00 - 12:00  8:00 - 12:00 
Basic Integration Techniques Building and Distributing Professional Solutions
Mike Alexander Mike Alexander
▪ Techniques for Moving Data Between Excel and Access Writing Data back to SQL Server Databases
Hooking Excel Pivot Tables to External Databases
Leveraging Pass Through Queries to Improve Connected Dashboard solutions.
▪ Creating Dashboard Visualizations in Access Databases ▪ Creating Install Packages for your Excel and Access Solutions.
▪ Using PowerPivot to Simplify Data Connectivity
   
12:00 - 1:00  12:00 - 1:00 
Lunch Buffet served on location   Lunch Buffet served on location  
1:00 – 5:00  1:00 – 5:00 
Advanced Reporting Techniques using MSQuery Improving your VBA Code
Dick Kusleika Dick Kusleika
▪ Using External Databases with your Dashboards and Reports
▪ Techinques for Improving your VBA
▪ Understanding SQL and its role in using MS Query
▪ Adding Efficiency by Moving to Class Modules
▪ Passing Parameters from Excel to External Databases
 
▪ Passing Wildcards To External Databases
 
▪ Enhancing Dashboards and Reports with Connected Data Models  
5:00 – 6:30  
Free Form Q&A  
▪ Catch up on Class Projects  
▪ Get Help on Specific Projects  
▪ General Q & A  
 

Contact Information

  • Phone: 214-578-2141
    Email: mha105@yahoo.com

Payment Instructions

  • Register with Credit Card
    Click the Register Now button above

    Invoice or PO
    If your organization requires an invoice or purchase order,
    contact us
    . 
    Be sure to include your contact information.

    Register with Check
    To Register with Check or Money Order, make payable to DataPig Technologies.

    Mail to:
    DataPig Technologies
    7548 Preston Rd #141-136
    Frisco, TX  75034

    *Be sure to include your email address so that we may contact you with registration information

© 2017
Quick, easy and affordable online event registration and event management software for all event sizes.