From: "Donna Rae" Subject: Access Day - 3/20/02 Date: Monday, March 18, 2002 4:03 PM Hello Everyone, March's meeting of "MS ACCESS DAY" is scheduled for this Wednesday, March 20, 2002 at ***MICROSOFT'S NEW OFFICE LOCATION, 201 JONES ROAD IN WALTHAM, MA.*** To get directions to their new location, please visit http://www.microsoft.com/usa/offices/waltham.asp. Here are the session details and topics that will be discussed at next week's meeting. All events are free and do not require pre-registration. Seating is based on a first come basis... so it pays to be early! Next month's Access Day is scheduled for Wednesday, April 17, 2002. Please mark your calendars. We are in search of User Tips! If you have a USER TIP you would like to share please send it to me at the following address: donnaR@lunasystems.com and who knows it may just show up on a future announcement! *****We are also in search of speakers for the evening sessions of Access Day. If you are interested please do not hesitate to send me an email at donnar@lunasystems.com or to speak to John or Dean. They would be more than happy to help you prepare for your talk. P.S. We really need some help here, so please feel free to try out your presentation skills during a future evening session!***** The agenda for this week's "ACCESS DAY" is as follows: ************************************ INTRODUCTION TO ACCESS 9:30 AM to 12:00 NOON ************************************ "INTRODUCING THE BEGINNING USER TO ACCESS", "Building Forms" Part III of a multi-part series. Presented by: Dean Serrentino, Advantage Internet Services, (d.serrentino@ai-host.net) In part III of this series Dean will show how forms provide a visual interface for your users, while protecting the integrity of the data they enter. Learn how to quickly build effective forms. The benefits and drawbacks of using particular controls will be discussed. Dean will explore the properties of forms and controls, and will build several forms to handle common situations. ************************************** MICROSOFT ACCESS 1:00 PM to 4:00 PM ************************************** "USING ACCESS DATA WITH MS WORD" Presented by: Dean Serrentino, Advantage Internet Services, (d.serrentino@ai-host.net) Dean will explain several different ways to merge data from an Access database into Word documents. Learn which techniques work best for a given situation. ***************************************** THE ACCESS TRAUMA CENTER 4:30 PM to 5:30 PM ***************************************** Presented by: John Giuliano, Stone-Crowne Associates, (jgiuliano@stone-crowne.com) Does Access depress you at times? Do you bang your head against the wall trying to get Access to do things that are common functions in other applications? Does your blood pressure rise trying to format reports to look just like the boss's old favorites? Does the mere thought of opening the code window give you anxiety attacks? We have just what the doctor ordered. -- "The Access Trauma Center" Each month from 4:30 to 5:30 we will solve (or try to solve) problems posed by the audience. The hour will be broken up into different segments: 'Triage' (5 minutes) -- Here we poll the audience for pressing and perplexing problems to solve. (Please no "nice to know" questions. Our goal will be to help the suffering victims of Access.) ***PLEASE REMEMBER TO BRING YOUR DISKS FOR TRIAGE*** 'Emergency Surgery' (45 minutes) - Here we diagnose the problems and find working solutions. We will build forms, reports, and code modules that demonstrate methods discussed. No cosmetic surgery will be performed here. Emergency surgery is not pretty. Expect ugly forms and reports. If you have a weak stomach, it may be best to retire to the waiting room. Copies of the working solutions and code will be available for any who request such. 'Is The Patient Still Breathing?' (5 minutes) - Q&A dealing with quick verbal solutions to problems that did not require on-screen demonstrations of solutions. 'Doctor, It Hurts When I Do This...' (5 minutes) - A short session on things to watch out for as you develop applications. Each month we will discuss different topics. Did we mention we are also a research facility? In the event of too few questions, a topic vital to the health and well-being of all intermediate level Access Users will be covered. ************************************ MICROSOFT ACCESS: Evening Session User Group Meeting 5:30 PM to 6:30 PM ************************************ "PRE-GAME SHOW" Bring your Access problems and questions! Bend the ear of an experienced Access developer or power user to get "real-life" answers to your "real-life" database problems! ************************************ MICROSOFT ACCESS 6:30 PM to 6:45 PM ************************************ "OPEN FORUM" Stand Up and be heard... general announcements, suggestions, etc. ************************************ MICROSOFT ACCESS 6:45 PM to 7:00 PM ************************************ "ACCESS DAY AGENDA CHANGES" We will be making some changes to the Access day schedule. We will discuss these and answer questions on how they will affect you. Comments and suggestions from the audience will also be entertained. ************************************ MICROSOFT ACCESS Main Meeting 7:00 PM to 8:30 PM ************************************ "WHERE DOES THE DATA GO?" Presented by: John Giuliano, Stone-Crowne Associates (jgiuliano@stone-crowne.com) For new and experienced developers, the issue of designing the data structure and the physical location of the data can be a monumental task. John will discuss the issues involved and the factors that the developer will take into consideration in designing a solid data storage plan. Topics discussed will include: splitting databases, linking tables, data normalization, and using two or more database files in your system design. ***************************SPECIAL REQUEST********************** Our MS Access User Group is looking for speakers to round out our schedule of presenters for MS Access Day. The audience typically ranges from beginners to advance level people. This is your chance to help the user group and get a little personal speaking experience at the same time. If you are interested please contact Dean or John. Help will be provided to both prepare and deliver the presentation if needed. Contact us at www.BostonAccessday.com. Please check the Access Day website: www.BostonAccessday.com for up to date information on all of the sessions scheduled for "ACCESS DAY" and also for any cancellations due to weather conditions and/or unforeseen circumstances. See you in Waltham, ***************************************** John Giuliano Stone-Crowne Associates 233 Bacon Street Rear Waltham, MA 02451-7501 Voice: (781) 893-5361 Fax: (781) 899-3740 Email: jgiuliano@stone-crowne.com ***************************************** All events take place at: Microsoft 201 Jones Road Waltham, MA For directions to Microsoft's new location, please visit: http://www.microsoft.com/usa/offices/waltham.asp. If you have a change of email address or wish to be removed from this mailing, please contact: Email: DonnaR@lunasystems.com Phone: 978-327-6400 ************************************************************************