|
 
| |
Welcome to Seattle Access
A Forum for Microsoft Access Users and Developers
www.SeattleAccess.org
Your source for meeting information,
newsletters and presentation content for
the Seattle
Access Group (meeting
info)
and the
Pacific Northwest Access Developer Group
(meeting info)
|
Items For Immediate Attention
SAG July 13th
Beginner’s Corner
- Recursive
Table Links by Julie Corneliuson
Recursive table talk (where the parent ID is a different
record in the same table) is a common design scenario; you’ll find
it in applications for parts and assemblies, for students with
classes and teachers; and within organizations.
Main Presentation -
“How Access Is Being Used” Study results -- by Kevin Davis,
Microsoft
It’s always good to know how others are using Access -
whether it’s to discover creative applications, to learn about the
benefits of new features, or to see where we might expand our
professional niche.
PNWADG
July 20th
Query By Form - Custom Search Form by Tom Wickerath, Access MVP
This QBF form [aka an index or search form] allows users to quickly
find records, and then select and open one for editing. In addition,
Tom’s form also allows users to print custom reports and/or dump
selected records to Excel. A new enhancement provides users with
the ability to Flag records, to help draw attention to them in a
report, and also the ability to Exclude records from a report --
even while the records remain within the selection criteria.
+
s
+
s
+
s
+
Office 2010 ---
DYK
Find and SHARE interesting factoids and insights about Office
2010 by visiting the official Did You Know site ......
Join in the
excitement and hype by connecting through
Facebook.
* Share a tip at the
meetings & Earn INSTANT REWARDS *
Volunteer to
do a launch presentation for the user groups!
(contact
Teresa for materials and ideas -- participation reaps rewards! )
+
s
+
s
+
s
+
June
Conferences - Local
and
Virtual
details at
Items of Immediate Interest
Access Application Usability Study
with the Access Team
details below
Developers Needed -- Several Opportunities; see
Job Postings Page.
Lots of new Links to
Downloads and Resources - See the Links Page.
Our Book on Database Models!
Microsoft Access Small Business Solutions,
:
State-of-the-Art Database Models for Sales, Marketing, Customer Management, and
More Key Business Activities
Written by an unparalleled team of Access MVPs-
Co Authors: Teresa Hennig, Truitt Bradly,
Larry Linson, Leigh Purvis and Brent
Spaulding
Contributors and Tech Editors: Jerry Dennison, George Hepworth and Doug
Yudovich;
Tech Editors: Arvin Meyer and Armen Stein
Arguably the most comprehensive compilation of guidance and
database models available. In addition to the printed material, the
companion CD provides 76 files, including 31 databases.
An invaluable resource for the business person -- those who know
their industry but may not have experience with Access. With this
book, they can design a custom database with confidence! The book is
also full of amazing tips that will give experienced developers an
edge, especially when expanding into new areas. Plus, the Bonus
Resource database is filled with tools and tips that can be
incorporated into your projects - and become the foundation for your
custom toolbox.
Learn how to design properly normalized database models for dozens
of business applications.
-- ORDER HERE!
Calendar Year Dues ...
Demonstrate your support and appreciation ... join
BOTH groups.
Still only $30 each and voluntary!
Since collecting dues, we've
NEVER imposed a dues increase!!!
Members only drawings, downloads, software, reviews and more.
Office 2010 Beta
Release candidate have build
build
14.0.4734.1000 or greater.
Get ready for the Final Version -- MSDN has it NOW!
Access
2010 with SharePoint
Skip
the install challenges ...
Go Directly to ... Up - Running - Live!
FREE site for testing!
www.AccessHosting.com
Database
Design Forum -
NEW GROUP on the MSDN Community Website
(Jan 2010)
info below.
|
|
Office 2010 Beta
Download the beta
find out what we can all look forward to.
Test With Your Applications
Let the Access team know what you think
Join us at the UG meetings and share
your experiences, good and bad!!
|
|
Seattle Access
Group Meeting
Newsletter
- May.
May 11th
6:15 - 6:45 Recursive Table
Links by Julie Corneliuson
Recursive table talk (where the parent ID is a different record
in the same table) is a common design scenario; you’ll find it in
applications for parts and assemblies, for students with classes and
teachers; and within organizations. The recursive table links can easily
cause confusion when creating queries or record sources. In a demonstration
that we can all relate to, Julie will show us how to create
an outline report out of a table of recursive data.
She will use a table of recursive data
(Employee table which contains the employees manager, but the manager is an
employee too and also has a manager) and create a report that shows the data
structure (i.e. Organizational Chart) in an outline format.
Julie
is an engineer at Boeing and has been working with Access for 6
years and has developed a tracking database for the production and
repair of serialized parts.
Main
Presentation - “How Access Is Being Used”
Study results presented by Kevin Davis, Microsoft
It’s always good to know
how others are using Access - whether it’s to discover creative
applications, to learn about the benefits of new features, or to see
where we might expand our professional niche. Join us this even as
Kevin shares the results of a recently commissioned study on the
ways that Access is being used.
Kevin
is a new member of the Access team, having recently switched from
his previous role on the SharePoint team. Kevin will be focusing on
user experience and customer engagement.
PRESENTERS NEEDED
-
volunteer now
|
|
Microsoft Security Essentials
(released Sept 29, 2009)
Microsoft Security Essentials provides real-time protection for your
home PC that guards against viruses, spyware, and other malicious
software. It works with Windows XP (Service Packs 2 or 3), Windows
Vista and Windows 7 which goes on sale Oct. 22.
FREE DOWNLOAD |
|
NEW Meeting Location
Cafe for Building 40
Directions:
From SR 520 Eastbound ...
Exit NE 40th, Turn RIGHT onto NE 40th, and move
into the far right lane. Turn RIGHT onto 156th NE -
heading South.
Turn RIGHT onto NE 31st.
Turn LEFT onto the access road for
Buildings 41 and 40
Turn RIGHT into the parking garage.
As you walk from the garage,
Building 40 is on the RIGHT and the Cafe is the single story
building in the middle. Walk the length of building 40, to get to
the side entrance of the cafe.
Meetings are in
the STEPTOE Room in the Cafe. The entrance is on the right
side, by building 40. The meeting room is immediately to the right.
Map of Campus area
including Building 40
Diagram of Cafe and Buildings 40
and 41
(Hot
List) |
|
Pacific
Northwest Access Developer Group
PNWADG Newsletter
- June
PNWADG - July
20th
Query By Form - Custom Search Form
by Tom Wickerath, Access MVP
This QBF form
[aka an index or search form] allows users to quickly find records,
and then select and open one for editing. In addition, Tom’s form
also allows users to print custom reports and/or dump selected
records to Excel. A new enhancement provides users with the ability
to Flag records, to help draw attention to them in a report, and
also the ability to Exclude records from a report -- even while the
records remain within the selection criteria. Tom will explain the
extra steps necessary to accommodate the requirement that the Flag
or Exclude options could not be permanently saved. The extra
efforts paid off in customer satisfaction because the client loves
it! (An earlier version of Tom’s QBF demo files is available from
the SAG downloads.)
Tom is a Microsoft Access
MVP and long time member of the PNWADG and SAG. In addition to his
main duties at Boeing, Tom also participates in the Boeing forums
providing support to database users.
6:15 - 6:45 - Q & A
Please join us
on Tuesday - and remember to bring more questions!
If you’d like to join the roster of presenters,
please send an email to
Teresa@DataDynamicsNW.com
and include a brief description of your presentation and your
bio.
Receive PNWADG Newsletters
(Hot
List) |
|
Access and SQL Server
(Return
to TOP)
Usability Studies
Special
Invitation and Priority Placement
If you are interested, send
me an email and
I will forward your info.
Share this invitation with your friends and associates.
You
AND your referrals to receive PRIORITY PLACEMENT in these and
future studies.
Send
me an email with referral names, email, phone and
Access/database experience (no database experience is also OK).
(Hot List) |
|
Share Your
Expertise
Microsoft Access Blog Power Tips
User groups are all about helping others in the
community. Microsoft has made it easy to extend your reach --- your
local talents will have a global audience on the Access blog on
MSDN! And no excuses about not knowing how to prepare your
materials, they thought too --- there’s a free toolkit to help you
out --- the Contributors Toolkit (download from MS and from the SAG
site). Check out http://blogs.msdn.com/access/ ...
Want more information about sharing your stories and tips,
contact
Chris and Mike at accpower@microsoft.com ... and be sure to tell
them that Teresa sent you ;~)
oh ... and don’t forget about
Community Clips!! Another great way to share expertise, gain
credentials and ... find great stuff ;~)
(Hot List) |
|
CONGRATULATIONS TERESA!
INETA
Community Champion
Profile & Photo
“The purpose of the INETA Community Champion Award program is to
recognize individuals with the highest levels of contributions.
Those exceptional leaders and volunteers who devote innumerable
hours towards hosting user group meetings, ...”
|
|
 Community
Credit
recognizes
Teresa Hennig
for
her commitment and contributions
to the developer community. May 2009.
More info
soon at Data
Dynamics Northwest. |
The
purpose of this site is to enhance our user group communications,
share information about Access and provide links to relevant
resources.
Access users and developers will want to stay tuned as we continue
to demonstrate how to integrate Access with .NET and other
applications.
Our meetings are welcoming forums for networking, sharing and
learning. Join us for fun, informative evenings. |
|
Items of Immediate
Interest!!
Mastering SQL Server: Performance Tuning - Virtual Conference --
June 29th 7 to Noon Pacific
(June 2010)
SQL Server performance expert,
Andrew Kelly will discuss tools and information to master three key
areas for obtaining peak performance with SQL Server: Automating and
Analyzing SQL Trace with the RML Utilities; Collecting and Analyzing
File and Wait Statistics; and Maximizing Plan Reuse. The virtual
conference will include live questions and chats.
Free registration
DevPro Connections
Virtual Conference (FREE) -- Visual Studio and Silverlight Launch
June 23 7 - 2 PDT (June 2010)
Featuring sessions and experts from Microsoft's Visual Studio and
Silverlight Launch Conference and Expo including in-depth technical
sessions, an interactive exhibition hall and opportunities for live
communication. With two tracks and eight sessions, you will learn
some of the critical factors for managing virtualization technology
from some of our favorite presenters, including Paul Litwin.
Register
VMUG Regional User Conference - June 17th, Bellevue (May 2010)
A full-day of in-depth
technical sessions, demonstrations and exhibits. It’s a great
opportunity to network with your peers and learn about virtual
infrastructure from the experts.
Registration is free; for more details and to register.
Microsoft Office
2010
Test Drive and Trials
(June
2010)
Learn about the new features
and benefits in Microsoft Office 2010; watch demos, review some
deployment strategies, take a test drive, download trial versions of
Office, SharePoint, Visio and SharePoint.
Microsoft Deployment Toolkit 2010 (MDT
2010) -
(June 2010)
A console, tools and guidance
to efficiently deploy Windows 7 and Windows Server 2008 R2.
Downloads, training, videos and other resources to help you
successfully automate deployments and create HyperV environments.
Database
Design Forum - NEW GROUP on the MSDN Community Website
(Jan 2010)
Under the SQL Server group,
this forum is focused on the database design. The discussions
include Access database design. Several of the authors and editors
from Teresa’s upcoming book on database design are among the
founding moderators and contributors to the forum; including Doug
Yudovich, George Hepworth, Jerry Dennison, and me <g>.
Microsoft
Deployment Toolkit 2010 (MDT
2010)
-
(June 2010)
A
console, tools and guidance to efficiently deploy Windows 7 and
Windows Server 2008 R2. Downloads, training, videos and other
resources to help you successfully automate deployments and create
HyperV environments.
SQL Server 2008
R2 RTM (May 2010)
SQL Server 2008 R2 takes data
management to “the next generation of computing.” Learn about the
new and enhanced features from multi-server management to end-user
reporting, watch a video,
get links to training and other resources
TLG Learning offers Free Seminars on Office 2010 (May 2010)
Learn about the new features
in Office 2010 during 1 1/2 hour instructor lead seminars offered in
Seattle and Bellevue.
They also provide a
complete list of their free seminars and other training.
Lunch n Learn - Access 2010 and SharePoint 2010
Better Together Tuesdays, 9 AM -10:30 PST
(Jan 2010)
Through July, Kathy Malone is
conducting Access 2010/SharePoint 2010-Better Together Lunch n
Learns from 9 AM -10:30 PST every Tuesday. Sessions share the
content that was presented at the SharePoint Conference to a wider
group of people. You’ll learn about the new features, how to migrate
existing aps and benefit from the open Q&A sessions. Enthusiasm for
the opportunity evolved into an active working group that is leading
the effort.
New participants are welcome at EVERY SESSION.
Live
Meeting Sessions
Dial-in number: 218-862-1000 Access code: 537996#
Brunch n Learn - Access 2010 and SharePoint 2010
Better Together
- Saturday Sessions 9 AM PST
(Jan 2010)
Through July, Kathy Malone is
conducting Access 2010/SharePoint 2010-Better Together Brunch n
Learns from 9 - 10 AM PST, every Tuesday. Session topics are based
on participant requests, they explore and expand on how to leverage
the capabilities offered in the new features and delve into some of
the hard core issues related to upgrading, incorporating changes,
transitioning to the 2010 Access data and UI macros, search
capabilities and navigation panes.
Live Meeting
Dial-in
number: 218-862-1000 Access code: 537996#
Office 2010 Tool:
Office Environment Assessment Tool (Jan 2010)
Is your system or network
ready for Office 2010? Use the Office 2010 Environment Assessment
tool to find learn about your current configuration and what steps
you may need to consider when preparing to migrate to Office 2010.
Then get the companion,
Application Compatibility Assessment and Remediation Guide for
Office 2010.
Windows 7 Test Drives -- No Installations required
(Jan 2010)
You get the full experience of
running Windows 7 without investing your time or resources to create
a test environment -- Microsoft has done that for you! So, with
just one click, you can explore Windows 7 features and go through a
collection of fully-featured virtual labs, complete with support
videos, step-by-step walkthroughs of features and Learn More
resources that delve into the product info to answer your questions..
Windows 7 -- Learning Snacks --
(Nov 2009)
A growing library of short
videos to make it easy to learn about new features and capabilities
of a Windows 7 and other Microsoft products.
Infrastructure Planning -- Windows 7 and Windows Server 2008 R2
connect securely without VPN (Nov 2009)
From an IT
standpoint, one of the great new capabilities of Windows 7 and
Windows Server 2008 R2 is the ability to securely connect clients to
the corporate network without going through a VPN. Learn about
features, benefits and options for planning and updating your
networks.
Virtualization, easier than
the bunny slope
(Sept 2009)
White paper from Windows IT
Pro, sponsored by AMD and HP - registration form required.
Tips and Techniques for Queries in Access 2007
(Sept 2009)
From the basics to advanced
topics, Luke provides insights and discusses some of the subtleties
that will really make a difference.
The Basics of
Writing and Testing VBA Code
Part 1 and
Part 2 (Sept
2009)
Learn
about code modules, write and call procedures, use variables and
even learn the benefits of documenting your code.
(Hot
List) |
|
Links, Tips and Downloads and More
...
PrimoPDF – The
World’s #1 free PDF Creator -
at least according to them. (July 2008)
PrimoPDF offers both a free and professional version that will
work with Windows 98 through Windows Vista and can work with over
300 file types. Willie really likes PrimoPDF for client
installations because it is remarkably simple and leaves a VERY
SMALL footprint. Let me know what you think.
Virtualization Via
HyperV
Are you ready? Are you hyped?
We’ve been talking about it and our launch presentations will cover
some of the key features and benefits. And NOW ... Microsoft has
released Hyper-V for Windows Server 2008!
Read more
Windows
7 Videos
(July 2009)
A convenient way to get first
rate guidance and training when you need it and at your convenience!
Learn about features to save time, be more productive, enjoy more
options and benefits.
SecureAble
- What can
Your Processor do?
(July 2009)
A great tool that identifies
some key features and capabilities of your processor chip, such as
the bit length, if the memory can store non-executable files, and
how it will support hardware virtualization. Did I mention it is
free? Learn more and get the free download.
SQL Server 2008
Migration Solution Center
---
Guidance about upsizing databases to SQL Server 2008.
In addition to guidance and other resources, there is also the
SQL Server Migration Assistants (SSMAs) ... that helps those
upsizing from Access, Oracle and Sybase to SQL Server.
Virtualization and
Hyper-V --- a “green” light for saving time, SPACE, money and other
resources (January
2009)
Ever which you could
replicate a desktop or other platform to test before deploying at a
client’s? That’s just one of the scenarios that can be quickly and
easily be solved using Hyper-V. Once you’ve tried it, you may
become a bigger Hyper-V advocate than IT!
You can download the server for free, read the white papers, take
some tutorials, and put it to work.
Training and exams books and other offers on virtualization,
even free e-learning
FREE E-Book -- Understanding
Microsoft Virtualization Solutions
Learn about saving energy and resources with the
Hyper-V
“Green” Toolbox FREE
Microsoft Hyper-V Server 2008
Tips & Tricks – Webcasts and Podcasts
from the Experts
Microsoft Webcast Home
provides links to valuable resources from
the experts. These webcasts and podcasts include great tips,
lessons, recommendations and other invaluable tidbits. and ... it’s
FREE!
Access 2003 Solution Center
This is a great starting point to find solutions, downloads, current
topics and links to the latest updates.
Free online Training –
Check out the courses
and send comments and send me an
email to suggest additional modules!
21
courses for Access 2007
18 courses for Access 2003
For additional and past postings check pages for Links, Downloads,
etc(Hot
List) |
|
Remove Spyware with Windows Defender ... for Windows Vista
FREE program
and free guidance --- Although Windows Defender is included with
Vista, many people are not getting the full benefit of the service.
Many people recommend using two or more spyware removal tools. They
should be run sequentially and although they compliment the services
of anti-spyware programs, spyware removal tools typically require
the anti-virus programs to be temporarily disabled.
To learn more and help your friends.
(Hot List) |
Access 2007
VBA
Programmers
Reference
Teresa Hennig, Rob Cooper
Geoff Griffith, Armen Stein
Order NOW from Amazon
REVIEW:
FIVE STAR REVIEW!!!!
This
book has extensive coverage of an area vital to Access developers and power
users, by a very knowledgeable team, ably led by Teresa Hennig. It includes
something more than an overview explaining new features of Access 2007. That
is important because: many features are new and changed in Access 2007, much
of what we do with VBA is automating and enhancing features we use manually
via the user interface, and the new Office 2007 user interface can be
overwhelming without a helping "hand up". Then the book covers VBA from the
basics to in-depth advanced levels. It is a worthy successor to the Access
2003 VBA Programmer's Reference and, in my opinion, "raises the bar" for VBA
books. I'll be using it as a reference in presentations to my Access user
groups, as well as a handy reference for my own work. I recommend it to
Access power users, as well as aspiring and working Access developers.
Larry Linson
Microsoft Office Access MVP
|
|
| CIPS
Connections
Teresa Hennig, Access MVP
interviewed by Stephen Ibaraki. FCIPS, I.S.P., DF/NPA, CNP, MVP
Teresa's thoughts and recommendations for user groups, developers,
managers and businesses in general. |
|
Interview
Response
...
You provided an incredible contribution Teresa!
The very fine interview clearly demonstrates your passion,
experience, insights, commitment, dedication ... It's also evident
that you spent considerable time in thinking about and providing
your responses. Your hard work and focus on value is very much
appreciated. In fact, I feel so inspired by your efforts!
Thank you for taking the time and special care with the interview
and sharing your considerable insights with the world. You are a
very talented and gifted person who touches the lives of so many.
Moreover, you are making a significant historical contribution to
our society, industry, and profession.
The world is
like spiders web, you touch one corner and the whole thing shakes.
And such is
your personal vision, voice, and work -- you touch all of us and
impact our vision and lives for the future.
Stephen Ibaraki,
FCIPS, I.S.P., MVP, DF/NPA, CNP
|
|
From My Client ...
May 4, 2007
Teresa,
"This could not have been any
truer!"
“I also have time for my clients. Actually, I'm as
passionate about my clients and their projects as I am about my
groups. As a consultant, I am incredibly fortunate to get to work on
projects from a wide spectrum of industries. Every project provides
new challenges for finding ways to manage data, streamline and
automate. Understanding my client's industries, operations and
needs, I feel like I'm their partner and it is important to provide
cost effective solutions. With the savings and benefits, my
solutions typically pay for themselves in a matter of months. My
biggest reward is knowing that I truly made a difference.”
"I am EXTREMELY PROUD OF YOU and equally happy! WOW!!!"
C. DiFranceisco
America First Search & Abstract, Inc. |
|
 Seattle Access
Groups members are offered a
10% discount on
FMS products. |
|
Supporting .NET User Groups |
10% discount to members!
Edge Tech Corp is a leading memory supplier. EDGE sells 100% compatible
Dell Memory and other DRAM upgrades. EDGE also offers flash drives and
portable hard drives.
|
|
What it Means to be an Access MVP
Thank you for sharing your passion and expertise and
invigorating communities globally ...
Steve Ballmer, CEO Microsoft
My thanks to the Access community for helping me to earn such a prestigious
award ... for three consecutive years. 2006-2007-2008.
Certificate
MVP
Page
|
|
|
