Date: Mon, 13 Mar 2000 10:56:34 -0500 From: Donna Rae Subject: Access Day - 3/15/00 Hello Everyone, This Wednesday, March 15, 2000 is "MS OFFICE DAY" at Microsoft in Waltham, MA.. 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! Please note our new USER TIP feature at the end of this announcement. If you have a USER TIP you would like added to the monthly announcement 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 this Wednesday's "MS OFFICE DAY" is as follows: ************************************ MICROSOFT WORD User Group 9:30 am to 11:00 am ************************************ "Overview of MS WORD 2000 Web Features" Presented by: Arnold Bilansky: 71533.1031@compuserve.com ************************************ MICROSOFT OUTLOOK User Group 11:00 am to12:30 pm ************************************ "Overview of MS OUTLOOK 2000 Web Features" Presented by: Arnold Bilansky: 71533.1031@compuserve.com ************************************ MICROSOFT FRONTPAGE User Group 1:00 pm to 2:30 pm ************************************ "FrontPage 101" Presented by: Tom Lee, Jr., E-mail: FPUGChair@usdatacenters.com, http://www.webss.com/frontpageboston An encore of last month's presentation will again focus on getting started and examine the relationship of Tables and Cells to controlling web page layout and design. Time permitting we will also show the use of "Include" pages. ************************************ MICROSOFT ACCESS User Group 2:30 pm to 4:00 pm ************************************ "Power Queries" Presented by: Pat Tormey, P.E., Foursquare Solutions, Inc., (tormey@foursquare.com) ***************************************** 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.) 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 User Group 6:00 pm to 8:30 pm ************************************ "Microsoft Data Engine" Will discuss deploying applications using Microsoft Data Engine. Presented by: Pat Tormey, P.E., Foursquare Solutions, Inc., (tormey@foursquare.com), Rick Lunetta of Luna Systems Corporation, Andover, MA (RickL@lunasystems.com), and Kermit Hooks of Luna Systems Corporation, Andover, MA (KermitH@lunasystems.com) The above sessions are subject to change. ********************************************************** * * * * * * MARCH USER TIP * * * * * * ********************************************************** "VB and Access Tip" sent to us by: Pat Tormey PE, Tormey@Foursquare.com, www.Foursquare.com You can use static variables to 'remember' a value until it's set the next time.. No need for those messy Global variables anymore. You can use it for a flexible filter in an Access Query! Function Remember(Optional What) As String Static sRemember As String 'Static holds the value If Not IsMissing(What) Then 'IsMissing only works for Non-Typed parameters sRemember = What 'If What was a string, look for an empty string End If 'Is missing Remember = sRemember End Function Pat *********************************** ****************SPECIAL REQUEST********************** Our MS Office Day event is looking for speakers from our user groups to round out our schedule of presenters for any and all tools in the MS Office Suite. The audience is typically beginners with some intermediate level people. The speaker will need to be available during the day on the third Wednesday of each month at Microsoft in Waltham for a 1 1/2 hour presentation. This is your chance to help our 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 lisah@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 **************************************************************************** **************************************** **************************************************************************** **************************************** Attention Microsoft User Group Members, Microsoft and its partners cordially invites you and your members to upgrade your I/T job and earn a higher income. Interview & network at MICROSOFTıs Career Connections Recruitment Expo on April 5th at the Waltham Westin, 4pm­8pm, admission is free! For Travel Directions only call 781-290-5600. Meet hiring managers from Microsoft and over 50 of its top Partners & Solution Providers. Also don't miss the opportunity to hear from industry experts, including Steve Carbone - Technology Specialist who will be speaking on the features of Windows 2000. Bring many resumes. For experienced professionals only: Microsoft Certified Professionals, SW Developers, DBAs, DB Architects, Pre & Post Sales Engineers, Project Mgrs..., Network/SW & HW Engineers, Consultants, Programmers, Database & Multimedia Specialists, E-Commerce Specialists & Strategists, Messaging Experts & much more...Candidates interested in attending can get more info, search jobs and pre-register by visiting: www.MSExpo.com. If you can't attend, please upload your resume on to the site www.MSExpo.com and visit the virtual career fair. If your company is interested in exhibiting & recruiting in this special hiring event call 212.655.4505 ext 225. Partial list of companies include: Microsoft Microsoft Computer Sciences Corporation MasterWorks Boston University CareTools Sensormatic Electronics Servicesoft Technologies Getronics Marathon Technologies Corporation Competitive Computing The Taylor Group Micro Modeling Associates Integrated Information Systems Lilly Software Associates, Inc. IDX Systems Corp Metratech Corp. DASH.com NetGuru Systems, Inc. Internosis E-Solutions Integrator, Inc. Whittman-Hart, Inc. BISYS Networking Stream International Primeon, Inc. Instinctive Technology, Inc. Sullivan & Cogliano Navisite Applied PC Creative Data Technical Staffing Solutions Please feel free to forward this message on to other experienced I/T professionals Warm regards, Microsoft and the TECHEXPO Teams