AM-Win Newsletter.

May 2013

In this edition

• Printing our newsletter articles in PDF format.
• Archived copies of our newsletter
• AM-Win latest version information - Update available - Version 9.044 upgrade is now on the web and ready for download. Click here to access download site.
• Survey  - what word processor do you use
• Ransomware warning from The Australian Federal Police
• AM-Win Support Solutions
• Cash banked in error
• Defining additional Credit control options
• Windows Tips
• Outlook auto complete
• Word Tips
• Create a basic form in Word 2007 and Word 2010
• Excel Tips
• Freeze the top row of your sheet to keep your headings in view.
• Split names by using the Convert Text to Columns Wizard
• Whoops
• Jokes

Printing our newsletter articles in PDF format. 

Click on the PDF image below each article to view and print article in PDF format.  Please note that we will always open a PDF file in a new window.

 Archived copies of our newsletters

Did you know that we archive copies of our newsletters for 12 months - if you've missed one or want to chase up an article that you've read click on Newsletter in the top menu on our site and select Newsletter Archives. From December 2012 we have also included a summary of the newsletter content for the archived month to help you find relevant content.

Latest Version Information

Version 9.044 upgrade is now on the web and ready for download.

Click here to access the update. For program enhancements view "About" in the AM-Win menu after updating. This Version 9 download will upgrade any existing Version 9 of AM-WIN without an Install code or license files.

Don't forget to backup your data before upgrading.

If you have any AM-Win version prior to version 9.0 please click here before updating.

 

Survey

We are keen to make sure that the information that we provide in our support documents is useful to our readers. In this survey we have asked you to let us know the version of MS Word that you are using or what word processor you are using if not MS Word. If you are using a Mac with Word please select other and add the Mac version of word that is installed.

Ransomware Warning from Australian Federal Police

Since late 2011, we’ve been observing a growing trend towards the use of “ransomware” for the purposes of cybercrime and online extortion. Recently however, users have started to report the first versions of a variant specifically targeting Australian computer users, pretending to be from the Australian Federal Police (AFP).

Australian Federal Police scam is a screen locker infection that locks your computer screen and makes your computer unusable. The infection also installs malware on your computer.

The PC version displays a message purporting to be from the AFP claiming that the victim has violated one of a number of laws ranging from copyright infringement to distributing child pornography -- although the laws cited bear no relationship to real Australian laws. The screen message and variants are displayed in the PDF document at the end of this article.

We suggest that you print the article and distribute it to anyone who has access to the internet as ransomware infections may be linked to visiting websites that contain illegal music and software downloads, or in some cases, pornography. In fact, some of these websites are known to be fake sites designed to snare visitors – as it’s thought they’ll be more likely to pay the ransom because they already feel guilty for visiting the site in the first place!

You can however rest easy in the knowledge that the AFP have not blocked your computer if you ever see the screen message displayed! But make no mistake, ransomware can still cost you valuable time on the phone with technicians, and if not removed properly, your computer may be at risk of further infection. If you are infected please contact your supporting technician or if you are computer savvy and have the appropriate Malware or Virus programs installed you can search Google using the "key words " AFP ransomware removal" to find out how and remove it yourself.

 

AM-Win Support Solutions

CASH BANKED IN ERROR

Sometimes when doing a banking in Am-Win, the cash figure is accidentally added to the banking. This is easily fixed via a Journal.

This document will show you how to find out the dollar value of the cash banked, and then how to process the journal to get the cash back into the deposit screen.

EXAMPLE – I have done a banking today for my credit card transactions and forgot to zero the cash when I processed the banking.

To find the value of the cash, go to the 1010 ledger (or 1011 – 1019 if you have your credit card entries being displayed in a different Till), and click on the F3 Enquiry button.

Search for and highlight the entry showing the Deposit Posting where you banked the cash and double click and then click on the Go button. This will preview the original deposit and you can see the value of cash which was on the Deposit Posting.

Then you can do a Journal to transfer the value out of the relevant Bank Account (1029-1029, generally 1020) and back into the Deposit screen (1010-1019, generally 1010).

Using the above example the cash in the deposit screen will now be increased by the journal value of $958.65 and the Bank Account will now have an entry to correspond with the original deposit to balance against the Bank Statement.

 

Microsoft Outlook

Delete a name from your Auto Complete list in Outlook 2010

The feature where the names automatically pop up when you start to type an e-mail address in the recipient box in Outlook e-mail is called “Auto Complete”.  It is a handy feature if you email people regularly, but can cause you problems if you are not careful.

If you type an e-mail address incorrectly or make a typo it will still be added to the auto complete list.

So – if you want to delete a misspelt name or typo from your Auto Complete list in Outlook 2010… what do you do?

Just start typing the name in.  When it appears in the auto complete list, simply look to the right of their name.  You should see a cross or a check – ie a delete button.  Just click on that, and that name and email address is removed from your auto complete list.

  

Create a basic form in Word 2007 and Word 2010

This month we have published a document on how to create a form in Word with text fields, drop down boxes and a date picker. The document will provide with  you the steps to add form fields (Content Controls) to a Word 2007 or 2010 document. Click on the PDF logo below to open, save or print the article.

 

Freeze the top row of your sheet to keep your headings in view. 

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007:

1. Click on the “View” tab of the ribbon
2. Look for the “Window” group
3. Click on “Freeze Panes”
4. Click on “Freeze Top Row”

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

Split names by using the Convert Text to Columns Wizard

Do you need a way to take the First Name and Last Name that's in one column and split into two columns with the first name in one and the last name in the other. Click the PDF logo below to view, print or save a comprehensive support article courtesy of Microsoft to show how it's done in Excel 2010.

Note:

Please note that we do not provide support for our Word and Excel tips as they are provided by a third party. If you need further information why not try using Google - Cut and paste the heading of our tip into Google's search box. You'll be amazed at the information available.

Whoops

We now embed videos from sites such as UTube into our newsletter.  You will now be able to download videos and view them in full screen, providing the functionality is available on the host site. Firefox users may need to download the latest flash player.

Jokes

Nothing too strenuous

Upon hearing that her elderly grandfather had just passed away, Katie went straight to her grandparent's house to visit her 95-year-old grandmother and comfort her. When she asked how her grandfather had died, her grandmother replied, He had a heart attack while we were making love on Sunday Morning."

Horrified, Katie told her grandmother that 2 people nearly 100 years old having sex would surely be asking for trouble.

"Oh no, my dear," replied granny. "Many years ago, realizing our advanced age, we figured out the best time to do it was when the church bells would start to ring. It was just the right rhythm. Nice and slow and even... Nothing too strenuous, simply up on the Ding and down on the Dong."

She paused to wipe away a tear, and continued, "He'd still be alive if the ice cream truck hadn't come along."

That's the one.

When the store manager returned from lunch, he noticed his clerk's hand was bandaged, but before he could ask about the bandage, the clerk said he had some very good news for him.

"Guess what, sir?" the clerk said. "I finally sold that terrible, ugly suit we've had so long!"

"Do you mean that repulsive pink-and-blue double-breasted thing?" the manager asked.

"That's the one!"

"That's great!" the manager cried, "I thought we'd never get rid of that monstrosity! That had to be the ugliest suit we've ever had! But tell me. Why is your hand bandaged?"

"Oh," the clerk replied, "after I sold the guy that suit, his guide dog bit me."

I was just joking..

There was this guy at a bar, just looking at his drink. He stays like that for half of an hour.

Then, this big trouble-making truck driver steps next to him, takes the drink from the guy, and just drinks it all down. The poor man starts crying.

The truck driver says, "Come on man, I was just joking. Here, I'll buy you another drink. I just can't stand to see a man cry."

"No, it's not that. This day is the worst of my life. First, I fall asleep, and I go late to my office. My boss, outrageous, fires me. When I leave the building, to my car, I found out it was stolen. The police said that they can do nothing. I get a cab to return home, and when I leave it, I remember I left my wallet and credit cards there. The cab driver just drives away."

"I go home, and when I get there, I find my wife in bed with the gardener. I leave home, and come to this bar. And just when I was working up the courage to end it all, you show up and drink my poison."

Come into my humble shop!

A married couple was on holiday in Jamaica. They were touring around the marketplace looking at the goods and such when they passed this small shoe shop.

From inside they heard the shopkeeper with a Jamaican accent say, "You tourists! Come in. Come into my humble shop!"

So the couple walked in. The Jamaican said to them, "I have some special sandals I think you would be interested in. Dey make you wild for sex."

Well, the wife was really interested in buying the sandals after what the man claimed, but her husband felt he really didn't need them. He was satisfied with things they way they were. The Jamaican quickly figured quickly that the wife felt like she was missing out.

The wife asked the man, "How could sandals make you want to have sex.?"

The Jamaican replied, "Tell him to just try dem on, Lady." So the husband, after some badgering from his wife, finally gave in, and tried them on.

As soon as the husband slipped them onto his feet, he got this wild look in his eyes. There was a level of excitement his wife hadn't seen in many years! In the blink of an eye, the husband grabbed the Jamaican, and bent him over a table,

The Jamaican began screaming, "You got dem on the wrong feet! You got dem on the wrong feet!" 

 

Office, Excel and Windows logos are the property of Microsoft and are used for reference points only.