About Us: CAUG is an independent group of software developers and users of Microsoft Access and related products. Our mission is to meet and share information, techniques, and ideas, the fourth Thursday of each month. Visitors are welcome! Come check us out.


Membership: Membership is absolutely free and mostly consists of being on the CAUG email distribution list. Member experience varies from seasoned pros to Microsoft Access newcomers. CAUG can't be everything to everyone and we don't even try. If you like, simply attend meetings that interest you and skip those that do not.


Location: CAUG is hosted by the New Horizons Computer Learning Centers in Chicago.

New Horizons is located at:
200 West Monroe
Suite 900
Chicago, IL 60606


Phone: (312)-222-9400


Our Next Meeting: THURSDAY, March 27th, 2014, 6 p.m.


Topic: Hospital Call Center database


Mary Sue will give a presentation concerning a Call Center database for one hospital that has:
  • 22,000 calls per year
  • 30,000 referrals per year (classes, physicians, services) in call center and on website
  • 4,000 credit card charges per year

 

  1. Preparing daily letters to callers detailing their referrals of physicians, classes, and services, but specifically embedding Word documents in the letters to show detailed directions of varying length, including colored maps, for all applicable locations of their classes.
  2. Alternately preparing emails to the callers instead of, or in addition to, #1 above, again with all details in the email.
  3. Importing class registrations from their website, to the office database which contains the call center registrations made. This entails updating the web and office databases with current class registrations so that classes do not exceed their maximum attendees.
  4. Reporting on the calls (# of physicians referred, # classes registered, etc.), web registrations, letters mailed, emails sent per month for billing purposes.


About Our Speaker: Mary Sue Honigschmidt
Mary Sue has her own database development company, RED, and coordinates the Chicago Computer Society's Access Developers West SIG.


To Attend: For more information or to RSVP, please email us at info@caug.com. Because of building security, you must RSVP to attend. RSVPs must be received by noon on the day before the meeting. It's also important to know you're coming so we can have an accurate head count for ordering food.


Get Connected: To receive regular email announcements for CAUG meetings: Click Here.

You can also connect with CAUG on LinkedIn and FaceBook.

CAUG enjoys membership in GITCA.


For a fee CAUG members may be listed on our CAUG Partner and/or Consultant web pages.