|
 
| |
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
and PNWADG
t t
Building
34 the Quinalt Room
-- May 15, 2012
t
t
Meetings start at
6:15 PM ...
Registration begins at 6
Pizza and networking break starts between 7:30
and 7:40
April 17th
Meetings ... Newsletter
l
The meeting location will change monthly!
l
Please mark your calendars with the date and location.
|
Date |
Room |
Note |
|
5/15/2012 |
Bldg 34 - Quinault |
Our previous meeting location (2010), park in lot for buildings
34 and 35 (off 159th Ave NE). |
|
6/19/2012 |
Bldg 40 -Steptoe |
Scheduled location for remainder of 2012. |
Campus map
? ? ?
Want to receive the newsletter by email? ? ? ?
Please ensure that you have specified the domain
DataDynamicsNW.com as a Safe Sender in your local AND in your
online email provider/service. Several accounts/servers
have rejected the newsletter as spam due to the number of links
to content. So, you may need to adjust the settings via your
online (Comcast, gmail, hotmail, etc) or business email provider. **One Month of On Demanding Training
from
Pluralsight
**
* * * * *
* * * * *
* * * * *
* * *
Standard Monthly Meeting Format
In
general, each group will have about 90 minutes for their meeting;
including general announcements, Q&A, and the main presentation.
In order to best server our members and presenters, the start and
end times will vary based on the specific circumstances.
We
invite everyone to join us for pizza and networking. Dues are
voluntary and help offset meeting costs. We ask those who have not paid
dues to
contribute $5 per evening.
* * * * *
* * * * *
* * * * *
* * *
Presentations
May 15th
2012
SAG Session:
(6:30 - 7:30)
Successful Project Management – The Human Factor; by Teresa Hennig,
Data Dynamics Northwest, Access MVP
PNWADG Session
(8:00 - 9??)
License Request Tracking System, by Dan Gramer, Turner Construction
Company
Looking for Presentation ideas ---
Download our 2012 Topic Suggestion List.
IMMEDIATE EVENTS
Seattle Code
Camp June 16th, Redmond, WA
(March 2012)
A full day of talking about
code with fellow developers. Sessions will range from informal
"chalk talks" to presentations. There will be a mix of presenters,
some experienced folks, for some it may be their first opportunity
to speak in public --- from throughout the Pacific Northwest and
beyond. We don't yet have a list of sessions on the site as we are
still collecting sessions from speakers. This is a Seattle developer
community event, not an even from Microsoft or any other company.
Everyone is welcome to present so long as it fits the Code Camp
guidelines.
Visit the website to learn more about participating or being a
speaker
Portland Code Camp,
June 2nd -- Eliot Center, Portland --- Free Admission.
(April 2012)
A full day of mixing with
developers from across the Northwest. Sessions will range from
informal "chalk talks" to presentations. There will be a mix of
presenters, some experienced folks, for some it may be their first
opportunity to speak in public. We don't yet have a list of sessions
on the site as we are still collecting sessions from speakers.
Everyone is welcome to present so long as it fits the Code Camp
guidelines.
Learn more about participating or being a speaker.
Download, Explore, Get Rewarded -- $20 gift card and chance to win a
laptop …
(May 2012)
A Microsoft Private Cloud
offers a comprehensive cross platform approach, best-in-class
performance, and the power to extend your applications out to the
public cloud whenever you need. Download your free evaluation of
Microsoft's Private Cloud, explore a Private Cloud Virtual Lab, and
receive a $20 Microsoft Online Store Promo Code. As a bonus, you
will also be entered to win a Lenovo W520 32GB laptop!
Register Now
Bringing the Cloud Down to Earth - A Hybrid Cloud Solution from
Microsoft & Fujitsu: Leveraging the Best Features of Public and
Private Cloud to Address Business Needs
-- Fujitsu and Microsoft May
23, 11 AM PT webcast.
(May 2012)
Cloud computing is a growing
part of our future – whether it is from the perspective of a
corporation, consumer, small business, home business, organization,
or for personal interests. As an Access developer, we need to be
aware of the options and opportunities that we can leverage to build
robust custom solutions and better serve our clients. Webinars such
as this are one way to see what others are doing. Then you can file
some of the bits and pieces away for future reference.
Register
Getting to Microsoft Office 365: The
right migration for your business
–
Webcast June 5, 11 AM PT TechRepublic/Microsoft presentation
(May
2012)
Gain
insights into preparing for and moving business activities to the
Cloud. Learn about the advantages, opportunities, and hear what
other companies have experienced. Free webcast –
registration required.
TechNet
Professional Subscription: 15%
Discount – Offer
Expires June 31, 2012
 Must
be a User Group Member!
(Apr 2012)
So … what are you waiting
for??
More Info
Microsoft software with no time or feature limits
o Beta
software
o Two
complimentary Professional Support Calls
o
Priority support in managed forums
o
Two Microsoft E-Learning collections
o
Online concierge chat
INETA's
Birthday Bounty -- Software Selection ...
INETA provides
structured, peer-based organizational, educational, and promotional
support to the growing worldwide community of Microsoft® user
groups. Join the celebration -- Prizes, gifts ...
training ...
At February’s meetings we enjoyed some great give-a-ways and were
introduced to some remarkable software and training offers from
INETA and sponsors. --- AMAZING OPPORTUNITY to get some
incredible software! Check these out for yourself and let me know
how they will help you to help others.
Ø
Typemock: Personal Typemock Isolator License
-- learn more at
Typemock.com
Ø
GrapeCity PowerTools: PowerSuite from
GCPowerTools.com
Ø
Infragistics: NetAdvantageUltimate -- 10 UI
toolsets in one package
and a one year subscription
Infragistics.com
Ø
ComponentOne: ComponentOne Ultimate
ComponentOne.com
Downloads and Resources
- Lots of new Links
Access 2010 Programmer's Reference
 By
Teresa Hennig, Rob Cooper, Geoffrey Griffith and Jerry
Dennison, contributors and editors, Armen Stein, Jeff Boyce, Albert
Kallal, Doug Yudovich, Ben Clothier. Tips contributed from our
esteemed colleagues Dane Miller, Garry Robinson, Steve Schapel, and
Larry Strange.
Contact
Teresa for a signed
copy -- or order from
Amazon with Teresa’s link.
Limited Time Offer for a Free Chapter
Chapter 7, Using VBA in Access
(provided by Wiley Publishing, who retains the copyrights for this
work.)
EARLY REVIEW: "I
have to say that you have surpassed yourself with the Access
Programmer's Reference this time. Very, very nice. I usually use
books like that for reference, to look up stuff when I have a
question, but in this case I have literally been reading it in large
chunks and finding it hard to put down. Especially the new
Access 2010 functionality, I have already learned heaps.
So thanks a lot for that, I just wanted to let you know that I am
mighty impressed with this one. :-) " Steve Schapel, Access
MVP
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
Limited Time Offer for a Free Chapter
Chapter 4, People, Organizations, Addresses
(provided by Wiley Publishing, who retains the copyrights for
this work.)
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!
Teresa,
I love your books. I have them all.
RibbonX 2007 helped me creating stunning ribbons for my Access
applications. Mudhafar July 2010
RibbonX
Customizing the Office 2007
Ribbon
By Robert Martim,
Ken Puls,
Teresa Hennig
Order NOW from Amazon
From the fundamentals through complete examples for Access, Excel and Word,
this book provides the information and walks you through the steps to
customize and create Ribbons in all three programs.
Limited Time Offer for a Free Chapter
Chapter 17
- Security in Microsoft Office
(Provided by Wiley Publishing, who retains the copyrights for this
work.)
Although written primarily for 2007, most aspects apply to 2010 and
several areas are applicable to Office 97 through 2003.
More excellent tips on working with Excel, visit site of co-author
Ken Puls, Excel MVP.
Calendar Year Dues ...
Demonstrate your support and appreciation ...
Still only $30 each and voluntary!
Or
Join
BOTH groups for only $45!
Since we started collecting dues, neither group as ever imposed a dues increase!!!
Please support your groups by becoming a paid member and
VOLUNTEERING ;~S
Members only drawings, downloads, software, reviews and more.
|
|
Seattle Access
Group Meeting
Building
34 the Quinalt Room -- May 15, 2012
Newsletter
SAG --
Successful Project
Management – The Human Factor; by Teresa Hennig, Data
Dynamics Northwest, Access MVP
As a consultant and
solutions architect, one of my primary responsibilities
is to elicit, understand, anticipate and incorporate (or
prioritize) client needs. As developers, we have all
experienced the challenges of responding to the dynamic
changes in requests and infrastructure in conjunction
with the pressures of meeting schedules and containing
costs. This session will focus on Effective Project
Management and Key Communication Skills that can turn
conflicts into partnerships.
Teresa started using Access in 1997 and started
her company as an independent consultant providing
business and data management solutions. Data Dynamics
Northwest reflects Teresa’s dynamic personality and her
innate ability to quickly grasp a situation and
formulate a solution. With a strong background in
business and project management, Teresa focuses on
providing cost effective solutions tailored to meet her
client’s needs. She loves Access’s rapid development
environment and the ability to quickly create intuitive,
user-friendly forms. One of her favorite aspects of
being a consultant is having the opportunity to work
with a wide variety of businesses, locally and around
the world. Key factors to Teresa’s success are her
positive approach and her ability to get people to
identify priorities and focus on common goals.
Looking for ideas for a main presentation?
Download our
2012 Topic Suggestion List.
Receive
SAG Newsletters
(Hot
List)
(Return
to TOP)
|
|
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
(Return
to TOP)
Newsletter
Building
34 the Quinalt Room -- May 15, 2012
License Request Tracking System, by
Dan Gramer, Turner Construction Company
Dan has developed a
License Request System that tracks user licenses and expiration
dates so that managers can be notified about approaching renewals.
Dan will be demonstrating his application and explaining some of the
approaches that he considered and the reasons that he chose the
techniques that he’s using. We’ll also explore how these concepts
and techniques can be applied to other scenarios involving
commitment tracking, scheduling, subscriptions and more. As with
most projects, there are plenty of pending enhancements. Dan will be
adding functionality to automate renewal notifications, so he’s
interested in hearing your suggestions and experiences.
An added bonus of this presentation is that all of the data tables
are actually lists on SharePoint, so we’ll get to see a practical
working demo. But the same approach could easily be used with data
stored in tables within Access or SQL Server.
Dan has 24 years of commercial construction experience
throughout the Western United States and Canada. As a manager of
Integrated Building Solutions (BIM), Dan’s primary focus is on
developing standards, establishing meaningful metrics, and spreading
knowledge through training programs at Turner.
Dan’s broad range of construction experience ranging from estimating
& project management to project systems lends to his role as a
Manager within Turner’s Integrated Building Solutions group. He
leverages technological advancement and implementation of policies
and protocols to support model-based business practices. Dan’s
approach has been a key factor in Turner’s rapidly accelerating
adoption of BIM nationwide which includes over 500 projects,
representing over $22 billion in work. Notable projects in the
Pacific Northwest include Nintendo of North America, Redmond Campus
Extension, 1823 Terry (Aspira) in Seattle Washington, Harborview
Inpatient Expansion Building and the Rental Car Facility at SeaTac
airport. See more at
www.turner-innovation-series.com
Would YOU like to Share Your
Experience and Expertise?
Send an email to
Teresa and get scheduled for our next Developer Demos event?
Looking for ideas for a main presentation? Download our
2012 Topic Suggestion List.
Receive PNWADG Newsletters
(Hot
List)
(Return
to TOP) |
|
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.office.com/b/microsoft-access/ ...
(Hot List) |
|
CONGRATULATIONS
2012 Microsoft Access MVP
 Teresa
Hennig
President
PNWADG
President SAG
"MVPs
make exceptional
contributions to technical communities, sharing their passion,
knowledge, and know-how. Meanwhile, because MVPs hear the opinions
and needs of many others in the technical community, they are
well-placed to share highly focused feedback with Microsoft."
Teresa was recognized with her first MVP award in April 2006.
Through her ongoing contributions and community leadership, she has
earned this prestigious award for seven consecutive years. As an
MVP, her connections have provided encouragement and assistance to
people throughout the Access community and have supported several
charitable endeavors.
Want to benefit from some of the
energy, ideas and opportunities?
Join us at one of the SAG or PNWADG meetings to meet Teresa and
several other Access MVPs.
Congratulations to Teresa and all of the other Microsoft MVPs~
Teresa's
MVP Profile
|
|
CONGRATULATIONS TERESA!
INETA
2011
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 - and more!!
(return to top)
ZDNet's Hot Topics:
Public vs Private Clouds: Who Benefits? TechRepublic
and ZD Net (May
2012)
Small and medium-sized
businesses have found public clouds
provide unprecedented flexibility and cost savings, but
public clouds aren't for everyone. Enterprises who have made big
investments in the data center, and for whom security is top
priority, are often more resistant to the idea of trusting their
critical systems to a third party. For them, a private cloud may be
the better choice.
View the webcast:
Tech Republic
White Paper - Remote support for PCs, Macs and Smartphones
(May
2012)
As developers, we need to
support our applications on an ever growing array of platforms. Tech
Republic has done a little research and has offered a white paper on
how LogMeIn Rescue works with most of today’s mobile and desktop
platforms.
Download
Windows Sever 2012 -- Top Ten – a Microsoft TechTrax Training
Webcast May 22, 8 AM and 6 PM PT
(May 2012)
Windows Server 2012 provides a
dynamic, highly available and cost-effective server platform for the
modern datacenter and the private cloud, which scales from a few
individual servers all the way up to multitenant-aware, multisite
environments. With the release of the next milestone of Windows
Server 2012 – it may be that this is one of the biggest releases of
Windows Server since Windows 2000; so many new things that it can be
overwhelming. Here’s your chance to get a personalized review of
“top 10” features / changes to the operating system that will have
the biggest impact on your environment. This demo heavy session is
guaranteed to get you excited and ready to try them yourself.
View Demo
HTML5 Oxygen Blast
Training – Free Video training by Intertech (May
2012)
What is HTML5? Why is
it such a hot buzzword now? Why does it matter to Access
developers? Watch the video and gain some insights into how using
HTML5 can extend and enhance your Cloud solutions and integrations.
Learn more
Top
10 Tips for Optimizing SQL Server Performance – Quest Software
whitepaper
(May
2012)
Read SQL Server expert Kevin Kline’s white paper “Top
Ten Tips for Optimizing SQL Server Performance” where he
discusses 10 of the most important things you should know about SQL
Server performance. Each item is a nugget of practical knowledge
that you can immediately apply to your environment.
Download
SQL Server 2012 – Versions and
Downloads
(April 2012)
Learn it, Try it, Use it … Read about
SQL Server 2012 highlights and capabilities; compare the versions;
download trials, free versions and complete editions.
SQL Server Virtual
Launch Event -- Through
June 30, 2012
(April 2012)
Also, for a deep dive on all things
SQL Server 2012, check out the SQL Server 2012
Virtual Launch Event. All content from the Virtual Launch Event
will be available until June 30, 2012. The event features 30+ webcasts from
SQL Server 2012 experts in addition to a number of other multimedia features
from Microsoft partners.
WURFL -- An Essential
Mobile Website Technology
White Paper by Dino Esposito Sponsored by DevPro Connections
(April
2012)
The file behind the mobile websites.
This paper provides an introduction into Wireless Universal Resource File (WURFL)
--- and what it means to your business’s mobile strategy. It will explain
how to integrate WURFL into your ASP.NET applications to support mobile
websites. Download from
DevPro Connections.
Excel Skills Builder Video Series -- Free Training from Microsoft
(Feb 2012)
Learn how to customize a workbook
or collaborate on a spreadsheet with a teammate. See how to make your data
look great by adding diagrams, charts and much more. The free
Excel skills builder
training videos teach you clever tips and tricks and show you how to get
more from your data by guiding you through
short, quick lessons.
Mr Excel – Excel tips and support and … Learn Excel from Bill Jelen
(May 2012)
MrExcel represents an entire community
of Excel power users how are sharing their expertise, experiences and time
through blogs, podcasts, tips, forums and links to a wealth of other
reference materials. Among the links you’ll find Bill Jelen’s podcasts and
books – including several that can be invaluable tools in Access projects –
such as the random number selector. Visit the
website,
or check out the
blog and videos.
5 Steps
to Successful Backup & Replication for Hyper-V By WindowsITPro
(Dec 2011)
As developers, we may be managing
our own serve and Hyper-V environments without the benefit of a
corporate IT staff to maintain it. This on demand webinar provides
valuable tips that can make these admin tasks easier – and more
effective.
In this web seminar learn the 4
critical steps to ensure virtual machines are protected on Hyper V.
Key takeaways from this event include:
> Scalable host-based replication
for Hyper-V
> Easy management with agentless
backup strategies
> Deduplication strategies to save
disk resources for backups
Register
Windows SkyDrive --
Redesigned; Simplified Sharing and Collaboration
(Dec 2011)
Learn now the new design and
features in SkyDrive simplify sharing and make it more app-centric,
particularly for Office. Now you can Share a file from within the
app and complete your task without having to worry about which
folder it is in because SkyDrive lets you share or permission
individual files within a folder. This works for Office documents,
photos, or any other type of file. Get more info from the
Windows blog posting.
Office
WebApps .. get started for free
(Nov 2011)
Free SkyDrive account with your free Windows Live ID …
See how easy it is to share and
collaborate
Try Office 365 for
Free!
(Dec 2011)
Sign up for the
free trial offer, links to demos and forms, learn how to be more
productive while saving time and money.
Office 2007 and SharePoint 2007 Service Pack 3 information
(Nov 2011)
Learn about the timing
and options for support, upgrades and transitions from Office 2003,
2007 and 2010 (yes, there is a forecasted end of mainstream support
date for 2010). As they say, knowledge is power; so now you can use
the when and what to help your client’s make informed decisions
about their current and upcoming applications and projects.
Learn More
SQL Azure Labs … Social Analytics
(Nov 2011)
A new way to integrate
social media with business apps. “Social Analytics” allows you to
connect with customers and quickly respond to their comments and
concerns.
Sign up
Cloud Computing – a
Non-Technical Overview, by TechNet
(Nov
2011)
It’s time to cut through some
of the hype and get a basic understanding of what Cloud Computing
really is, the impacts it will have … and where it fits in YOUR
future.
Read the article from TechNet …
Learning about the Cloud? Watch the video … How to Build a
Private Cloud
(part 1)
(Nov 2011)
From virtualization to a
Private Cloud; the benefits of automating IT services.
Part one of four by Chenley
Learn about Microsoft’s Offerings for Private Cloud
(Nov
2011)
Purported to have the best
price point for private cloud solutions, Microsoft is offering a
wealth of services, documents and resources to help businesses,
professionals and individuals make informed decisions and have
smooth transitions into Cloud computing.
Learn more:
Office
365 -- -More info and More Resources
Download an Office 365 trial from
Take it for a spin by getting started with
TechNet videos and articles
Office WebApps .. get started for free
(Nov
2011)
Free SkyDrive account with your free Windows Live ID …
See how easy it is to share and collaborate.
Learn more
Best Practices for Migrating to Office 365 – White Paper from
Windows ITPro
(October 2011)
This whitepaper contains
valuable guidance to help you understand what is involved, learn
about the key elements, and follow best practices. Download the
whitepaper from
Windows ITPro
101 Code Samples For Office 2010 Development
(September
2011)
Microsoft has compiled a set
of VBA code samples for select features or feature sets that you can
incorporate or modify to work in your
applications. Each sample consists of about 5 to 50 lines of code,
and includes comments describing the code and setup. All from
Microsoft MSDN.
Free Online Database Class – and more
--
(September 2011)
Thanks group member, Kathy S,
for sending these links to free classes offered by Stanford
University. The courses will be available this fall – from October
through December.
Intro Databases:
Machine Learning:
Artificial
Intelligence:
Excel Shortcuts – Keystrokes to help you Work More Effeciently –
TechRepublic Article (August
2011)
Since many of our projects
evolve from Excel spreadsheets, it only stands to reason that many
Access users and developers also work with Excel. TechRepublic is
providing a list of Excel shortcuts that can save time and reduce
errors. In addition to using them yourself, you may buy some
goodwill by sharing the tips with your clients and users. Get the
list from TechRepublic (posted August 1, 2011).
Webinar: A Simple Approach to Desktop Virtualization Security (August
2011)
Whether you’re concerned for
your own systems, connecting to your clients, or supporting an
Enterprise, you need to be alert to the ever changing landscape of
security threats and some effective approaches for minimizing risks
while leveraging the benefits of mobilization and virtual desktops.
This on demand seminar is provided by ITPro and sponsored by
Citrix. Click to
register.
Free Preview of
FMS Total Visual CodeTools 2010 (July
2011)
Hurry and try it NOW --- Fully
functional with all versions of Office and VB6 you use. Offer lasts
through July – so try it and you’ll see why so many rely on FMS
tools!Visit FMS and
Get the FREE download!
Office 2010 SP1 Downloads and Answers
(July 2011)
Those of you using Office
2010, may be wondering if you should install SP1, and if you do,
what are some of the consequences that you should be prepared to
deal with. A search for Office 2010 SP1 Issues could overwhelm a
person with posting about both the issues it fixes and the issues it
creates – during and after installing. When you’re searching for
answers, you might find useful information and assistance at
Microsoft
Answers. You can also find Access related issues at
the
Access Blog
Webucator –
Instructor led Online and Onsite Training
(July 2011)
Webucator
offers a wealth of
technology and business training -- with a wide range of
Microsoft training,
including
Access training.
The content ranges from
introductory courses to advanced programming. The SAG and PNWADG are
fortunate to welcome Webucator as a new sponsor. Please check out
their offerings and … look forward to special opportunities.
Back up and Recovery .. WinIT Pro White Paper
(June 2011)
This article is an excellent
follow-up to discussions a recent meeting about online backup
services.
Download the paper on how to select a provider for online
backups.
On the topic of Online folders
-- The Tech Republic Article (June 2011)
Dropbox: Convenient, absolutely; but is it Secure?
Creating Window Installation Files (May?June 2011)
At the May meeting, we
briefly discussed tools for creating installation files. A member
recommended
NSIS
as a good, open source option. Check it out, and share your opinions
and experience with the group.
Access Tip - Streamline Reporting on Recurring Data Imports (May 2011)
Leading the way with
scenario based articles, Mike Stowe walks you through creating an
Access database to import and analyze data from a text file,
complete with sample database. Visit the Microsoft Access Blog for
this new article on how to make data easier
Link to article on the
Microsoft Office Blog -
Or go directly to
the
article:
PLEASE
- use the blog post to share thoughts about the article and your
preferences about scenario
based articles -- as compared to feature
based. --- For those who are hesitant to make public
comments, you
may send your feedback in an email to accesshelp@microsoft.com
Pluralsight Training --
Get One FREE Month of On Demand Training
-- (April 2011)
What
would YOU learn if you could take as many courses as you can
complete in a month? Well, this is your chance to build your
expertise, expand your horizons, and then ... share with the group.
This invitation is open to ALL group members, and you do not need to
be present to be selected. To be
considered, please send an email to
Teresa and
express how you will put the newfound knowledge to good use ---
professionally, personally, for the good of the community. Many of
you volunteer your time and expertise to help others, and this
training may be an excellent way to increase your skills.
The Essential Guide to Virtualizing Desktops and Applications by
Windows ITPro
(May 2011)
With the features and mobility
expectations for today’s programs, it can be beneficial to have a
basic understanding of the key factors and options associated with
virtual desktops and applications. For those of you wanting to
learn more, Windows IT pro has offered a
guide for download.
Hosted or On-Premises Archiving - OnDemand Presentation by
Windows ITPro
(May 2011)
With the convenience and
affordability of external drives, it might seem that local backups
are the easy answer. This presentation will cover several key
factors that you should consider when determining what back-up
option might be better for a given situation.
Sign up
Clonezilla - Image Your Drives for Free -- (Tech Republic article
and instructions for using Clonezilla)
(April 2011)
Disc imaging is a valuable
resource for disaster recovery, but it can also be used for
maintaining and upgrading systems. Clonezilla allows you to clone
the image of a machine and use it to restore the image to a single
machine or multiple machines. In this
Tech Republic article, Jack Wallen provides the background and
walks you through the process.
Learn Access By
Crystal --
(Nov 2010)
Access MVP, Crystal shares tips, videos and helpful links.
Check back often.
Official Play List
Removing Crapware - from
TechRepublic
(Nov 2010)
One of the annoyances of a new computer
is the amount of crapware that comes preinstalled. TechRepublic has
a free report with suggestions and tools for identifying and
removing unwanted programs and files. It also mentions why you don't
want to defrag Solid-state drives (SSD), such as those in some
high-end laptops. Read or dowload the file from
Tech Republic.
AquaSnap 1.3 -
Arrange Windows on Your Desktop
(Sept 2010)
Nurgo Software offers a free
tool that allows you to snap and anchor windows to the edge or
corner of your desktop. It is compatible with all versions of
Windows and can replace Aero Snap and Aero Shake in Windows 7. Read
more and get the download at
www.nurgo-software.com/products/aquasnap
Database
Design Forum - 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>.
SQL Server 2008
R2 Digital Tour (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
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. Excerpts
from
Beginning Access 2007 VBA by Denise M. Gosnell from
Wrox (ISBN
978-0-470-04684-5, copyright John Wiley & Sons, Inc. 2007, all
rights reserved.
(Hot
List) |
|
Links, Tips and Downloads and More
...
Mr Excel – Excel tips and support; Learn Excel from Bill Jelen (May 2012)
MrExcel represents an entire community
of Excel power users how are sharing their expertise, experiences and time
through blogs, podcasts, tips, forums and links to a wealth of other
reference materials. Among the links you’ll find Bill Jelen’s podcasts and
books – including several that can be invaluable tools in Access projects –
such as the random number selector. Visit the
website, and check out the
blog and videos.
Rick Fisher's Find and Replace
(May 2011)
Rick's tool will search through the design elements, such
as the table and field names and modules (not the data). It can
change the names of objects throughout the entire database. Version
9.0 works with Access versions from 2000 through 2010. Visit
Rick's site for
more details and the download.
Doug Steele's Web Site
(May 2011)
Access MVP
and author of “Access Solutions” shares tips and links to
other resources on his
website.
Optimize Access when using ODBC data source
(May 2011)
Article referred to in
George Hepworth's presentation April 2011 on DNS Less data
connections.
KB286222
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
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.
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)
(Return
to TOP) |
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 seven consecutive years. 2006-through 2012.
Certificate
MVP
Page
|
|
(Return
to TOP)
|
