General Meeting Presentations

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

Past Presentations - 2006

Thursday, January 19, 2006

So You Want to Be An Access Consultant?

Group Panel

This is a panel discussion and question and answer session designed to let you get some insight into the dynamic world of Microsoft Access consulting.

Thursday, February 16, 2006

The Access Sub-way

Jim Pilcher

Subforms in Microsoft Access are possibly the most effective way to represent one-to-many relationships to your users. DAAUG President, Jim Pilcher, will show you some of the standard practices and hidden surprises that are part of using Access subforms.

Our presenter, James Pilcher, is a prominent Microsoft Access developer in the Colorado–Wyoming region, having worked with Access professionally since its inception in the early 1990s. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local enterprises and large international companies. A frequent presenter at DAAUG, Jim is currently serving his sixth term as President of your Denver Area Access Users Group.

See Jim’s company profile on our DAAUG web site in the Consultant list and on his web site at www.DataOneDenver.com .

Thursday, March 16, 2006

Sco's Miscellaneous Code Samples - Part 3

M. L. "Sco" Scofield

The last time that Sco showed some of his code snippets was December, 2004. This has always been a popular topic. As in the past, audience interest will dictate the direction of the presentation.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. When he is not training or consulting, Sco spends time helping other Access users in the Access newsgroups on the Internet. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time he spends helping Access users.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, April 20, 2006

Hitting for the Cycle with Outlook and Access

Mike Nindorf

This month’s presentation will demonstrate an application that uses Outlook, Access, Word and Adobe (writer) to create a Bankruptcy (PDF) Invoice. This process reads and modifies Outlook forms while storing the information in an Access database. The process will then pull correct bill information from an Oracle database, calculate the percentage used for the bankruptcy invoice, do the calculations and finally create the appropriate Word and PDF files. A form will then display for the Analyst to verify/change the results and give the option to send the required PDF file back to the requestor.

Our presenter, Mike Nindorf, is currently employed at Sprint and has been automating business processes since 1985- yes, that is pre Windows. Programming knowledge base include VBA, Holos, Excel and SQL. An expert in data-mining and with innovative way of solving business problems, his most recent accomplishments include automating an automated tool that will unzip, balance and burn to CD "electronic bills" for over 2,000 customers per month.

Thursday, May 18, 2006

You don't need to be a web guru to use a Web Service

Danny J. Lesandrini

It's not like we live on an island. In fact, even those who live on islands aren't limited to the island anymore. Access developers may now leverage all the power of the Internet from the comfort and convenience of their familiar VBA code modules. Learn how to use Microsoft Access with the Web Services Toolkit to do things like; validate email an address, retrieve stock quotes or display a random Hungarian proverb.

Danny J. Lesandrini, although having programmed in FORTRAN with a keypunch machine and punch cards over20 years ago, became bored and strayed from the path of technology. Then in the mid 90's, prompted by a friend to return to the field of programming, he dove head-first into Microsoft Access. Today, Danny is a Microsoft Certified Professional in Access, Visual Basic and SQL Server, has been programming with Microsoft development tools since 1995. He maintains a web site with free code samples at http://amazecreations.com/datafast and replies to all questions and comments sent to datafast@comcast.net.

Thursday, June 15, 2006

The Secrets of Security

Wendell Bell

If you are building Access applications for anyone other than yourself, you really need to restrict users from things that can break the application, or even destroy it. This presentation will look at a number of features in Access that provide security, and also explore securing your back-end.

After spending 27 years in the telecommunications industry, Wendell Bell began a consulting practice based on Microsoft products in 1991. With the release of Access, he began focusing primarily on database applications, and currently supports several clients in the Denver area, as well as applications deployed in Washington State, Texas and Nebraska. He also serves as a moderator of the WOPR Lounge Access forum.

Thursday, July 20, 2006

Overview of Microsoft Office Access 2007 from a Developer Perspective

Michael McCormack, Microsoft Access Program Manager, Redmond, WA

NOTE: This month we have something different and unexpected for the presentation. We were able to get one of the Access Product Managers from Microsoft Redmond to talk to us this month, via Live Meeting about Access 2007.

Access 2007 provides developers with the ability to build much richer databases much more quickly. This session discusses new functionality for building client databases, and covers Access's new designers, new coding tools, the ability to create custom task panes, collecting data through email, and customizing the ribbon UI. In addition, we show the out-of-the-box "tracking applications" that will ship with Access 2007, and show some of the tools used to build those apps and that will ship in the Access Developer Extensions.

Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003. Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.

Thursday, August 17, 2006

Database Show ‘N Tell

DAAUG Members

Remember how fun Show 'N Tell was in kindergarten? Well this month you can re-live a bit of your youth. Come to the Denver Area Access Users Group database Show ‘N Tell! We will have short presentations by three members who have volunteered to show off a few cool features in an Access database that they have created.

Duane Hanstein of Dynamic Association Mapping, (DAM) will demonstrate using Access to update a Geographic Information System GIS.

Jim August of CORE, Inc. will talk about his company's reliability database application.

Bruce Handley of Handley Computer Corp. will demonstrate some features of one of his company's products called ClientMinder.

Thursday, September 21, 2006

Ribbon Extensibility in Microsoft Office Access 2007

Michael McCormack, Microsoft Access Program Manager, Redmond, WA

Say goodbye to CommandBars, and say hello to the Ribbon! The Ribbon is at the core of the new user experience in Microsoft Office 2007. The Ribbon provides an innovative way to display and organize commands that improve usability and user productivity. In this session you'll discover how the Ribbon exposes a rich and flexible XML-based extensibility model in Microsoft Office Access 2007. You'll explore the new programming model, learn best practices, and see how to incorporate the Ribbon design philosophy into your applications. You'll look at backward compatibility for custom CommandBars in Access 2007.

Our presenter, Michael McCormack, is a program manager at Microsoft Corporation working on the Microsoft Access development team. His team is currently working to enhance the overall usability in Access, with a personal focus on navigation, command structure (especially the ribbon) and the shell. Michael has worked at Microsoft since 2000, and prior to working as a program manager, Michael served as a software test engineer, and as a lab manager overseeing a large network. Previous projects include Microsoft Office Excel 2003.

Michael holds a Master's of Science in Information Management from the University of Washington. Prior to working at Microsoft, Michael was a Microsoft Partner designing and developing Access Databases, and Visual Basic - SQL Server client server applications as a consultant and developer.

Thursday, October 12, 2006

Normal Forms

Jim Pilcher

NOTE: This month's meeting is one week early because of the Denver Microsoft Office moving

Everything you ever wanted to know about database normalization and referential integrity.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado front range area, having worked with Access professionally since 1992. 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 in the Consultant list and on his web site at www.DataOneDenver.com .

Thursday, November 16, 2006

Word Automation from Access and A Variable Declaration Review and Class Module Properties"

Alan Ruff and M. L. "Sco" Scofield

First Meeting at the NEW Denver Microsoft Office!

"Word Automation from Access" by Alan Ruff

How to build Word template forms, automate customer statements, and avoid Word automation pitfalls

Alan Ruff is a Microsoft Access Developer and IT Administrator Consultant in the Denver area. He has worked with Microsoft Access since the early 1990's and has an emphasis in Accounting. He currently has his own consulting business named "Ruff Group" which serves Denver area clients.

"A Variable Declaration Review and Class Module Properties" by M. L. "Sco" Scofield

During the July 2006 Report Tip presentation it became clear that the group needed a refresher on variable declaration, variable scope, and how to create class module properties. Do you know that Public doesn't always mean global? Do you know that you don't always need Property Let and Property Get to create class properties? This is a "back-to-the-basics" presentation of information that every VBA programmer needs to understand cold.

Our presenter, M. L. "Sco" Scofield, is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and the current President of our group. Sco is also a frequent speaker at our group. He has been using Access since version 1.0. Sco spends a large amount of his time as an instructor training all levels of Access from the introductory level all the way through advanced programming. He is a "Microsoft Certified Solution Developer," a "Microsoft Certified Professional," and is A+ certified. Sco was awarded the prestigious "Microsoft MVP" award from 10/1/2001 through 10/31/2005 in recognition of the time that he spent helping Access users in the Access newsgroups on the Internet.

See Sco's company profile on our DAAUG web site Consultants list at www.daaug.org/consultants.asp and on his web site at www.ScoBiz.com.

Thursday, December 21, 2006

Annual Holiday Party Cancelled Due to Weather

See you in January