From: The Boston Access User's Group Subject: Access Day - Wednesday 8/20/08 Date: Friday, August 15, 2008 2:04:40 PM This is a reminder that Microsoft Access Day is this Wednesday 8/20/08. 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: BEGINNER ***************************************************************** Introduction to Access -- 1:00 PM - 2:30 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. BEGINNER/INTERMEDIATE ***************************************************************** Queries For Fun And Profit -- 2:30 PM - 4:00 PM Presented by: John Giuliano of Stone-Crowne Associates Access has a very powerful query engine. Querying skills enable the user (or developer) to extract information (as opposed to data) in a meaningful form. In this session we will learn about the query tool provided by Access, how to group and sum your data, use expressions and built-in functions in your query, combine fields to achieve different results. We will also consider the various places in Access where queries are used. INTERMEDIATE ***************************************************************** Access Trauma Center -- 4:00 PM - 5:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. 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: Dean Serrentino of Paradigm Information Systems, Inc. Share information regarding upcoming events, Access bugs, add-on products, and anything else that affects the world of the Access developer. ***************************************************************** Using SQL Server Stored Procedures from Access -- 6:30 PM - 7:30 PM Presented by: Teresa DeLuca of The Fay School Access can easily handle generating a report using linked tables from a SQL Server database. But when the report contains large amounts of data, it can be painful waiting for it to display. Teresa will demonstrate how to get started creating SQL Server stored procedures to speed up accessing large amounts of data, advantages for using stored procedures, how to supply parameters, and how to code a report to call a stored procedure. ***************************************************************** Working with SQL Server UDFs in Access -- 7:30 PM - 8:30 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. SQL Server User Defined Functions (UDFs) can be a handy way to pull data into Access for reports and other uses. Dean explains the creation of table-value UDFs, calling them, and using the data they return from within Access. 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