Denver Area Access Users Group

General Meeting Presentation

Thursday, September 15, 2005

The Creation of a One Form Application

M. L. "Sco" Scofield

This presentation will be a complete look at a mini, one-form application starting with the original concept and taking it all the way through turning it into an Access add-in so that it is always available. What's the application? It's a designer utility that sends the basic information about all of the table designs in a database to an Excel workbook.

This presentation will be an advanced presentation with lots of VBA code. You will see how to extract table information using DAO, how to control Excel using Automation, and how to make a user interface to control the application and provide user information. The presentation will wrap up with a few techniques to put the final "polish" on the application and what it takes to turn a project like this into an Access add-in.

Come spend an informative and entertaining evening with our resident MVP and current Vice President!

Our presenter, M. L. "Sco" Scofield is a Microsoft Access trainer and consultant in Denver, Colorado. He is an active member and Vice 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 has received the prestigious "Microsoft MVP" award every year since 2001 in recognition of the time he spends helping Access users.

See Sco's company profile on our DAAUG web site in the Consultant list and on his web site at