Denver Area Access Users Group

During this presentation we will explore several ways of integrating email into Microsoft Access. Included in this will be the new Access 2010 ‘Collect data by using e-mail messages’ feature (and one that Aaron custom built), Outlook integration, Gmail integration and how to send text messages (to a cell phone) from Access /email.

YOUR PARTICIPATION IS REQUESTED!: Please bring your laptop to the January meeting. Aaron will need people to send ‘reply responses’ during his presentation. You will be rewarded for you efforts.

Our presenter, 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 Geographical 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.

Take a look at forms that were developed with older versions of Access and then compare to ones that were built with 2007 or 2010. The newer forms generally have a cleaner more modern look. We will take an in depth look at several new features that were introduced in 2007 and 2010…. Using Themes, The New Image Gallery, Control Grouping / Table Layout, Anchoring and Alternate Row Colors. I will also show a recent 2010 application that I put together in 20 hours. It is amazing what you can you can do with the power of Access.

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server.

Last month you saw many of the new features of forms in Access 2010. In March, Jim Pilcher will take you under to hood of Access forms and discuss the power of event procedures. This will be a VBA-centric discussion about how to harness the ultimate power hidden within Access forms. Jim will lead you through the most common and most powerful event procedures along your path from power user to experienced Access developer. Don't miss this presentation!

Jim Pilcher is president of DataOne, Inc., serving database clients in the Colorado Front Range and across the United States since 1997. Jim also served as DAAUG president from 2000 through 2007 and continues to do regular presentations at the DAAUG monthly meetings.

Phil found a very neat menu system on www.utteraccess.com that he has deployed into an application. He will show you how you can integrate it into your own programs.

Phil Ferrero is an IT professional with a public health, accounting, finance, operational, and managerial background. I design database applications for small to mid-size organizations that need a simple solution for integrating technology into their business processes.

~ Microsoft Access Database Design and Programming

~ Relational Database Design

~ VBA, DAO and ADO, MS Office integration

~ XML data manipulation and integration

~ 10 years of MS Access development experience and 15+ years of IT-related experience.

Due to a family emergency our original presenter had to cancel. Paul Schnitzler put together a last minute presentation on how to generate Google maps from Access. Several examples were presented from basic single address to an advanced process that he recently deployed that generates points and routes

Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server. Paul is frequent presenter at the Denver Area Access Users Group and in his second term as DAAUG Vice President. Visit his web site at www.gearitservices.com

With this being the evening before the 4th of July we expected a very low attendance. At the June meeting we discussed and decide to cancel this meeting. Have a happy 4th and we will see everyone at the August meeting.

Patrick stepped up and covered a last minute cancelation…. showing us an Access SQL server solution that he is working on.

Patrick Headley is a database application consultant developing applications in Microsoft Access, .Net, ColdFusion, PHP, SQL Server, PostgreSQL, and MySQL. He has been in the Microsoft Access development world since 1997 and has had his own company, Linx Consulting, Inc., since 2003. Patrick is also the current president of the Denver Area Access Users Group.

This month we take another look at the Microsoft Office Ribbon object model. Jim Pilcher will show you how to use the IDE Ribbon Creator as a creative tool, but will then venture into custom hand-written ribbons. Ribbons and VBA are tightly associated in Microsoft Access.Jim will show you some common techniques to get ribbons and VBA talking to each other. Jim will also provide an impressive and daunting list of web resources that can help you become the Office UI guru you always wanted to be.

Jim Pilcher is a prominent Microsoft Access developer in the Colorado Front Range, having worked with Access professionally since its introduction in 1992. Jim’s company, DataOne, Inc., maintains a broad clientele base providing database solutions for local and state-wide enterprises, as well as large international companies. A frequent presenter at the Denver Area Access Users Group, Jim served eight terms as its President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Join us for this special evening to take a look back at the origins of Access, how it evolved and where it is going. We will start by looking back 20 years ago at the first release of Microsoft Access, and how it has evolved over the years into a robust client server front-end. Then we will explore the 11th release of Access, the new Access 2013. Access 2013 takes a dramatic new approach to creating databases application and we will explore its architecture and features. We will also discuss how your existing Access skills can be leveraged with Access 2013.

Kevin is a testing software engineer on the Microsoft Access team in Redmond Washington. Prior to joining Microsoft in 2008, he spent 15 years running a consulting practice that specialized in creating custom client server applications for small businesses. Kevin has been working with Microsoft Access since version 1.0 and SQL Server since version 4.21.

No Main Presentation - It's the Annual Christmas Holiday Party! The majority of the meeting is for members and visitors to meet, eat well, relax, and chat.