From: The Boston Access User's Group Subject: Access Day - Wednesday 3/21/07 Date: Thursday, March 15, 2007 05:23:24 PM This is a reminder that Microsoft Access Day is this Wednesday 3/21/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/ IMPORTANT NOTICE... *************************************** There will be NO Access presentations in the month of April due to renovations taking place at Microsoft. Access day will resume in May. *************************************** 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 ***************************************************************** Using Expressions in Forms, Reports and Queries -- 1:00 PM - 3:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. Expressions in Access serve many purposes. A couple of examples are filtering records and returning customized information for display. Dean explains how to reference various database objects in expressions, and how to create and debug expressions used in forms, reports and queries. ***************************************************************** 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. ***************************************************************** Data Mining -- 6:30 PM - 8:30 PM Presented by: Phil Denoncourt of Denoncourt & Associates Data mining is the act of deriving patterns and trend that exist in your data. SQL 2005 provides a host of different algorithms that allow you to explore your data for hidden patterns and trends. Popular uses of data mining models are used to predict future sales, target customers for marketing, examine patterns of navigation through a website, and group products that are likely to be purchased together. Phil will give an introduction to data mining concepts, an overview of the different algorithms, and how to incorporate the data mining results into your applications. Phil Denoncourt is a .NET consultant with over 20 years of software experience and has earned an impressive number of Microsoft certifications. 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