From: The Boston Access User's Group Subject: Access Day - Wednesday 10/17/07 Date: Thursday, October 11, 2007 5:04:12 PM This is a reminder that Microsoft Access Day is this Wednesday 10/17/07. Location: Microsoft Corporation, 201 Jones Road, Waltham, MA 02451 (781) 487-6400 For directions and Map: http://www.microsoft.com/mscorp/info/usaoffices/newengland/waltham.mspx For additional information visit the Access Day web site: http://www.BostonAccessDay.com/ REMINDER: The format for Access Day has changed. Beginning last month, there is no longer a morning session. Instead, the beginner session will be held in the afternoon. Please review the schedule below for details. Here is the Agenda for Access Day: BEGINNER ***************************************************************** Introduction to Access -- 1:00 PM - 4:00 PM Presented by: John Giuliano of Stone-Crowne Associates Get started building powerful database applications. See how to quickly and easily build Access forms and reports using built-in Wizards. Learn about helpful resources that can get you up to speed quickly. INTERMEDIATE ***************************************************************** Intro. To VBA, Part 2 of 5 - The Building-Blocks of Code -- 1:00 PM - 4:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. We continue our series on Visual Basic for Applications (VBA) in Access this month, with a discussion of the most common and useful components of VBA procedures. Dean will cover data types, variables, constants, string concatenation, and built-in Access functions. A laptop computer (not supplied) is needed to participate, but all are welcome to attend. ***************************************************************** Access Trauma Center -- 4:00 PM - 5:00 PM Presented by: John Giuliano of Stone-Crowne Associates We'll spend an hour helping to debug, add enhancements, or make design recommendations. The audience is encouraged to bring in real world developer problems that need solving now. Bring your applications on flash drive, CD, or laptop. DEVELOPER ***************************************************************** Introduction To SQL Server -- 5:00 PM - 6:15 PM Presented by: John Giuliano of Stone-Crowne Associates In this session, we will work exclusively with SQL Server 2005 and the tools that are available to manage it. The focus of this series is to enable Access developers to design client-server applications using Access as the user interface. ***************************************************************** General Announcements and Forum -- 6:15 PM - 6:30 PM Presented by: John Giuliano of Stone-Crowne Associates Share information regarding upcoming events, Access bugs, add-on products, and anything else that affects the world of the Access developer. ***************************************************************** Access in the Mutual Fund Industry -- 6:30 PM - 7:30 PM Presented by: Steve Simon of State Street Corporation The usage of Microsoft Access 2003 within the financial world has been on a steady upswing over the past few years. No where is this more true than in the Mutual Fund Industry. This hands-on presentation will show the attendee how we have utilized Access 2003 with VBA and Visual Studio .NET to create an efficient and effective financial decision support system with a minimal amount of effort and time. Steve's presentation explores the use and limitations of some of the Access Controls and also offers workarounds to overcome these limitations. He will also show the attendee how to rapidly establish an "event driven load facility" utilizing the .NET 'FileSystemWatcher' class and a SQL Server Integration Services Package. ***************************************************************** Data Driven Executive Dashboard -- 7:30 PM - 8:30 PM Presented by: Bruce Holmes Bruce's application is a data-driven Executive Dashboard written entirely in Access. It provides a business manager with a summary display of the key performance indicators of his operation, how each measurement compares to its established goal, and what the trend is. Bruce shows us how the selection and appearance of parameters that get displayed are controlled by the database and generated at run-time. News and Announcements... If you are interested in making a presentation at an Access Developer's meeting, please contact our Event Coordinator Teresa DeLuca via the Boston Access Day web site at