Denver Area Access Users Group

Kevin Bell, former VP and DAAUG member, now working on the Access Development team for Microsoft, will visit Denver this month and discuss Access 2010 from a developer's point of view.

Access 2010 has given us a great new power to push our applications into a web browser. Is this round two for data access pages or a true game changer? In this meeting we will begin to explore the differences between Access 2010 web apps (via SharePoint 2010) and client apps. We will discuss… how the design interface changes, what environments are best for Access 2010 web apps, strategies for deployment and how to make your tables web compliant. Paul Schnitzler if a full time Access & SQL Server developer serving a wide variety of business. He has over 10 year of experience with Access and SQL Server.

Many attempts have been made over the years to provide a single form that allows the end user to manage all lookup tables in a database. Most attempts fall short of what a developer wants to provide a client. Jim Pilcher will show you such a form which reads table structures and configures itself to provide a more pleasant and professional experience for the client.

Luke Chung visits DAAUG again to discuss Microsoft Access in 2011

Developers have screamed for this capability for several versions of Access. Find out how to use table macros to automate common database tasks at a table level. We will look at the before & after data macro events as well as named macros. Here are some of the examples that you will see… keeping track of who last updated a record, writing to a history table after a delete or change, maintain a de-normalized total on a parent table. Access 2010 has put a new face on the macro designer and added new functionality like parameter support, IntelliSense and copy and paste.

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.

Jim Pilcher will show you how to create a contemporary menu and forms navigation system using this exciting new feature in Access 2010. Jim will discuss the various properties of this control and how you might use it creatively in your own applications. Believe it or not, the Navigation Control is relatively easy to use and offers the opportunity for a shorter presentation, so there will be a question and answer session following, as time allows.

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

Importing Data From Excel

Have you ever tried to import data from Excel into Access and not all of your data was imported or you received type mismatch errors? With the procedures shown in this presentation you will be able to get your data into Access and take control of data inconsistency issues.

Make List Box and Combo Box controls work better.

In Microsoft Access, when you scroll down a List Box or the list of a Combo Box control that has many items in it, scrolling doesn’t work as expected until you reach the bottom of the list. In addition to that, when you requery the contents of a List Box control, say after returning from a detail form that may change the values displayed in the list, you loose your previous selection. This presentation uses a List Box control to show you how to make lists behave as you would expect, from the start.

Visual Studio LightSwitch and Kexi

There are some new kids on the block that compete with Microsoft access. Neither product completely clones the features and ease of use that Access offers but they are close enough that you should at least be aware of what they are. You will eventually have to face them. This will be a high-level overview of both products but you will be able to see what they are and decide how pertinent they are to the work you do. If there is enough interest in either product we could have a more detailed presentation in the future.

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.

Topics covered:

~ What is XML?

~ XML interaction through Access menus (2007,2010)

~ DOM object

~ Using the DOM for XML /Access interactions – code examples of XML file confirmation, importing, exporting, creation, transformation, and web file downloads

~ Real-world examples of XML Access interactions

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.

Come to the September DAAUG meeting and join Jim Pilcher as he shows you some common, obscure, and (of course!) useful VBA functions that you can employ in your Access queries, control properties, and VBA code. Jim will show you how knowledgeable and creative use of built-in VBA functions can save you time, coding, and aggravation.

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 international concerns. A frequent presenter at the Denver Area Access Users Group, Jim has served eight terms as President, and five terms in other DAAUG capacities. Visit his web site at www.dataonedenver.com

Microsoft has been working to integrate Access and SharePoint for several versions and it has blossomed with 2010. We will explore Web Database, Client Applications and Hybrid Applications. Discuss how to provide low cost hosting solutions for small business and leverage corporate IT commitment to SharePoint Enterprise. We will build a simple database… tables, forms and reports and then publish it to SharePoint. We will then look at some more involved examples to show how you can leverage this new technology.

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.

No Main Presentation - It's the Annual Holiday Party!

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.