From: "Donna Rae" Subject: Access Day - 1/16/02 Date: Thursday, January 10, 2002 4:21 PM ***SPECIAL ANNOUNCEMENT: MICROSOFT'S NEW LOCATION IN WALTHAM AT 201 JONES ROAD. SEE BELOW FOR ADDITIONAL DETAILS*** Hello Everyone and Happy New Year! Our next session of "MS ACCESS DAY" is scheduled for Wednesday, January 16, 2002 at ***MICROSOFT'S NEW OFFICE LOCATION, 201 JONES ROAD IN WALTHAM, MA.*** To view a map of their new location, please visit: www.expedia.com and plug in the new address! 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, February 20, 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 Pat, Phil, Rick, 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 next week's "ACCESS DAY" is as follows: ************************************ INTRODUCTION TO ACCESS 9:30 am to 12:00 noon ************************************ "INTRODUCING THE BEGINNING USER TO ACCESS", Part 1 of a multi-part series. Presented by: Dean Serrentino, (d.serrentino@ai-host.net) In part 1 Dean will present a brief overview of Access, followed by the basics of table design. ************************************** MICROSOFT ACCESS 1:00 pm to 4:00 pm ************************************** "TABLE DESIGN A TO Z", Presented by: Dean Serrentino, (d.serrentino@ai-host.net) Table design is the first, and most critical step, in the design of any application. An application with poor table structure is doomed to fail before development completes. In this session, Dean will cover the do's, don'ts and how to's of table design; and the underlying principles of data normalization. ***************************************** 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 7:00 PM ************************************ "OPEN FORUM" Stand Up and be heard... general announcements, suggestions, etc. ************************************ MICROSOFT ACCESS Main Meeting 7:00 PM to 8:30 PM ************************************ "WRITE YOUR OWN DEVELOPER TOOLS" Presented by: John Giuliano, Stone-Crowne Associates, (jgiuliano@stone-crowne.com) As developers we are often called upon to write applications for our clients to automate repetitive and tedious tasks. But are we so busy trying to get the job done that we fail to see how the same techniques can make us more productive? John will discuss how to determine when a developer task should be automated and how to go about doing it. Emphasis will be on creating quick and dirty little tools and creation of reusable code procedures that do not hinder productivity on the current project. Demonstrated will be a number of tasks that have been automated. Among them are a simple table generation method, and methods to perform mass changes to form and report properties. **************************************************************************** ***********************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. The speaker will need to be available in the evening on the date they are speaking at Microsoft in Waltham for a presentation. 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 Donna Rae at Luna Systems, DonnaR@lunasystems.com, and let her know when you are available and what subject you would like to cover. Pat, Phil, Rick and John will be available to help you prepare for the session. Please check Luna Systems website: www.lunasystems.com for up to date information on all of the sessions scheduled for "MS ACCESS DAY" and also for any cancellations due to weather conditions and/or unforeseen circumstances. Happy New Year to all! See you in Waltham, Donna Rae Luna Systems Corporation 1000 Osgood Street No. Andover, MA 01845 DonnaR@lunasystems.com www.lunasystems.com All events take place at: Microsoft 201 Jones Road Waltham, MA For directions and to view a map of Microsoft's new location, please visit: www.expedia.com and plug in the new address! If you have a change of email address or wish to be removed from this mailing, please contact me: Email: DonnaR@lunasystems.com Phone: 978-327-6400 ****************************************************************************