Posts Tagged ‘Access’

Get your Top Performers involved!

January 12th, 2011 - by Angela

top-performersThe other day, I was teaching a friend how to do some tasks in Access.  She was getting so frustrated because she could not grasp a couple of the step-by-step instructions.  She kept messing up or not being able to wrap her brain around how Access was functioning.  I told her that she needed to learn to think like Microsoft.  She said that she just wished I could dump my brain into her brain. 

She said that what I was teaching her was not something she could learn from a book.  She had to really play with the software and learn from someone who had used it before, who was able to “teach” it.  She had tried to get a couple of people she worked with to help her.  Both of those people were top performers on her team, who had used Access for years.  One of her team members did not have the time to help.  The other team member tried to help but was not able to help her learn.  He just wanted to click quickly through the steps and have her memorize what he did. 

I know that I have had those same thoughts when learning a new application.  The learning curve is so steep some times.  How often as a company do we wish the same thing?  How do we mine our top performers knowledge to make it available to everyone else without creating a situation like my friend was in at her company? 

I have thought of a few ways that companies might be able to help with this.  In every part of our job, we must all work as efficiently and effectively as possible.  We cannot leave folks behind and expect to have our team function at its top potential. 

One of the ways I thought of was to have your top performers write out “how-to” steps or even set up a blog.  One client I worked with had me sit down with each of their team members and work one-on-one to see what the top questions were in relation to the software they used.  After working with them for a few days, I discovered many duplicate questions.  I then developed a “how-to” manual for them to share with team members.  The newer team members said that this was a valuable resource since it got them up to speed quickly with the tips and tricks from the more veteran team members. 

Another way to help mine information from your team would be to have a professional circle or brown-bag lunch time to share ideas and questions.  I have participated in one of these many years ago and really learned so much.  At that point in my career, I was a new trainer and needed all the guidance and wisdom from some tenured trainers.  The group was structured informally but everyone agreed to stay positive and not turn it into a gripe session.  To help with this, we had a trainer come in to facilitate the discussion and keep it on track.  The goal of the group was to help each other so that our team of trainers could be the best among the different locations. 

These are just a couple of ways to start thinking about how to get your top performers to share their secrets.  If you can provide incentives to help them share, that is great.  However, your team may not be able to provide much more than a complimentary letter in that person’s file.  Either way, it is important to share our software tips and tricks for the success of the whole organization!

Certification

February 16th, 2010 - by Angela

ub_cs_graduationHave you ever thought about becoming Microsoft certified in Word, Excel, Access, Outlook or PowerPoint? I’m surprised at how many of the clients I train have not thought about adding a Microsoft Office Specialist certificate to their list of accomplishments.

How many times do people go to job interviews and say they know Excel at the expert level but are not able to deliver once they are hired?  I think it would be so important to be able to back up my skills with a world recognized certificate from Microsoft.  Not only would I be able to say that I knew the software but Microsoft would say that I knew the software.

I must note that Microsoft has not made it easy to understand the certifications.  The name of the certification has changed from MOUS (Microsoft Office User Specialist) in the 97 Office version to MOS (Microsoft Office Specialist) for 2000, XP, and 2003 versions to MCAS (Microsoft Certified Application Specialist) for 2007 version. Since I have been certified since the 97 version, I sometimes don’t know what to call myself.

Each certification, though, has definitely contributed to my career path. Having the certifications on my resume has helped me to succeed in reaching several of my goals. Not only have they contributed to my life, but I’ve watched many students build their confidence in their skills by studying for, taking and passing the tests.

Several times I’ve done one-on-one training sessions for clients that are studying to take a Microsoft certification test. The training is an investment that can have a big payoff if you are able to advance in your career with the new certification. 

If you are interested in taking one of the certification exams, start at the Certiport website. (http://www.certiport.com) They administer the Microsoft exams.  If you need some training to help study and get ready for the exam, let me know! At Versitas, we love helping you succeed!

There’s a Template for that!

January 25th, 2010 - by Angela

word-template-createRecently one of my family members, after many years of contemplation, decided to open her own business. She gave me a call and asked me to help her create some of the forms she’ll need.  I was impressed that she had already assembled some paper forms that she liked to use for ideas when we created the ones for her soon-to-be formed new company.

Initially we tried to start from scratch, using her logo and colors, to create the forms.  We worked for a while on this and did not get very much accomplished.  Then, it hit me…TEMPLATES! I am a little embarrassed to say that I didn’t think of doing that first. They should take away my trainer badge some days!

I immediately opened the list of templates within Excel. We found some great invoices, receipts, statements, etc.  We were able to start with the forms she liked and then customize them to fit her logo, design, and contact information.  We also went into the Word templates and created a fax form (that she could use to fax from within her computer or print and use with her fax machine) and letterhead. She was delighted with the end results of our forms.

Next, I showed her how she could create labels with mail merge using Word and either her Contacts list, Excel spreadsheet list, or Access database table.  We also discussed how she could import and export data back and forth between the different Office applications.  She was excited at how many options there were. 

After creating the different forms, we decided to design a PowerPoint presentation for her to use in sales meetings with potential clients. I didn’t make the same mistake that I had with the forms.  We went straight to the templates this time.  I showed her the design slides that we could customize with her logo, colors and information.  She was glad that there were even some presentations with content for sales presentations to guide her.

If you own or are opening your own business, it would be well worth your time and money to invest in training.  A trainer could show you how to make your business operations work more efficiently by using Microsoft Office effectively. I definitely believe that it is better not to re-invent the wheel when you could save time by customizing templates that others have willingly shared.

Software Training in a De-personalized World

August 3rd, 2009 - by Angela

Last week I was working on my laptop in the living room and received an email from my husband. He was in our bedroom study…just a couple of steps away in the room next to me.  I’m not kidding!  In another instance, a friend of mine told me about the time she found her four children all sitting in the same room together but arguing with each other on Facebook.  What’s happening here?

 

On a television show last month, I watched an interview with a dad whose daughter had racked up thousands of text messages in one month.  Fortunately he didn’t have to pay the almost $3,000 that the bill would have been because he had an unlimited texting service plan.  Instead of talking to the daughter in person, the father texted her to tell her that she was grounded from texting.  These are three examples of de-personalization in our everyday lives.

 

Advances in technology (such as chatting online, communicating via Facebook and Twitter, and texting on cell phones) have depersonalized so many social parts of life.  It’s not necessarily all bad, but it’s important to be aware of it.

 

In many of my software training classes with Versitas, I hear students comment on how important human interaction is to help them learn.  When offered online versus in-person classes, I have many students that choose to attend the in-person training class.  It seems that many people are craving training that is taught by an actual instructor in the classroom.  Especially when employees are sitting in cubicles all day communicating via email and phone, in-person training often seems to boost morale by allowing actual human interaction between the employees.

 

Although online classes might be the perfect match for some students, other students consistently prefer to attend an instructor-led training class.  Every training method must compete for the attention of students, who must often check email or voicemail during the training.  This is where in-person training can be very helpful.  The personal touch of meeting eye-to-eye with an individual gives a personal contact that happens during in-person training. The nuance of feeling the moment and understanding when an individual needs that extra bit of attention is an important ingredient and helps to really teach the skills that are needed in today’s corporate environment.

 

Individuals in a corporation like everyone else want to know that they are being listened to and taken seriously.  Learning new applications or programs like Microsoft Access, PowerPoint, Excel, etc., can be anywhere from overwhelming to monotonous and impersonal when an individual tries to learn something on their own.  With an instructor carefully listening to their questions and needs, I believe it can help create a better learning experience.

 

After all, isn’t that what it’s really all about?