Beginning Presentation:  Drive Business Decisions by Tracking and Analyzing Data from Multiple Data Sources Instantaneously using Excel PowerPivot

Presenter:  Caren Grandgenett

Description:    Demonstration of Microsoft Excel PowerPivot that allows instantaneous collection, management and analysis of data from various sources; including Excel, Access and any number of other sources.

Caren Grandgenett is a database development and training specialist, with expertise that empowers clients to track customers, competitors and business metrics.  Clients include Cherub Medical Supplies, Tall Grass Freight, and Johnson County Community College


Advanced Presentation:   Creating a custom function in Access

Presenter:  Lisa Friedrichsen

Description:    Have you ever needed to calculate a bonus, stipend, commission, or any other value for your employees based on your company’s unique policies and business needs?  If so, you’re looking at an excellent candidate for an Access custom function to help you do the work.

A custom function is a saved formula that allows you to quickly, consistently, and accurately calculate a result.  A custom function defines a unique formula that you create in a VBA module.  Once the custom function is created it can be used over and over again in queries, forms, and report.

In this example we’ll create a custom function called STIPEND.  The STIPEND function will return a value of $0, $250, or $50 based on several conditions including the enrollments and number of sections an instructor teaches over the course of the academic year.

By defining STIPEND once as a custom function, we will greatly simplify every query, form, and report that needs to calculate stipend values.

Lisa Friedrichsen is a professor of database and Web technologies at JCCC.


Drawing: Microsoft Access 2013 Absolute Beginner's Guide by Alison Balter  Make the most of Access 2013--without becoming a technical expert! Give-away drawing for HUG members only.  Sponsored by: Heritage Computer Consulting & Services, Inc.

Arlene Watkins | President/CEO