General Meeting Presentations

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

Past Presentations - 2004

Thursday, January 15, 2004

Access Parameter Queries and Query by Form

M. L. "Sco" Scofield

Thursday, February 19, 2004

Access Form Events

Jim Pilcher

Thursday, March 18, 2004

Automating Excel with Access

Danny J. Lesandrini

Thursday, April 15, 2004

Advanced Report Design

Jim Pilcher

Thursday, May 20, 2004

Access Query Joins

M. L. "Sco" Scofield

Thursday, June 17, 2004

Importing Complex XML into Access; Publishing Data with the Web Matrix Tool; Sco's Miscellaneous Stuff

Danny Lesandrini; Kevin Bell; M. L. "Sco" Scofield

Thursday, July 15, 2004

10th Anniversary Meeting and Celebration: New features in Access 2003, the Microsoft development process and how features make it in to Access, and the future of Access

Jon Sigler, Access Group Program Manager, Microsoft

Thursday, August 19, 2004

Database Design a Rational Approach

J. Mel Harris

Thursday, September 16, 2004

Access Totals Queries

M. L. "Sco" Scofield

Thursday, October 21, 2004

Maximizing Access Performance

Wendell Bell

Small Access databases don't usually have performance issues - but small databases have a habit of growing up to become big databases with slow response times, and then you as the developer are faced with fixing it. In this presentation, Wendell Bell will explore the kinds of performance bottlenecks you are likely to encounter, and various methods of improving the situation. Topics to be covered include the judicious use of indexes, dealing with LAN performance issues, masking performance issues with the user interface, when to consider upsizing to SQL Server, and performance issues with WAN or web interfaces.

Wendell has been an active user of Microsoft products since 1986, began his consulting practice in 1990 after spending 27 years with AT&T and Bell Labs, and since 1994, has been specializing in using Access as a front-end to SQL Server. He and his partner Kevin have deployed more than 100 production databases in Colorado and other cities around the world. In addition, Wendell serves as a moderator for the Access forum on the peer-to-peer help site known as Woody's Lounge - it can be found at www.wopr.com/lounge - and you can read more about his background and avocations at www.access-experts.com.

Thursday, November 18, 2004

Bulletproofing an Application

Kevin Bell

bul·let·proof adj.

1. Impenetrable by bullets
2. Informal. Impervious to assault, damage, or failure; guaranteed

As Access Applications mature, they tend to get more complex, are used by more people and often become a critical tool for a businesses success. While performance issues are usually easy to spot, bulletproofing an application is an exercise in predicting what can go wrong, and reacting to it before it happens. In addition to protecting your users from a bad computing experience, you also need to be concerned with protecting your application’s data and intellectual property from prying eyes. While even the most robust database application is no match for Dirty Harry, there are several tricks that can help make your Access application more stable and secure. In this presentation we will explore several different strategies for making your application more robust and maybe even bulletproof.

Kevin has been developing custom business solutions with Access since version 1.0 and SQL Server since version 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit their web site at www.access-experts.com for an Access tip of the day.

Thursday, December 16, 2004

Annual Holiday Party

The Denver Area Access User Group hosts its annual Holiday party on December 18th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.

Although we will not be having a full length main presentation, sometime around 7:30 we will be having one of our expanded Thirty (Sixty???) Minute Topics.

The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.