General Meeting Presentations

2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003

Past Presentations - 2009

Thursday, January 15, 2009

Deployment Strategies for an Access Application

Paul Schnitlzer

Paul will talk about the strategies of how to deploy and update Access applications in a network and distributed environment. He will show what Microsoft gives us, an overview of third party tools and scripts, and some home grown solutions. Paul will also talk about some specific challenges with deploying 2007 applications.

Our presenter, Paul Schnitzler, has been working with Access and SQL server for the last 8 years. Starting as a corporate developer in the construction field for 5 years. And as an independent developer for the last three years in construction, commercial real estate, non-profits, manufacturing, health care, trucking and variety of other fields.

Thursday, February 19, 2009

Let’s Build an Application from Scratch - Part 3

Jim Pilcher and Patrick Headley

Continuing an interactive discussion and design of a "Video Library" database from previous meetings . . . Join us to understand how to design an Access database.

Thursday, March 19, 2009

Advanced Features in Access 2007

Luke Chung, FMS, Inc.

The Denver Area Access Users Group is proud to present Luke Chung. Luke is President of FMS, Inc. He was recognized by the Microsoft Corporation as an Access Hero on the 10th anniversary of Access’ existence and is a popular speaker in the US and Europe.

Luke will discuss advanced database features in Microsoft Access 2007. His presentation will concentrate on new and innovative features in Access 2007 that developers and users need in order to make the most effective use of the new data types and capabilities in Access 2007. He will discuss the features in Microsoft Access 2007 that should compel you and your users to migrate, Access products from FMS, and a variety of ways you can be more productive with Access. He’ll also answer any questions he can regarding Access, future trends, and how you can best handle these challenging times.

FMS has tens of thousands of customers in over 100 countries, including most major organizations. FMS also offers a custom database application development services though its Professional Solutions Group (http://www.fmsinc.com/Consulting/), and solutions for the intelligence, defense and law enforcement communities through its Advanced Systems Group (http://www.fmsasg.com).

Tuesday, April 7, 2009

Access Add-Ins and Code Snippets

Aaron Kogan

This month, Aaron will describe more of the time-saving and dynamic code snippets that he has developed over the years. The "Little Buddies" from his code library are more than worth their weight in gold if you develop Access applications for your clients or for fun. Add-ins allow easy access to tools, created by you or someone else, in virtually all of your database projects. Aaron will be showing some Access add-ins that he has created. (And maybe a couple that he stole.) After his presentation, the Group will continue discussing the new features in Access 2007, if there is time. It seems that the more we use Access 2007, the more we find new and valuable features.

Aaron Kogan is the owner of SLM Data, LLC. He has been developing databases for the National Park Service, The Nature Conservancy, The Maui Invasive Species Committee and many other companies since 2000. Aaron also dabbles in Geographic Information Systems (GIS) when he has a free moment. Aaron can be contacted at Aaron@SLMData.com or check out SLM Data LLC’s website at www.SLMData.com.

Tuesday, May 5, 2009

Let’s Build an Application from Scratch - Part 4

Jim Pilcher and Patrick Headley

This presentation has just been so darn popular that we're doing it again!

This month, Jim Pilcher and Patrick Headley will continue with the development of the DAAUG DVD/Movie database. Now that the table design is complete, we will look at setting a few validation rules and default values for various fields and discuss the relative merits of incorporating lookups directly into Access tables. Time-permitting, we will also begin looking at Access forms. Bring a USB flash drive if you want a copy of the database as it exists at the end of the presentation.

Our first co-presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member and past President of our group. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Our second co-presenter, Patrick Headley, is a developer and consultant for several Microsoft products, including Microsoft Access. He is an active member and the current President of our group. See Patrick's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.LinxCo-Inc.

Tuesday, June 2, 2009

Everyday VBA for Really Smart People

Jim Pilcher

Let your former DAAUG president, Jim Pilcher, show all of you really smart people some everyday solutions he’s crafted with VBA. Learn about compiler directives, conditional formatting controls with code, changing table structures with VBA/DAO, the difference between the various DAO recordset types, and oh so much more. As an added bonus, every member attending will be eligible for a copy of the presentation database with all of the code and examples discussed during the evening. Just bring your USB flash drive and Jim will burn you a copy to cherish and treasure. Don’t miss this opportunity to be a really smart person.

Our presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member and past President of our group. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Tuesday, July 7, 2009

Create a Winning Application

Patrick Headley

Patrick Headley has created a drawing application that we use at the DAAUG meetings. Patrick’s presentation will begin with an overview of the features of the application. He will then answer your most asked question; how does the application make random selections of prize winners. After that, Patrick will go into some of the more interesting programming details of the application, such as Relationships, form Open events, and error handling and logging. If time permits we will cover other parts of the application that you are interested in.

Tuesday, August 4, 2009

Advanced Query Use with VBA

Jim Pilcher

Jim Pilcher will show you how to integrate Access queries into your VBA with special attention paid to action parameter queries.

Tuesday, September 1, 2009

Ribbons without Bows - Access 2007

Chuck Robbins

Beginning Ribbons for MS Access 2007. We will develop an application that utilizes the new ribbon navigation and control functionality available in MS Access 2007. We will start out with the basics of XML used for the ribbon and progress into third party applications that manipulate the ribbon.

Tuesday, October 6, 2009

Table Interface Classes and Automated VBA Code Generation

Lindsay Wert

Development of any non-trivial MS Access application can involve generation of a variety of VB code elements. Some of these elements may feel repetitive because the pattern is the same, but the details are different. In this discussion, we will explore an area where such repetition is advantageous, but repetitive nonetheless, namely VB classes to interface with Access tables. In addition, an add-in method for automatically generating the VB code for these classes will be discussed.

The discussion will include:

  • Table interface classes, what they are, their purpose, and examples of their use
  • Automated VB code generation based on templates and table definition extracted using DAO, and implemented as an add-in.

Lindsay Wert is a consulting product development manager and engineer with extensive experience managing and participating in engineering development of multiple-technology electro-mechanical devices and software applications, including applications for small business based on MS Access and Java web platforms.

Tuesday, November 3, 2009

Access and a Paperless Office

Paul Schnitzler

How many files revolve around your Access applications? Example in Northwinds… is there a signed PO for each order? ...is there a filled out credit application for each customer? ... is there an email in Nancy Davolio’s Outlook that should be come part of the customer record? In this presentation you will see how to manage window files with your Access application and have them be click away. Go green…save a tree and recycle a file cabinet with your Access applications. Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 10 year of experience with Access and SQL Server.

Tuesday, December 1, 2009

Let’s Build an Application from Scratch - Part 5

Jim Pilcher and Patrick Headley

Back by popular demand!

This month, Jim Pilcher and Patrick Headley will continue with the development of the DAAUG DVD/Movie database. This month we will look at Access forms and subforms. Bring a USB flash drive if you want a copy of the database as it exists at the end of the presentation.

Our first co-presenter, Jim Pilcher, is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. He is an active member, past President, and current Vice President of your group. A Microsoft Certified Professional, Jim’s company, DataOne, Inc., maintains a broad clientele base providing Access & SQL Server solutions for local enterprises and large international companies. See Jim's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.DataOneDenver.com.

Our second co-presenter, Patrick Headley, is a developer and consultant for several Microsoft products, including Microsoft Access. He is an active member and the current President of our group. See Patrick's company profile on our DAAUG web site Consultants list at http://www.daaug.org/consultants.asp and on his web site at www.LinxCo-Inc.