HUG Access SIG Meeting 6:30 pm, September 17, 2014, at JCCC, Regnier Center - 3rd Floor, RC 353

Presentation 1:    Building a Forms Management Database
Presenter:  Ray Killam

Description:   Ray will show the Form Center database for managing a large forms management program. This database contains more than 150 tables and multiple relationships, with complex queries and reports. Many productivity features are also built into the database. Form Center was conceived by Ray and developed by Lisa Friedrichsen and Margaret Tassin. Ray will focus on functionality requirements and Lisa will help answer any technical questions.

As President of Essociates Group, Ray is responsible for all aspects of this unique business venture. Essociates Group, Inc. provides forms training and consulting services and analysis and design services related to paper, electronic,  Internet and virtual and forms.
Prior to starting Essociates Group, Inc.  in May, 2002, Ray was Vice President eBusiness Development and Vice President Marketing for Corporate Express Document & Print management.  He managed the development of the Odyssey Integrated ServicesÒ  program, which is a comprehensive, modular collection of services designed to help companies manage their business processes.
He has more than four decades of experience in the forms industry as a practitioner and  in both sales and marketing.  Mr. Killam served IADT (International Association for Document Technologies) as Vice Chairman-International Board, and on the Board of Trustees of the IADT Foundation.  He is an active member of Business Forms Management Association (BFMA) where he served as Association President from 2007-2009, and is chairman of the Board of Trustees of the BFMA Education Foundation.


Presentation 2:   Excel vs. Access - the epic battle continues
Title:  Excel vs. Access - the epic battle continues
Presenter:  Lisa Friedrichsen

Description:  Most people are using Excel to manage lists of information. Whether it's product pricing, human resources or transaction data, Excel users spend a great deal of time managing, tracking, and analyzing data.  But is Excel always the best tool for this job?  When should you use Access?  Choosing the best tool for the information management challenge is a very common struggle.

Come to this session to learn five key questions that help determine whether Excel or Access is the right tool for the job.   We will use this methodology to analyze a typical business management problem that starts as a large list of data in Excel.  We will import the data into Access, and then split the data into related tables to experience the power and benefits of a relational database

Lisa Friedrichsen is a Professor at Johnson County Community College in Computer Sciences & Information Technology.  She is also an author of multiple Excel and Access textbooks.


Drawing:
One $10 Gift Certificates from Amazon.   Sponsored by: Heartland User's Group
Book: Microsoft Access 2013 Brief by Lisa Friedrichsen
Learn the essentials of using Microsoft Access 2013.

Sponsored by: Heritage Computer Consulting & Services, Inc.
Give-away drawing for HUG members only.

Upcoming Meetings:  October 15, 2014 – RC 374; November 19 -  RC 355