Date: Mon, 16 Dec 2002 12:12:43 -0800 From: info@bostonaccessday.com Subject: Access Day - Wed 12/18/02 This is a reminder that Microsoft® Access Day is this Wednesday, December 18th, 2002. 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 Using Microsoft Access 9:00 AM to 11:00 AM -- Presented by Dean Serrentino of Paradigm Information Systems, Inc (d.serrentino@ai-host.net) If you've just opened the box, then this session is for you. You will learn how to get started building powerful database applications with data you already have in some other format (such as a spreadsheet). See how to quickly and easily build Access forms and reports using built in Wizards. We will develop our first application in just two hours. ***************************************************************** Introduction To Table Design 11:15 AM to 12:00 PM -- Presented by Dean Serrentino of Paradigm Information Systems, Inc (d.serrentino@ai-host.net) Learn how to build Access tables. We will start by importing existing data in another format (such as an Excel spreadsheet) and converting the structure into a more efficient database design. We will also review use of the built-in database Table Analyzer. ***************************************************************** Introduction To Programming In VBA Part III - The Building Blocks of Code 1:00 PM to 3:00 PM -- Presented by Dean Serrentino of Paradigm Information Systems, Inc (d.serrentino@ai-host.net) We continue our four-part series on Visual Basic for Applications (VBA) in Access. After a short review of Part II we will discuss variables, basic control structures, conditional statements and program flow. Building on last month's presentation, we will look at referencing and manipulating form objects in code. ***************************************************************** The Horror Show--A Case Study of Self-Destructive Developer Behavior 3:15 PM to 4:15 PM -- Presented by John Giuliano of Stone-Crowne Associates (jgiuliano@stone-crowne.com) Why make all the mistakes yourself? Each month we will look at examples of applications that had flawed aspects in their development. We are all better off learning from the mistakes of others. The audience will participate in identifying the things that have gone terribly awry. ***************************************************************** The Trauma Center 4:30 PM to 5:30 PM -- Presented by John Giuliano of Stone-Crowne Associates (jgiuliano@stone-crowne.com) We spend the hour helping to debug, add enhancements, or make design recommendations. The audience is invited to bring in real world developer problems that need solving now. Bring your applications on floppy, CD, or Zip Disk. ***************************************************************** Developer Level Meeting --General Announcements 6:30 PM to 6:45 PM -- Hosted by John Giuliano of Stone-Crowne Associates (jgiuliano@stone-crowne.com) During this part of the meeting we share information regarding upcoming events, Access bugs, add on products, and anything else that affects the world of the Access developer. ***************************************************************** Introduction To Access Security 6:45 PM to 7:45 PM --Presented by Holger Zwickau of Zwickau Database Solutions (holger@zdbs.com) We examine User-Level security in Access. Covered will be: creating a workgroup file, user accounts, passwords, permissions (by users and groups) for database objects (tables, queries, etc..), common security pitfalls (such as the built-in "Admin" account), and field level permissions. Informative for beginners and developers. ***************************************************************** Introduction To Using Active Server Pages With Access -- Part Four 7:45 PM to 8:45 PM -- Presented by John Giuliano of Stone-Crowne Associates (jgiuliano@stone-crowne.com) We continue our series on Active Server Pages (ASP) with a look at using ActiveX Data Objects (ADO) to interact with Access and SQL Server databases. This month we look at working with session information. We will discuss the pros and cons of using session variables and storing session data in a database.