From: The Boston Access User's Group Subject: Access Day - Wednesday 9/20/06 Date: Wednesday, September 13, 2006 20:13:48 This is a reminder that Microsoft Access Day is this Wednesday 9/20/06. 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/ Here is the Agenda for Access Day: INTRODUCTION TO ACCESS ***************************************************************** Introduction To Table Design -- 9:30 AM - 12:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. Learn the basics of designing and building Access tables. Dean explains how to leverage the power of the relational database model, while illustrating the importance of a solid design. He'll explain the different types of table relationships, and the role of each. Lastly, the table analyzer wizard will be demonstrated by splitting data from a single Excel spreadsheet into multiple Access tables. INTERMEDIATE ACCESS ***************************************************************** Creating an Audit Trail in Access -- 1:00 PM - 3:00 PM Presented by: Sara Adelizzi of Building #19 Inc. Out of the box, Access cannot log changes to your data at the record level. Sara demonstrates a solution borrowed from Australian developer Allen Browne, which she uses in her applications for logging inserts, deletions, and edits. The code is easy to implement, supports a multi-user environment, and can be called from different forms open at the same time. ***************************************************************** 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 ***************************************************************** Introduction To SQL Server -- 5:00 PM - 6:00 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: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. ***************************************************************** Introduction to ASP.Net 2.0 (continued) -- 6:30 PM - 7:30 PM Presented by: Russell Ganz Since Russ only got through a fraction of his presentation in May, he's returning to enlighten us further about this sensational product. ASP.Net 2.0 offers tremendous enhancements in functionality and ease of use. Russ will continue his overview of developing data driven web applications using ASP.Net 2.0 with the Visual Web Developer 2005 Express Edition. The Express Edition is a free product that is remarkably feature rich. ***************************************************************** Sand and Gravel -- 7:30 PM - 8:30 PM Presented by: Ed Craddock of C&L Assoc Ed takes us on an interactive tour of his Sand and Gravel business application. The system handles quotes, orders, scale entry for billing, collection of delivery tickets for billing, multi level pricing for product and delivery, delivery scheduling and comprehensive delivery status. 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