Denver Area Access Users Group

General Meeting Presentation

Thursday, February 17, 2005

It's a Date and The Data Veg-A-Matic

Jim Pilcher and M. L. "Sco" Scofield

"It's a Date" by Jim Pilcher

One thing that all Access developers struggle to master is date manipulation. Whether it be in a simple select query or complicated mental gymnastics inside a code module, dates have puzzled even the best of programmers. Come to the February edition of the Denver Area Access Users Group. Your presenter, Jim Pilcher, promises his fingers will never leave his hand as he performs date magic right before your eyes.

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. He is currently serving his sixth year as President of the 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 .

"The Data Veg-A-Matic" by M. L. "Sco" Scofield

A common situation that Access developers encounter is having to import data from other sources like old databases, spread sheets, text files, etc. The problem is that the data is never in the format that you need for your database tables. Sco will show some techniques to "slice and dice" the imported data into bits and pieces so that it can be moved into your database's tables. See how functions and update queries can be used to "fix" the data.

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 was awarded the prestigious "Microsoft MVP" award for his fourth consecutive year this past October 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