Connecticut Access Users Group

CTAUG meetings are free and open to the public, and are normally held on the second Wednesday of each month, in the evening.

If you have a suggestion for a presentation, or better yet, if you'd like to present something, please contact Adam Osmond, (adamosmond14@gmail.com), our Presentations Officer.  Your presentation can be long or short. We also welcome attendees who wish to solicit solutions to problems from the audience. 

  Wednesday, August 11, 2010
  About the next meeting:
  Date: Wednesday, August 11, 2010
  Where: Microsoft Corporation, Pondview Corporate Center
    74 Batterson Park Road
    Farmington, CT
  Time: 5:30PM to 9:45 PM
  Main Topics:

To Be Determined 

  Future meetings: Pat Hartman:
  • An overview of some of the new features in Access 2010
  • Demonstration of the new integration between Access and Sharepoint
  • A website that supports one of the applications Pat created
  • Hosting DB's on the Web at future meetings.

Ed O'Reilly has been working on accessing data on the Web using Access.  Ed has already showed us some of this, hopefully he'll show more at a future meeting. 

James King will demo and lead short discussions (with much input from more experienced members) of the following QueryDemo topics: 

  • Built in SQL operators: ANY, ALL, LIKE, etc.. 
  • Self Joins
  • Subqueries with and without Correlation Variables
  • Crosstab Queries
  • How SQL and Access Handle Null Values in data and in computations

Sarah Worthen will show us the variable quality of Object Models.  Examples:  Power Point's Object Model is ugly, and Excel's Object Model is elegant. 

Norm Berg and John Froehlich will give us an update about how the spelunker flashlight detection project is going.

Detailed Schedule:
  5:30 Networking, wireless login
  6:00 Announcements
Attendee Info Sharing (industry news, jobs offered or needed, educational opportunities, etc.)
Introductions
    Technical Questions and Problems from Attendees are Invited
  6:15 Major presentation (see above)
Demonstrations
Attendees assist attendees with technical questions
  9:30 Raffle/Prizes (if any)
9:45 End
  Wireless Access
    Username and password for internet access will be supplied at the meetings.  There is no longer any need to apply for internet access in advance.