One-on-One
Learning Centre
Weekly Newsletter
In This Issue:
Friday, 13 February 2009    

In This Issue:

  1. A Note From Chris
  2. Article: How Did We Do? Perfect of Course!
     
  3. Article: How to Link Microsoft Access to a Spreadsheet
     
  4. How To Screw Up and Stay In Business
     
  5. Certificate IV in Workplace Training and Assessing

Upcoming Events

Networking Group
Tuesday 03 February 2009
Starts - 06:00  - 08:00 pm
Email to book your place
seminars@nqtraining.com

Weekly Recommended Reading List

Action Coach Books
Action Coach

The E-Myth Chapter 1
Micheal Gerber

Video Testimonials

     To find out what clients are saying about our training check out our  video testimonials

                      Click Here

The Law Of Success -

  You simply run out of
  things to fail at!

                 Chris Le Roy

 

 New Services:
Townsville Business Training, Training in Business, Sales Training, Townsville Sales TrainingBusiness
- Course Outlines
- Schedule
Computer

- Course Outlines
- Schedule
First Aid

 - Course Outlines
 - Schedule


A Note From Chris: The US Economy is kick starting! Build your referral strategies

Computer Article: How to Link Microsoft Access to a Spreadsheet

Business Article: How Did We Do? Perfect of Course!

Cranbrook Car Wash: Platinum Package Car Cleans for $129 (Save $70)

Dreamy.com.au: Valentines Day Featured Items

Business Interview Series: Listen to the first 5 minutes of my interview with Stef Mussap

Training Course: Certificate IV in Workplace Training
                           (LAST CHANCE TO BOOK IN FOR MONDAY)

Please add bulk@leroys.org to your whitelist or address book in your e-mail program so you have no trouble receiving future issues!

A Note From Chris

Hi,
   You can always tell when things are starting to turn around, people start really buying profusely and that is what is happening in the US right now. Since President Obama's inauguration my team and I have seen a surge in US transactions on our websites and via our products sold at places like Amazon.com, which is a great sign for both the US economy and Australias.  The world economy has a long way to go to get back into the shape it was prior to the collapse, but at least there are very positive signs happening.

     I was talking to a colleague in Brisbane yesterday who was telling me how bad it was down there and how their training company was struggling and he asked me how we were doing and I said, "Extremely busy."

    He asked me, "Why?"

    Well I am sure you know my comment, "a very strong and loyal customer base."  He also wanted to know what we were doing differently and the key is, we look after our existing customers and we keep them engaged.  

     We engage our customers by keeping in touch with them and providing free and comprehensive information.  Some of the techniques and strategies I have talked about over the last four newsletters -

    1. How to Build a Newsletter
    2. PIMP and H.O.E
    3. Provided Free Articles
    4. Sourced Free Books and Given them to Clients
    5. We have built a Loyalty Scheme
    6. Asked for Referrals
    7. Used Coupons

    In my search for quality reading and study material, I came across 19 Free eBooks from the Action Coach Group (formerly Action International). These books are really worth having a look at and they cover the following areas -

      Instant Brochures - Click Here to Download
      Instant Business cards and Letterheads - Click Here to Download
      Instant Direct Mail - Click Here to Download
      Instant Closed Door Sales - Click Here to Download
      Instant Classified Advertising - Click Here to Download
      Instant Flyers - Click Here to Download
      Instant Host Beneficiary - Click Here to Download
      Instant Loyalty Strategies - Click Here to Download
      Instant Newsletters - Click Here to Download
      Instant Point of Sale - Click Here to Download
      Instant Press Advertising - Click Here to Download
      Instant Press Release - Click Here to Download
      Instant Quotes - Click Here to Download
      Instant Radio Campaigns - Click Here to Download
      Instant Referral Strategies - Click Here to Download
      Instant Scripts - Click Here to Download
      Instant Strategic Alliances - Click Here to Download
      Instant Testing and Measuring - Click Here to Download
      Instant Yellow Pages - Click Here to Download

    This week I want to focus on referral strategies.  I would recommend that you download the Instant Referral Strategies eBook from Action Coach this week and read it.  The cheapest form of gaining clients during challenging times are through referrals.

    A referral is simply a customer that has been referred to you (generally through an indirect testimonial) and is interested in doing business.  One of the biggest mistakes businesses make is to not ask for referrals.  The cost of acquiring a referred client is virtually zero and they are generally far easier to convert. 

Why businesses don't ask for referrals regularly really astounds me?

   One of the key issues you must consider before asking for referrals, is to identify exactly what sort of referrals you want.  The key strategy to referral success is to decide on which target market you want referrals for and to go ask for them.

    For example, if you were a safety equipment supply company - you might ask your existing clients for referrals in say -

            1. Home Renovation Market
            2. Mining Sector
            3. Construction Sector
            4. Manufacturing Sector
            5. Large Marine Sector (eg. Large Ship Supply)
            6. Government Sector

   The best way to develop your referrals is to ask for actual introductions to specific companies or individuals.  In my example above you might ask for a referral/introduction to say Head Safety Officer at Sun Metals or Xstrata Copper Townsville.  By asking for specific referrals this helps your customers who will be referring them to know what to look for.

   Many times I have been asked to look for referrals for clients without a single idea as to what their business does or who their ideal client is.

   If you are in business, talk about your business, tell people what you do, who your ideal client is and where to look for them.

                                            MY PERSONAL REFERRAL REQUEST

   So here is my referral request.  As you know we have had 40 days and nights of rain and that has impacted on our carwash and car cleaning business.  So to help the boys down at the car wash we are looking to rebuild this business and we are looking for two types of clients -

                   1. Small to Medium Businesses who would like their cars cleaned on a regular basis
                   2. Car, 4WD and Bike Owners who want to clean their car either manually or through
                       the autowash.

   Anyone who refers three or more people or companies to us will receive a FREE Platinum Car Wash through our Autowash system (Value $14).   To help us identify that you have referred three or more people to us, simply get those people who do use the site to see our site manager Chris Cedar to give him their names or get them to join our mailing list for the Car Wash Site at - www.1on1.biz

  Here is the bonus for those members of the Car Wash Monthly Newsletter site.  Each person who is a member goes into a monthly draw for a FREE $29 Rapid Car Clean each and every month.  So there is definitely a clear benefit.

   When someone does give you a referral make sure that you do thank them, this is critically important. It is also important to reward them in some way.  The reward doesn't have to be massive but it is important so that the person who is making the referral does feel as though their work is appreciated.

Well once again, have a great week and remember one thing Success is a Habit.

Chris Le Roy
Managing Director
One-on-One Learning Centre
 
 How Did We Do? Perfect of Course!


By Ed Drozda

Customer Service is all the rage and what better way to assess how good you're doing than to ask your customers. It seems I'm asked to take "how are we doing" surveys all the time. One of the most amazing things I've ever encountered is when they actually told me how to grade them. "Our rating scale goes from 1-5 with 5 being the highest score. Please give us all 5's because we're in a competition and we'll lose out if scored lower or, our boss would not be pleased with less."

So what's that about Customer Service?

I admit this scenario doesn't occur as often as it used to and when it does it always seems to be a car dealership (really). But it makes me wonder- what do businesses really think about customer service and more importantly, what are they doing with all this feedback?

It makes people feel good when you ask for their input but unless they see action it amounts to nothing more than lip service; and you can bet they'll notice! How does your company view customer service? Is it ingrained in the culture and sincere or is it deemed a necessity without a heart? Are you genuinely interested in your customer's opinions? When you ask for a customer's opinion are you prepared to take action?

Customer service is best appreciated from the perspective of the customer. Here's a few things to think about:

  • My opinion counts but don't smother me- asking for my opinion is great but enticing me with gift cards and such anticipating my needs and
  • Be realistic- I know there are things you just can't do. Don't try to impress me with showy and unrealistic displays. They say if it seems too good to be true it probably is. Be real is all I ask.
  • Don't tell me how to think- if you really want my opinion let me give it. Don't tell me how to respond. When you do it becomes very clear I really don't matter.
  • If you're really listening, let me know- when you ask my opinion I figure that you have an interest in what I say. I realize that you can't act upon every request but if you want my opinion then at least be open to making changes for the better.
  • Be genuine- I'm your customer and I'm very important to your business. Treat me with value, respect and integrity. In return I pledge you my loyalty. It's not always about the cost of things. While they say you get what you pay for- I'm also willing to pay for who you are.

The next time you ask your customers for their opinion, ask yourself this: Do I want to hear what they have to say? Am I genuinely prepared to do something with the feedback I receive? If the answer to both of these questions is yes, I imagine you're enjoying a loyal customer base and all the rewards that go with it. If you answered no to either question (be honest), you might want to do some targeted analysis. After all, the customer is King and we are merely attendants in his Court.

Ed Drozda, MBA with E & D Associates- sounding board for the successful business leader

Looking to grow your' business? Are you having difficulty setting, prioritizing or reaching goals? Perhaps floundering business relationships and poor workplace communication is interfering with your' plans? Or maybe you're feeling that you have the answers but are consistently unable to get beyond the planning stage?

Through a mix of discussion, mirroring, mentoring, advising and challenging, E & D Associates will partner with you to tackle these challenges head on. Don't delay the action needed to grow your business; more information on-line at http://www.4eandd.com
 
How to Link Microsoft Access to an Excel Spreadsheet


By Paul Roger Barnett

Let's get started.

1. Click on the main database window and select 'Link Tables'

2. You can also do this by going to the file menu and selecting 'Get External Data' followed by 'Link Tables'.

3. Now select your spreadsheet

4. If there is more than one Worksheet held in the spreadsheet Access will ask you which one you wish to select. It will also ask you which range you wish to choose. Make your selection and click the 'Next' button.

5. You will now be asked if you want your table headings in Access to have the headings that are specified in your Excel spreadsheet. If you do then use your mouse to put a cross in the box that says 'First row contains column headings'. Click the 'Next' button to continue.

6. Access will now ask you what name you wish to give to your linked table. Click the 'Finish' button when you are done.

Click on the main database window and select 'tables'. You should see your linked table to the spreadsheet - It will have an Excel symbol. Double click the table to open and view. Try changing some data. Even if your spreadsheet is still open you will find the data has been updated there also.

The beauty of this is you could build forms or queries around your linked table and have it all updated back to the spreadsheet. You could even graph the data in Access.

Supposing you don't want to link to the spreadsheet, but want to keep all the data you have from it and create your own table. This is easily done within Access by creating a 'Make Table Query'. I will show you this in the accompanying video.

I hope this has given you an insight of the power of linking to an Excel spreadsheet within MS Access. Access makes tasks like this so easy.

For FREE Access ebook and videos click here
http://access-databases.com/ebook

Dreamy.com.au - Valentines Day Featured Items
Dreamy Lingerie - Burlesque Bustier Set
 Burlesque Bustier & Thong Set
R360648 - $89.00
Normally - $99.00		 Dreamgirl Lingerie - Luxury Lingerie Basket - Polka Dot Dreams Basket ($120.00)
Scandalous -
Chemise and Thong Set
R500980 - $74.00
Normally - $89.00		 Dreamy Lingerie
Flirty Florals - Plus Size Chemise 
r500725x-0001 - $89.00
 Normally - $99.00
How To Screw Up and Stay in Business
Business Interview With Stef Mussap


This week will be the last week in which you can sign up to receive a Free Copy of my first interview in the How To Screw Up and Stay in Business Interview series.

This week you can hear the first five minutes of the interview absolutely free by visiting our website or you can secure a FREE COPY of the interview on audio CDROM by registering. 

 We only have 20100 copies of the Free Audio CDROM Interview. Also keep an eye out for Chris's new book in 2009 ... How To Screw Up and Stay in Business!

Click Here to listen to the first 5 minutes of Stef Mussaps interview!
 
Cranbrook Car Wash - Coupon of the Week


Platinum Detail for $129
has been extended till the end of February 2009
PRINT OUT THIS COUPON WITH THIS SECTION IN TACT - COUPON FROM NEWSLETTER
Certificate IV in Workplace Training and Assessing


 The Certificate IV in Training and Assessment is the qualification required for those who wish to conduct vocational training and/or assessment.

This course is delivered over 5 days for the Full Course and 3 days for the Upgrade Course and is designed to provide participants with the learning experiences to acquire the competence necessary to be awarded this qualification and to deliver workplace training and assessment.

Units Of Competency:

TAAENV401A Work effectively in vocational education and training

TAAENV402A Foster and promote an inclusive learning culture

TAAENV403A Ensure a healthy and safe learning environment

TAADES401A Use training packages to meet client needs

TAADES402A Design and develop training programs

TAADEL401A Plan and organise group-based delivery

TAADEL402A Facilitate group based learning

TAADEL403A Facilitate individual learning

TAADEL404A Facilitate work based learning

TAADEL301A Provide training through instruction and demonstration of work skills

TAAASS401A Plan and organise assessment

TAAASS402A Assess competence

TAAASS403A Develop assessment tools

TAAASS404A Participate in assessment validation

Pre-requisites:

 There are no formal requirements however experience in the area of training and assessment for your required field is vital.

   For those doing the upgrade course you must have the BSZ40198 Equivalent Certificate.

  • Sufficient literacy and numeracy skills to complete the course

  • Access to an internet connection and computer

  • A working email address

  • Students can be expected to spend between 5 and 10 hours to complete each unit

Course Details

Date:        09—13  March 2009
                02—08 April 2009
                04—08 May 2009
                05—12 June 2009
                06—10 July 2009
                03—07 August 2009   
                07—11 September 2009
                05—09 October 2009
                09—13 November 2009

 Length:    5 days Full Course
               3 days Upgrade Course

 Time:       08:45 am to 5:00 pm

 Venue:    Unit 6, 286 Ross River Road
                Aitkenvale, Townsville

 Cost:       $2200 Full Course (Lunch included)
               Instructor Led Course

               $1300 Upgrade Course (Lunch included)
               Instructor Led Course

Registration:

To Register simply complete the Registration Form below and return the form with payment.

Click Here For The Registration Form

For more details on this program please call Chris Le Roy on 07 4728 5582 or email chris@nqtraining.com
 
You're receiving this newsletter because you have purchased a product, attended an event or subscribed to one of the One-on-One Learning Centre newsletters through www.1-on-1.biz or www.NQTraining.com. You can unsubscribe at any time by following the instructions at the bottom of the page.

We will never release, sell or give your name, email address to any unauthorized third party or organization. You will only receive email messages from us that contain requested information, new monthly articles, updated courses or announcements of new services.

Although we want to hear from you, PLEASE DO NOT REPLY to this email or send questions to this address. Simply direct your questions and correspondence to our website at http://www.nqtraining.com and contact us from there.

One-on-One Learning Centre
Unit 6,286 Ross River Road or P.O. Box 2297
Aitkenvale Q 4814 Townsville Q 4810
Australia    Australia

Telephone: 1800 66 00 00 or 07 4728 5582
Fax: 07 4728 5905

If you no longer wish to receive communication from us, simply click on the link below and enter your email address:

 http://www.nqtraining.com/remove/unsubscribe.asp