From: The Boston Access User's Group Subject: Access Day - Wednesday 7/20/05 Date: Thu, 14 Jul 2005 19:41:13 +0000 This is a reminder that Microsoft Access Day is this Wednesday 7/20/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/ 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 ***************************************************************** Dynamic SQL -- 1:00 PM - 3:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. Dean demonstrates the use of Visual Basic for Applications (VBA) code to create queries that can change dynamically. Learn how you can incorporate this functionality into your own applications to create flexible and powerful user forms. ***************************************************************** Access Trauma Center -- 3:00 PM - 6: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 ***************************************************************** 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. ***************************************************************** Tips, Tricks And Good Habits For Coding In Access -- 6:30 PM - 7:30 PM Presented by: John Giuliano of Stone-Crowne Associates This session will cover various way of making your code bug free, readable, efficient and simple. John will also look at a few traps that you do not want to fall into. ***************************************************************** Error Handling Basics -- 7:30 PM - 8:30 PM Presented by: John Giuliano of Stone-Crowne Associates Too many of us use the default error handling used in Access Wizards to let the user see a message box telling them that something went wrong. Very often this message is useless to the user (and very often also to the developer). In this presentation we will consider a number of ways of using Access error handling capabilities to notify users, roll back processes, make branching decisions, and log errors. Next Month's Topics... Introduction To Access 9:30 AM - 12:00 PM To be announced... 1:00 PM - 3:00 PM Access Trauma Center 3: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