From: The Boston Access User's Group Subject: Access Day - Wednesday 1/18/06 Date: Friday, January 13, 2006 12:55:07 This is a reminder that Microsoft Access Day is this Wednesday 1/18/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 ***************************************************************** Intro. To VBA, Part 4 of 5 - The Access Object Model -- 1:00 PM - 4:00 PM Presented by: Dean Serrentino of Paradigm Information Systems, Inc. In this session, Dean will delve into the idiosyncrasies of referencing Access objects from within VBA code. Learn how to get and set values from a form, and control program flow based on user input. A laptop computer (not supplied) is needed to participate, but all are welcome to attend. ***************************************************************** Access Trauma Center -- 4: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. ***************************************************************** Working With Files In Access Applications -- 6:30 PM - 7:30 PM Presented by: John Giuliano of Stone-Crowne Associates Most of us are in the habit of building our applications with only one or two files (the application and data files). But often, circumstances require the use of additional files. In this session we will look at built-in functions for manipulating files as well as the different types of files that we may need to include with our application. We will examine using additional *.mdb, library, Excel, Word, *.txt and other file types. ***************************************************************** Temporary Databases: Why Use Them? -- 7:30 PM - 8:30 PM Presented by: John Giuliano of Stone-Crowne Associates As developers, we often need to cache our data in temporary tables. We might do this to simplify the gathering of data in a different structure for use in queries and reports. This often leads to the unnecessary bloating of our application or data files. That, in turn may require more maintenance (i.e. compacting the database regularly). By using an external database file for temporary objects, we can avoid the above mentioned issues. In this presentation we will look at creating self-maint