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

Beginning Presentation:
Title: Discussion of primary keys, surrogate keys, business keys
Presenter: Janet Gelsinger

Description:
Access User Group presentation is database design and identifying good primary keys for tables.
During the discussion, we will look at examples and explore questions like:

What are some best practices for primary keys?
Should I use the “business key” that makes the data unique or should I use “surrogate keys”?
What are the pros and cons?
Is it preferable to be consistent when enhancing an existing database or implement different standard practices that you think are better?

Janet Gelsinger has participated in the Heartland Access User Group since about 1996 and works at Hallmark Cards as a Data Analyst for the www.Hallmark.com website. Janet’s IT career began with computer software support and progressed to a primary focus on data as both a DBA and Data Analyst, working on database administration, development and design on Access, Oracle, Teradata and most recently, SQL Server.

Advanced Presentation:
Title: Total Queries - What are they and why do I care…
Presenter: Jim Watkins, Jr.

Description:
SELECT queries are the bread and butter of any database, however the power of a database shines when you produce summation queries. Summation queries allow users to analyze their data and adds real value to the database. Come join us to learn some basics and some tricks to use in Total queries.

Jim Watkins is a senior developer for Heritage Computer Consulting & Services, Inc. HCCS is a 22 year old Computer Consulting firm located in Overland Park, Kansas specializing in providing custom solutions to real world challenges for their clients.

Drawing:
Microsoft Access 2013 for Dummies You need Access. You need it to organize your data, produce reports that make you look like a genius, create forms that enable your staff to enter and manage more data, and find the significant drop of data you're looking for in that huge pool of information. This book is the key that unlocks the Access magic - read on, and access the power!

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