HUG Access SIG Meeting 6:30 pm, September 18, 2013, at
JCCC, Regnier Center - 3rd Floor, RC 353
Beginning Presentation:
Title: Lookup Wizard 101
Presenter: Lisa Friedrichsen
Description: In this session we'll examine the Lookup
Wizard to see how it provides a drop-down list of values for a field. We'll
examine all of the Lookup Wizard options to see how they modify corresponding
field Lookup properties. We'll also examine how the Lookup Wizard can be used
to create a one-to-many relationship between two tables with referential
integrity.
Lisa is a JCCC Professor in the Computer Sciences
department and also an Access textbook author. She thinks it is fun to
"break down" confusing features in Access (such as the Lookup Wizard)
so that they make better sense.
Advanced Presentation:
Title: VB code to handle importing CSV files into Access.
Presenter: Janet Geisinger
Description: If you have an ongoing need to import CSV
files into Access tables, Visual Basic code can be used to automate the
process. This presentation will explain the process and the VB code used.
Janet Gelsinger has worked at Hallmark Cards for 22
years, currently as a Data Analyst in Hallmark Digital, designing the databases
for new Hallmark.com projects. For nine years prior to this recent job change,
Janet was a Teradata DBA working on Hallmark’s Enterprise Data Warehouse.
Drawing:
Access 2013 on Demand by Steve Johnson, Perspection, Inc.
Need answers quickly? Access 2013 on Demand provides those answers in a visual
step-by-step format. We will show you exactly what to do through lots of full
color illustrations and easy-to-follow instructions.
Give-away drawing for HUG members only. Sponsored by:
Heritage Computer Consulting & Services, Inc.
Read more...