Denver Area Access Users Group

Home
Membership
Presentations
Lab Meetings
Newsletters
Library
Volunteers Needed
Officers
Consultants
Job Postings
Related Links
Downloads
Our Sponsors
Product Reviews
In Memoriam
Featured Sponsor:
Provides Active-X controls for our monthly prize drawing.

The Denver Area Access Users Group helps Microsoft Access users (of all levels) get the most from Access by sharing current methods and techniques.


Regular Monthly Meetings

Date: 1st Tuesday of each month

Time: 6:00 to 6:30 pm - Networking
          6:30 to 9:00 pm - Meeting

Location: Microsoft USA - Rocky Mountain District
               7595 Technology Way
               Suite 400 (4th Floor)
               Denver, CO 80237
               (driving directions)

Click image for map.
7595 Technology Way, Suite 400, Denver, CO 80237

Next Meeting: Tuesday, August 04, 2015

Main Presentation: Use Pass-through Queries for a More Robust Database Solution



Presenter: Patrick Headley


Youíve created a database application in Microsoft Access and you used a database server, as the back-end in order to achieve a high level of performance but there are still some complex processes in your application that take a long time to complete. For example, maybe thereís a report with a large amount of aggregated data that takes a long time to display, even though you used a server View for performance. Donít lose hope. Maybe all you need is a Pass-through Query and some code.

In this presentation you will see how Microsoft Access Pass-through Queries are different from the queries that you normally see in Microsoft Access and how they can make even the most complicated features of your application run quickly. While the focus of the presentation is on Pass-through Queries, you will also see some database server code. This presentation begins with some basic query concepts and finishes with some complex procedures that take advantage of Pass-through queries. So, whether you are new to Microsoft Access or a seasoned pro, there is something in it for you.

Patrick Headley is the President of Linx Consulting, Inc., serving as a database, web and application developer/consultant. He uses various database and application development products, including Microsoft Access, Microsoft SQL Server and .Net. Patrick creates databases and applications from the ground up and also fixes and improves upon databases and applications that were written by other developers; working for for-profit and non-profit organizations. Patrick is the current Web Master of the Denver Area Access Users Group and a Past President of the group. He can also be seen on a regular basis at the DAAUG lab meetings. Please visit the Linx Consulting, Inc. website at www.linxco-inc.com for more information.

Short Presentation: No short topic this month. We are allowing the full evening for Patrick's discussion of pass-through queries.
Presenter: To Be Announced





Lab Monthly Meetings

Date: Last Wednesday of each month January through October plus one "Holiday" lab on the first Wednesday after Thanksgiving.

Time: 6:30 to 9:00 pm
 

Click here for Location Info


DAAUG
on
find us on facebook
follow me on twitter
Denver Area Access Users Group

Copyright© 2001-2015, Denver Area Access Users Group. All rights reserved.

Contact the Webmaster