Date: Tue, 20 Apr 2004 06:42:45 +0100 (BST) From: The Boston Access User's Group Subject: Access Day - Wednesday 4/21/04 This is a reminder that Microsoft Access Day is this Wednesday 4/21/04. Location: Microsoft Corporation, 201 Jones Road, Waltham, MA 02451 (781) 487-6400 For directions and Map: http://www.microsoft.com/usa/offices/waltham.asp For additional information visit the Access Day web site: http://www.BostonAccessDay.com/ Here is the Agenda for Access Day: INTRODUCTION TO ACCESS ***************************************************************** Table Analyzer Wizard -- 9:00 AM - 10:00 AM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. d.serrentino@paradigminc.us Learn how to import data from a non-Access format, such as an Excel spreadsheet, and convert it into multiple Access tables using the wizard. This is an important step when using existing data in a new application. A sound knowledge of the wizard's capabilities can greatly simplify this task. ***************************************************************** Introduction To Access -- 10:00 AM - 12:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. d.serrentino@paradigminc.us 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 hours. INTERMEDIATE ACCESS ***************************************************************** Introduction To VBA Part I - The Development Environment -- 1:00 PM - 3:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. d.serrentino@paradigminc.us Only the most modest of Access applications can be developed without the use of any code. Dean begins a four-part series on Visual Basic for Applications (VBA) programming in Access. These sessions are designed as a fast-track for the novice Access user. The focus will be on practical information and usage. This month Dean will discuss events, code procedures, code modules, and the VBA Integrated Development Environment (IDE). ***************************************************************** Access Trauma Center -- 3:00 PM - 5:00 PM Presented by: John Giuliano of Stone-Crowne Associates jgiuliano@stone-crowne.com 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 rickl@lunasystems.com 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 jgiuliano@stone-crowne.com Share information regarding upcoming events, Access bugs, add-on products, and anything else that affects the world of the Access developer. ***************************************************************** Is Access Up To The Task? (postponed from last month) -- 6:30 PM - 7:30 PM Presented by: John Giuliano of Stone-Crowne Associates jgiuliano@stone-crowne.com When beginning a new project, a number of factors need to be considered. Issues such as the amount of data, number of users, network environment, growth of your client's business and many more factors need to be considered. Understanding what these issues are and how to deal with them will determine the degree of success of the project. During this presentation, we will look at how the developer can create his or her own formulas to plan for a positive development experience. ***************************************************************** Dynamically Bind Data To A Combo Box Or List Box -- 7:30 PM - 8:30 PM Presented by: Rick Lunetta of Luna Systems rickl@lunasystems.com Microsoft Access presents three options for binding data to a Combo or List Box: A Table or Query; a Field List; or a Value List. There is however, another less obvious, but more powerful option... The User Defined Function. A User Defined Function is a special type of code procedure, which can be used to populate Combo and List Boxes. This technique allows the developer to populate a Combo/List Box with data from many different data sources, while still achieving very good performance with large data sets. Next Month's Topics... Introduction To Table Design 9:00 AM - 10:00 AM Introduction To Access 10:00 AM - 12:00 PM Introduction To VBA Part II - Working With Access Objects 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 Outputting Formatted Data Without Using Access Reports 6:30 PM - 7:30 PM Working With Large Recordsets 7:30 PM - 8:30 PM -----------------------------------------------------------------------