From: "Donna Rae" Subject: Access Day - 11/15/00 Date: Wednesday, November 08, 2000 4:15 PM Hello Everyone, Next Wednesday, November 15, 2000 is "MS ACCESS DAY" at Microsoft in Waltham, MA. We have changed our format to a full day of Access presentations. Here are the session details and topics that will be discussed. All events are free and do not require pre-registration. Seating is based on a first come basis... so it pays to be early! Door prizes will be available! Pizza will be sent in at 5:30. Our next ACCESS DAY is scheduled for Wednesday, December 20, 2000, 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! The agenda for next week's "ACCESS DAY" is as follows: ************************************ INTRODUCTION TO ACCESS 9:30 am to 12:00 noon ************************************ "INTRODUCTING THE BEGINNING USER TO ACCESS", "Creating Queries to Join, Update and Delete Information" Part II of a multi-part series. Presented by: Dean Serrentino, (d.serrentino@ai-host.net) In part 2 Dean will explore the uses for different query types. He will also be discussing ways to solve common Access problems using Queries. ************************************** MICROSOFT ACCESS 1:00 pm to 4:00 pm ************************************** "INTRODUCTION TO MICROSOFT ACCESS VBA", Part III of a multi-part section. (formerly called Introduction to MS-Access Basic) Presented by: Rick Lunetta, Luna Systems Corporation, (RickL@lunasystems.com) Part III - (continuing from last month's session) If you are a Microsoft Access Power User and you want to take it to the next level or if you want to learn to write commercially viable Microsoft Access applications then you need to attend this session. Luna Systems has previously presented this course on a charge only basis and is now offering it at no charge to all who attend. ***************************************** THE ACCESS TRAUMA CENTER 4:30 pm to 5:30 pm ***************************************** Presented by: John Giuliano, Stone-Crowne Associates, (Stone-Crowne@msn.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 User Group 5:30 pm to 6:00 pm ************************************ "Pre-Game Show" ************************************ MICROSOFT ACCESS Main Meeting - Session I 6:00 pm to 7:00 pm ************************************ "DIGITAL IMAGING IN ACCESS - PART II" Presented by: Frank Butash, BEE Associates, (FrankButash@email.msn.com) This presentation will demonstrate some useful applications of digital image manipulation in ACCESS. Using a Digital Camera to record events, and a scanner to store document images, Frank will demonstrate several simple examples using ACCESS and Kodak Imaging, a software program that is included "free" with WINDOWS. ************************************ MICROSOFT ACCESS Main Meeting - Session II 7:00 pm to 8:00 pm ************************************ "INTRODUCTION TO THE CONCEPT OF UPDATE QUERIES" Presented by: Carla Langdon-Sivak, Bard Electrophysiology, (carla.langdon-sivak@crbard.com) Design your application in steps. Running update queries over and over. Initialization steps must be included. Calling update queries in the background (from code). One button does it all. Carla will be presenting an application she developed to calculate costs per project, taking the time spent by engineers on various projects and converting the hours into expenses, totaling these into a report. Call for the report, and a cascade of update queries are called in the background, including totals and averages supporting the report. All the user sees is the finished report. ********************************************************** * * * * * * USER TIP * * * * * * ********************************************************** We are in search of User Tips to add to the monthly meeting announcement. If you have something of interest and would like to share it....please email your user tip to DonnaR@lunasystems.com. **************************************************************************** ********************************** **************************************************************************** *********************************** ***************************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 OFFICE DAY" and also for any cancellations due to weather conditions and/or unforeseen circumstances. See you in Waltham, Donna Rae Luna Systems Corporation 2 Dundee Park, Suite 103 Andover, MA 01810-3725 DonnaR@lunasystems.com www.lunasystems.com All events take place at: Microsoft 230 Third Avenue Waltham, MA For directions: www.microsoft.com/newengland/waltham.htm 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-749-9600 **************************************************************************** **************************************** **************************************************************************** ****************************************