From: The Boston Access User's Group Subject: Access Day - Wednesday 6/15/05 (revised) Date: Mon, 13 Jun 2005 19:20:28 +0000 This is a reminder that Microsoft Access Day is this Wednesday 6/15/05. 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/ ***************************************************************** SCHEDULE CHANGE... Please note that our speakers and topics for the evening developer's meeting have changed. See details below... ***************************************************************** Here is the Agenda for Access Day: INTRODUCTION TO ACCESS ***************************************************************** Introduction To Access -- 9:30 AM - 12:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. Get started building powerful database applications. See how to quickly and easily build Access forms and reports using built-in Wizards. We'll develop a comprehensive contact management application in just two and a half hours. INTERMEDIATE ACCESS ***************************************************************** Working with external data -- 1:00 PM - 3:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. Dean will explore various techniques for working with data from external sources such as Excel, text files, SQL Server, and other Access databases. ***************************************************************** Access Trauma Center -- 3:00 PM - 5:00 PM Presented by: John Giuliano of Stone-Crowne Associates We'll spend two hours 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 floppy, CD, or Zip Disk. ACCESS DEVELOPER ***************************************************************** Access Add-in Development Project Roundtable -- 5:00 PM - 6:00 PM Presented by: Rick Lunetta of Luna Systems Interested members of the group collaborate on the development of an Access 2000/2002 add-in. Input from all professional developers in the group is welcome. ***************************************************************** General Announcements and Forum -- 6:00 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. ***************************************************************** Data Modeling -- 6:30 PM - 7:00 PM Presented by: Mahendra Bakshi What is Data Modeling and what is its role in the System Development Life Cycle (SDLC)? As part of this discussion, John Zachman's Information Systems Architecture (ISA) Framework perspective will be briefly discussed. Traditionally developers are more familiar with models which represent how processing functions are structured and how they relate. However, there is an additional dimension - the data model, which is often overlooked even though it is the foundation upon which a database is built! Mahendra will not only describe what data modeling is, he will also discuss the components, types, characteristics and benefits. ***************************************************************** Manipulating SQL Strings For Fun And Profit -- 7:00 PM - 8:30 PM Presented by: John Giuliano of Stone-Crowne Associates After a short primer on using SQL (Structured Query Language), John will discuss techniques for displaying data in forms and reports by modifying the Recordsource property (in forms and reports) and the Rowsource property (in controls) using Visual Basic. He will show how to filter and sort records by multiple criteria and fields in a continuous form. Next Month's Topics... Introduction To Table Design 9:30 AM - 12:00 PM To be announced... 1:00 PM - 3:00 PM Access Trauma Center 3:00 PM - 5:00 PM Access Add-in Development Project Roundtable 5:00 PM - 6:00 PM General Announcements and Forum 6:00 PM - 6:30 PM To be announced... 6:30 PM - 7:30 PM To be announced... 7:30 PM - 8:30 PM News and Announcements... The start time for Access Day has been changed indefinitely from 9:00 AM to 9:30 AM. Russ Ganz's presentation on security from last month has been posted to the web site, and can be downloaded at http://bostonaccessday.com/downld/AccessSecurity.zip The example contact management application which we build during the "Introduction to Access" morning segment has been posted to the web site, and can be downloaded at http://bostonaccessday.com/downld/ContactMgmt.zip